.NET training -  Intermediate C#

C# Training

Intermediate C# training course - Classes, LINQ and Entity Frameworks

£795 + VAT for most venues (£895 + VAT for London)

2 days

This intermediate-level C# course assumes that you're already familiar with the basics of C# programming (so you know how to use variables, write conditions and create loops).  You suspect (correctly) that the key to understanding C# is knowing how to create and use classes, and you'd also like to learn a quick and easy way to access data so that you can use it in your application.

Course details

  • Locations for Intermediate C# coursesLocations:Manchester
  • Next Intermediate C# course locationNext course:Tue 12 May 2020
  • Intermediate C# course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Designing classes

  • Training topicThe domestic cat object
  • Training topicProperties and methods
  • Training topicEncapsulation and exposure

Creating classes

  • Training topicUsing namespaces
  • Training topicCreating constructors
  • Training topicFields, properties and methods
  • Training topicStatic members

The form as a class

  • Training topicPartial classes
  • Training topicInitalizeComponent method
  • Training topicInstantiating forms

Data structures

  • Training topicGenerics
  • Training topicArrays
  • Training topicLists, stacks and queues
  • Training topicDictionaries

Overloading

  • Training topicOverloaded methods
  • Training topicOverloading constructors

LINQ theory

  • Training topicExtension methods
  • Training topicIenumerability
  • Training topicQuery vs. method syntax

Writing LINQ

  • Training topicArrays, lists and data tables
  • Training topicCriteria and ordering
  • Training topicUsing LET expressions

Advanced LINQ

  • Training topicProjecting data
  • Training topicAnonymous types
  • Training topicForcing query execution
  • Training topicTaking and skipping

Types of model

  • Training topicCode first
  • Training topicModel first
  • Training topicDatabase first

Entity Frameworks

  • Training topicCreating entity data models
  • Training topicData contexts
  • Training topicUpdating models

LINQ with Entity Frameworks

  • Training topicCreating a data context
  • Training topicSelecting data using LINQ
  • Training topicUsing relationships (associations)
  • Training topicAdding, editing and deleting

Advanced LINQ with EF

  • Training topicReturning anonymous types
  • Training topicUsing stored procedures
  • Training topicExtending (partial classes)

Covered if time allows If time

Grouping using LINQ

  • Training topicIGrouping and IEnumerable
  • Training topicGrouping keys
  • Training topicGroup into and ordering
  • Training topicUsing multiple keys

You should not attend this course if you are a beginner at C programming (in which case choose our two-day introduction to C# course instead).

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"My trainer was fun and engaging. He listened and answered any questions without judgement, while being friendly and relaxed. I had a lovely time and was even able to ask extra questions which was very useful."

Corin Lee (Macquarie Energy Leasing)

"Great course, well delivered, spot on, gave me the skills required to progress, Great trainer. The course handbook is a great tool to refer to when using SQL daily. Many thanks"

Andrew Riley (Cross Keys Homes)

"Very good - covers a lot of areas in detail but also efficiently."

Flora Mclean (Refuge)

"Course delivered effectively. Friendly and interactive trainer who knows his stuff. Not one moment of boredom or tension from classroom; relaxing environment. I am a newbie to SSRS and refreshingly Wise Owl does actually deliver what they promise"

Hian Soh (Bechtel Limited)

"We had a great trainer, very patient and excellent at explaining the content of the course. The course venue and equipment provided was of a very high standard, especially the in-depth instruction manual and memory stick (meaning we could take the code we’d wrote home with us). We were also taken out for lunch each day which was a really nice touch. Would highly recommend. "

Claire Leonard (Barbican Insurance Group)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Intermediate C# training dates

Here are the Intermediate C# courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 12-13 May 2020 2 £795 Book places
Tue/Wed 02-03 June 2020 2 £795 Book places
Tue/Wed 25-26 August 2020 2 £795 Book places
Thu/Fri 19-20 November 2020 2 £795 Book places
Date(s) Venue
12/05
02/06
25/08
19/11

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite C# training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Visual C#

Introduction

2 day course

Other Visual C# training resources

C# exercises

C# exercises

We publish all of our exercises online, so have a look at our C# exercises (particularly the advanced ones) to see if you like our approach before booking any training.

View C Sharp exercises

C# videos

C# videos

There are a range of video tutorials to help you learn C# (although there's no substitute for learning from a human being - or Wise Owl, at any rate).

View C# Programming videos

C# blogs

C# blogs

As well as other C# training resources, you may find some of our blogs on the language useful - or at least interesting!

View Visual C# blogs

This page has 0 threads Add post