Learn your way! Get started

SharePoint 2013 Developer, Part 05: Programming Lists

with expert Tim McCarthy

Watch trailer

SharePoint 2013 Developer, Part 05: Programming Lists Trailer

Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 10/14/2013
Level Level Advanced
Runtime Runtime 1h 29m
Platform Platform Major browsers on Windows Major browsers on Windows Major browsers on Mac OSX Major browsers on Mac OSX Mobile Devices Mobile Devices
Closed captioning Closed captioning Included
Transcript Transcript Included
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs N/A
Sample code Sample code Included
Exams Exams Included

Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More

Course description

Lists are the core data structure for persisting all data in SharePoint solutions, therefore it is essential to know to properly create them and how to query them efficiently. We will cover creating both lists and their views and how to use the CAML query language in order to be able to write the most performant queries on those lists as well as using LINQ for SharePoint. After this course you will have the know-how to know when to use the right type of query method for getting data out of SharePoint lists.


This course assumes that students have some Web development background and some experience using Visual Studio 2012.

Prepare for certification

This course will help you prepare for:
70-489 Developing Microsoft SharePoint Server 2013 Advanced Solutions
70-488 Developing Microsoft SharePoint Server 2013 Core Solutions

This course will help you earn:
MCSD: SharePoint Applications

Meet the expert

Tim McCarthy Tim McCarthy is a senior solutions architect with Perficient who designs and builds highly scalable, layered web, desktop, and mobile applications utilizing the latest Microsoft platforms & technologies. His expertise covers a wide range of Microsoft technologies including SharePoint/Office 365, Office Apps, Windows Phone, Windows 8, Azure, .NET Framework (ASP.NET, VSTO, Workflow, WCF, WPF), SQL Server, Active Directory, MS Exchange development, and Service Oriented Architecture (SOA) applications. Tim holds multiple Microsoft certifications and is a former Microsoft MVP in Solutions Architecture. He is the author of several books, has developed presentations for the Microsoft Developer Network (MSDN), and has written articles for SQL Server Magazine and Windows & .NET Magazine. He has been a featured speaker at conferences, user groups and code camps worldwide. Before becoming an application developer, Tim was an officer in the United States Marine Corps.

Course outline

Programming Lists

Programming Lists (44:12)
  • Introduction (00:14)
  • Lists and Libraries (02:36)
  • Retrieve List Instances (01:47)
  • Demo: Retrieving List Instances (03:36)
  • Demo: Counting List Items (04:44)
  • Demo: Using the GUID Indexer (03:52)
  • Demo: Using the GetList method (03:34)
  • Creating Lists with Server Code (02:33)
  • Demo: Lists with Server Code (05:59)
  • Demo: Deleting Lists (02:16)
  • Demo: Binding a Content Type (04:47)
  • Views (01:10)
  • Demo: Views (03:33)
  • Demo: Static Titles (03:12)
  • Summary (00:11)
Retrieving Items (45:22)
  • Introduction (00:16)
  • Retrieving Items with Server Code (01:56)
  • CAML Queries (02:09)
  • SPQuery Class (00:38)
  • SPSiteDataQuery Class (01:12)
  • Query Properties (00:52)
  • ViewFields Property (00:35)
  • Query Property (00:37)
  • Comparison Operators (00:09)
  • SPSiteDataQuery Additions (01:22)
  • Demo: Creating a CAML Query (04:19)
  • Demo: Extracting a Query (04:21)
  • Demo: CreateChildControls (03:24)
  • Joins (01:31)
  • Demo: Joins (05:40)
  • Demo: Clean Up Lookup Fields (01:45)
  • LINQ with SharePoint (02:40)
  • Demo: LINQ Queries (03:36)
  • Demo: Web Part with LINQ (03:11)
  • Demo: Adding a Web Part (03:42)
  • Microsoft.SharePoint.Linq Limits (01:01)
  • Summary (00:14)