This page has 0 threads | Add post

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

Two days (09:30 to 16:30 UK time each day)

This course is available in the following formats (all prices exclude VAT):

Classroom (London)
£1,525

Classroom (Manchester)
£1,150

Onsite (your office)
Please ask

Online (your home)
£995

You can book a place on this course either online through this website, by phone, by email or by filling in our enquiry form.

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).

Course schedule

Here are our next few Intermediate C# course dates:

Dates	Times	Venue	Price (excl. VAT)
30-31 Jan	09:30-16:30	Online	£995	Book
27-28 Feb	09:30-16:30	Online	£995	Book
27-28 Mar	09:30-16:30	Online	£995	Book
28-29 Apr	09:30-16:30	Online	£995	Book
29-30 May	09:30-16:30	Online	£995	Book
Show full list of dates

Got a handful of like-minded people in your organisation? You could consider booking your own customised onsite course, whereby you get to pick the dates and venue!

Course Contents - PDF

Intermediate C# training course contents

To learn to program in C#, you first need to learn the basics. This course assumes that you've already done this (perhaps on our two-day Introduction to C# course), and that you're now ready for the second part of learning to program in C#: understanding classes.

Everyone takes a while to get used to creating and using classes, but in this course we try as hard as we possibly can to shorten the learning curve. You'll learn how to:

Understand objects, properties and methods
Design classes
Create classes (including constructors and fields)
Use entity frameworks (EF) to connect to databases
Create queries using LINQ to connect with your databases

The course will use a database-first approach, use SQL Server as the underlying database and use Visual Studio as the development environment, but the same principles apply whichever EF approach, database and development environment you choose to use.

The contents of this course are as follows:

Designing classes

The domestic cat object
Properties and methods
Encapsulation and exposure

Creating classes

Using namespaces
Creating constructors
Fields, properties and methods
Static members

The form as a class

Partial classes
InitalizeComponent method
Instantiating forms

Data structures

Generics
Arrays
Lists, stacks and queues
Dictionaries

Overloading

Overloaded methods
Overloading constructors

LINQ theory

Extension methods
Ienumerability
Query vs. method syntax

Writing LINQ

Arrays, lists and data tables
Criteria and ordering
Using LET expressions

Advanced LINQ

Projecting data
Anonymous types
Forcing query execution
Taking and skipping

Types of model

Code first
Model first
Database first

Entity Frameworks

Creating entity data models
Data contexts
Updating models

LINQ with Entity Frameworks

Creating a data context
Selecting data using LINQ
Using relationships (associations)
Adding, editing and deleting

Advanced LINQ with EF

Returning anonymous types
Using stored procedures
Extending (partial classes)

Grouping using LINQ if time

IGrouping and IEnumerable
Grouping keys
Group into and ordering
Using multiple keys

Please see further up this page for what you should know beforehand (if anything) in order to attend this course.

Why Choose Us?

Here are some reasons to choose Wise Owl courses:

No more than 6 people per class
551 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

In addition, here are some benefits unique to classroom training:

Proper restaurant lunch included

And some benefits specific to online training:

Courseware manual posted to you in advance
Free half-hour pre-course check-up included
Our clever system means you can use our laptops (and we can see them)

What other people have said

Our thanks to everyone who agreed to share their thoughts. All of the following reviews are from the last 3 calendar years:

"I absolutely loved the course and attending it has given me a lot of food for thought in how I can implement the use within my team. The trainer was superb and communicated clearly the 'how' and 'why' you'd do things in a certain way, looking out for common errors along the way. I needed to know about how to import data into SQL, which wasn't part of the course content, but the trainer was very accommodating by staying behind with me for 10 minutes to show me how I'd do this, which was very much appreciated. I am inexperienced when it comes to using databases and writing script/code, however I had heard about the benefits of using SQL as a tool and wanted to upskill. Thank you for the course - I hope to come on another sometime soon!"

Katherine Wellock (Ministry of Housing, Communities & Local Government (MHCLG))

"An amazing teacher! I was particularly impressed with the pacing off the classes, they never felt too fast or slow. It was a matter of layering simple concepts on top of each other until we could understand something quite complicate, which really worked for me. I've been singing Wise Owl's praises ever since!"

Conor Anderson (PEI Group)

"It was great that the manual was available straightaway when we were in the classroom and as an introductory course, I believe the fundamentals of Power BI were covered. The trainer was patient and ensured all delegates were working on the modules at the same pace. Classroom and refreshments provided were perfect. Lovely touch taking delegates out of the classroom for lunch."

Jill Renwick (Improveasy Ltd)

"Really enjoyed the course, it had so so many examples that are going to be really easy to refer back to. I enjoyed breaking things down to the understanding of why something works, thanks!"

Holly Fry (The Phoenix Group)

"An amazing trainer, made the session really engaging and personalised the course to my needs. Even though there was only me on the course, I was able to pay attention and really enjoyed the session."

Amy Adams (Leeds Community Healthcare NHS Trust)

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

How our training courses work

Below are some notes on how Wise Owl courses work, to help you decide whether they're for you or not.

What you'll need

If you book on a classroom course, the only thing you need to bring to the course is ... yourself! We even provide a notepad and a suprisingly nice pen for you to take notes with.

For online training you'll need two things:

A good internet connection (otherwise you'll have a frustrating time); and
A second screen (a requirement, not a nice-to-have!)

You can see full details of our online course requirements here.

When you book a place

If you book a place on one of our courses:

For classroom courses we will send out a joining email. That's it!
For online courses we will get in touch to organise a half-hour pre-course check to iron out any connection problems before the course (rather than during it).

Whatever type of course you book, we will also send you out a reminder a few days before the course is due to take place - not that (we hope) you'll have forgotten!

What you won't need

For classroom training, you won't need a computer - we (obviously) will provide that. However, you're welcome to use your own laptop if you prefer, providing that you have the correct software installed.

For online training you will need a computer, but you won't need to have any software installed. This is because you'll use Windows Remote Desktop to connect to our computers, and these will have all of the necessary files and software installed.

The start of the course

For online courses you will be able to join up to half an hour before the course begins. This will give you time to:

familiarise yourself with the set-up;
meet your trainer; and
get to know the other delegates!

For classroom training it's always nice if people arrive a bit early too, to give people time to meet each other (and drink coffee).

You'll be given a full colour courseware manual, an exercise booklet to go with the course and a USB stick for taking course files away (we'll post all this to you for online courses).

After the course

After the course finishes you'll receive a digital certificate proving your attendance (we will gladly send a paper copy on request also).

We don't have any formal arrangement for answering questions after the course, but if you get stuck on something and email your trainer they should (and nearly always do!) respond as quickly as their training schedule allows.

Related Courses

You might like to consider these related courses:

Introduction to Visual C#

Introduction

2 day course

This page has 0 threads

Add a new post