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
Need help picking the right course?
Mastering LINQ with C# Training Course - Enquiry
Testimonials (5)
Good rapport, Łukasz had time for everyone's questions and was able to help anyone who had any issue
Kelly Morris - Titian Software Poland Sp. z o.o.
Course - Selenium WebDriver in C#
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
I liked that I had the chance to exercise.
carmen mocanu - Nanotec Electronic Bulgaria EOOD
Course - Unit Testing with C#
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 the UAE 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 the UAE (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 the UAE 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 the UAE (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 the UAE (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.
Programming in C#
14 HoursThe course is designed for people who want to learn programming language based on C# and learn basic capabilities of the .NET platform. During the training participants will learn how it is built into C#, how to set up an environment to write basic programs, use the standard libraries.
Programming in WPF
21 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at software developers who wish to develop desktop client applications using WPF and C#. By the end of this training, participants will be able to: Learn and understand how to use the MSDN resources and tools. Support the development process in Microsoft Visual Studio. Develop business desktop applications using WPF technology and C# language.
Selenium C# Test Automation
14 HoursThis instructor-led, live training in the UAE (online or onsite) is aimed at developers and testers who wish to perform test automation using C# and Selenium.
By the end of this training, participants will be able to:
- Install and configure Selenium WebDriver.
- Write tests using Selenium, C#, and Nunit with Visual Studio IDE.
- Run C# Selenium test automation.
Selenium WebDriver in C#
14 HoursThis instructor-led, live training in the UAE (online or onsite) introduces participants to automated testing with Selenium WebDriver and C# in Visual Studio. If you do not have C# programming experience or wish to brush up on C#, please check out the course: C# for Automation Test Engineers.
Unit Testing with C#
14 HoursUnit testing is a testing approach that tests individual units of source code by modifying its properties or triggering an event to confirm whether the outcome is as expected.
In this instructor-led, live training, participants will learn how to write and execute unit tests against a sample .Net application using C# and Visual Studio.
By the end of this training, participants will be able to:
- Use testing frameworks such as NUnit and xUnit.net to create and manage unit test code
- Define and implement a broader test driven development approach to testing
- Adapt the testing framework to extend the test coverage for an application
Audience
- Software test engineers
- Developers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice