Mastering LINQ with C# Training Course
C# is a multi-paradigm programming language encompassing object-oriented and component-oriented disciplines. LINQ (language integrated query) is a component that adds native data querying capabilities to programming languages.
This instructor-led, live training (online or onsite) is aimed at web developers who wish to query and update big data with LINQ using C#.
By the end of this training, participants will be able to:
- Create and execute LINQ queries.
- Implement advanced libraries for data querying.
- Filter, search, transform, and manipulate local or remote objects.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction
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
LINQ to SQL
- Setting up a database
- Querying a database
- Updating a database
LINQ to XML
- Creating a tree
- Using tree queries
Summary and Conclusion
Requirements
- An understanding of programming
Audience
- Web Developers
Open Training Courses require 5+ participants.
Mastering LINQ with C# Training Course - Booking
Mastering LINQ with C# Training Course - Enquiry
Testimonials (5)
Class was informative and easy to follow.
Najeeda Motala - Multichoice
Course - Advanced C# for Automation Test Engineers
Tailored to our needs
Rafal - Haleon
Course - C#.Net
Everything. Again considering the amount of concepts Fulvio covered, including detailed explanation in three days was really good. I liked that he covered a lot of concepts we as Data Engineers would require.
Florim - Jisc
Course - Programming in C# with Visual Studio
Comprehensive - covered everything we were interested in. Able to work through examples.
Deborah Morrison - AFBI
Course - Introduction to Blazor
I liked how the examples lead to the next. You are able to use what you learnt in the previous segment in the next.
Sacha Mannion - BeyondTrust
Course - C# for Automation Test Engineers
Upcoming Courses
Related Courses
Introducing C# 6.0 with Visual Studio 2015/2017
28 HoursThis instructor-led, live training in (online or onsite) equips participants with the essential skills needed to leverage the capabilities of C# 6.0 within the Visual Studio 2015/2017 environment.
By the end of this training, participants will be able to:
- Navigate and utilize the Integrated Development Environment (IDE) in Visual Studio 2015/2017.
- Implement basic C# functionalities such as Console.WriteLine, Console.ReadLine, and Hello C# World!.
- Understand the process of compiling and debugging C# code.
- Apply comments in C# for code documentation and readability.
- Explore the fundamentals of .NET 6.0, including CLR, GC, DLL, EXE, and technologies within .NET.
- Review the history of C# from version 1.0 to 6.0 and grasp C# fundamentals such as keywords, literals, operators, and statements.
- Work with numeric and boolean types, classes, objects, fields, properties, indexers, operators, methods, and more in C# 6.0.
- Explore .NET Class Library features, including collections, file handling, data streams, communication between systems, dates, serialization, and parallel programming.
- Access and manipulate data using ADO.NET, LINQ, ORM (Entity Framework), and data in Service-Oriented Architecture (SOA).
- Review applications that can be developed in C# and .NET Framework 6, such as Windows Presentation Foundation, ASP.NET MVC 2, and Silverlight.
C#.Net
35 HoursObjectives
This C# course will enable delegates to develop applications in the C# programming language. Delegates will be able to program using the principles of object orientation. The course will also cover how to use the Visual Studio development environment to produce robust and maintainable applications.
Audience
This course is intended for the following types of software developers:
- New developers
- Developers who understand computer programming but may have learned programming by using a non-graphical language in a university
These developers want to build solutions by using C#; within the Microsoft .NET Framework. They also want to employ Object Orientated techniques to enhance their development skills.
Advanced Programming in C#
35 HoursThis instructor-led, live trainingin in Guatemala introduces advanced features of C#, examines its usage as both a desktop application programming language and a web programming language for solving real-world problems.
Programming techniques and principals are demonstrated and practiced through in-class, hands-on exercises and walk-throughs.
Advanced C# for Automation Test Engineers
21 HoursThis instructor-led, live training in Guatemala (online or onsite) is aimed at experienced automation test engineers who want to learn advanced C# programming concepts for automation testing.
By the end of this training, participants will be able to:
- Understand advanced C# programming concepts and best practices.
- Apply advanced object-oriented programming principles to create efficient and flexible automation solutions.
- Design and develop modular and reusable automation frameworks using industry best practices.
ASP.Net 4.0
35 HoursDelegates will be introduced to the .Net framework and will learn to develop web applications using C# 4.0. At course completion delegates should be familiar with the framework, experienced in developing basic web application and conversant with database access using LINQ. Applications will be created using Object Orientated programming.
After completing this course, delegates will be able to:
- Use Visual Studio 2010 effectively
- Learn C# 4.0
- Create commercial ASP.NET Web Applications
- Understand OO Programming, Classes, and Objects
- Debug Applications
- Develop user interfaces using Master Pages, Site Navigation and Themes
- Use ADO.Net and LINQ to read from and write to databases
- Develop rich internet applications using ASP.NET AJAX
- Create and call WCF services
C# for Automation Test Engineers
21 HoursThis instructor-led, live training in Guatemala is designed for anyone interested in learning C# for the purpose of automation testing. It is a streamlined, intensive course with plenty of hands-on exercises to get participants ramped up quickly with the essential programming skills needed to apply in software automation testing. The focus is on the C# fundamentals which can be directly and immediately applied to test automation.
This course does not cover in depth test automation frameworks such as Selenium. If you are already versed in C# and wish to get straight into testing with Selenium, please check out: Selenium WebDriver in C#: Introduction to web testing automation in C#.
Design Patterns in C#
14 HoursTarget group:
Technical Team Leader, Software Developer
Learning objective:
The purpose of training is to acquire the ability to design advanced development / project structures in C #.
During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio, ReSharper.
Introduction to Blazor
14 HoursThis instructor-led, live training in Guatemala (online or onsite) is aimed at web developers who wish to use Blazor to create full stack C# web applications.
By the end of this training, participants will be able to:
- Develop web applications with C# and Blazor.
- Use C# code to call JavaScript APIs and libraries.
- Run client-side C# code and client logic directly in a browser or server.
- Deploy Blazor web applications with Azure.
Programming in ASP.NET MVC 5
21 HoursTarget group:
Technical Team Leader, Software Developer
Learning objective:
The purpose of training is to acquire the ability to develop business internet applications in ASP.NET MVC 4 technology and in C # language.
During the course, students become familiar with the MSDN resources and tools to support the development process, such as Microsoft Visual Studio.
Programming in C# with Visual Studio 2022
28 HoursThis instructor-led, live training Guatemala (online or onsite) is aimed at intermediate to advanced-level developers who wish to understand the syntax of C# and topics related to object-oriented programming in C#. By the end of this training, participants will be able to: Be familiar with the MSDN resources and tools. Support the development process such as Microsoft Visual Studio.