Course Outline


LINQ Basics

  • IEnumerable<T>
  • IEnumerator<T>
  • Projection, filtering, quantifiers, partitions, operations, etc.

Overview of LINQ Operators

  • Immediate vs deferred executions
  • Streaming vs non-streaming operators

Preparing the Development Environment

  • Installing and configuring .NET
  • Installing and configuring LINQPad

Simple LINQ Queries

  • Selecting a data source
  • Creating a query
  • Executing a query

Data Transformation and Type Relationships

  • Returning results as a type
  • Performing operations on source elements
  • Allowing the compiler to select types

Grouping and Joining LINQ Queries

  • Grouping by multiple keys
  • Extending a group query
  • Grouping with custom keys
  • Using inner join with composite key
  • Using group join and inner group join

LINQ with Lambda Operators

  • Understanding method syntax with Lambda operators
  • Grouping by multi-keys
  • Grouping by custom keys and custom objects
  • Using inner join and composite join
  • Using group join and group inner join

Standard and Complex Queries

  • Filtering subsets
  • Rearranging data with an operator
  • Parsing basic groups
  • Creating a hierarchy in a data set
  • Chaining data
  • Using into and let keywords


  • Setting up a database
  • Querying a database
  • Updating a database


  • Creating a tree
  • Using tree queries

Summary and Conclusion


  • An understanding of programming


  • Web Developers
  14 Hours


Related Courses

Design Patterns in C#

  14 hours

ASP.Net 4.0

  35 hours


  35 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours

Programming in C#

  14 hours

C# for Automation Test Engineers

  21 hours

Selenium WebDriver in C#

  14 hours

Visual Studio with VB.Net

  21 hours

Advanced Programming in C#

  35 hours

Programming in C# with Visual Studio

  28 hours

Programming in ASP.NET MVC 5

  21 hours

Programming in WPF

  21 hours

Unity: Developing 3D Games with C# and Javascript

  28 hours

Unit Testing with C#

  14 hours