Browse 534 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Intermediate VB

Classroom Training

Intermediate VB training course - Classes, LINQ and Entity Frameworks

Available as classroom training course only

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

2 days

This intermediate-level Visual Basic course assumes that you already know how to create variables, test conditions and write simple loops in VB.  However, you don't know how to create classes (or at least, don't reallly understand why you'd need to), and you're still a LINQ virgin!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents

The contents of this course are as follows:

Designing classes

  • What classes are
  • Examples of using classes
  • Property or method?

Creating classes

  • Instantiating objects
  • RO, WO and RW properties
  • Creating methods
  • Overloading methods

Lists

  • The wonderful VB list
  • Adding and removing items
  • Finding items

Basic LINQ syntax

  • Creating queries
  • Executing a query
  • Immediate and deferred execution

Selecting data with LINQ

  • The WHERE clause
  • Selecting fields
  • Using LET for expressions

LINQ data sources

  • The IEnumerable interface
  • Arrays and lists
  • Other valid data sources

Types of EF model

  • Code first - pros and cons
  • Model first disadvantages
  • Database first

Entity frameworks

  • Database first entity models
  • Updating models

LINQ and EF

  • Selecting rows/columns
  • Inserting rows
  • Deleting rows
  • Updating data

Advaned EF LINQ

  • Anonymous types
  • Stored procedures
  • Partial classes

You should not attend this course if you are a beginner at VB programming (if you are, have a look at our two-day introduction to VB course instead).

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"I would like to thank the trainer for the way he ran the course and how he presented it, making plenty of time to ask questions and re-explain things if needed. Very good indeed doing the course online."

Craig Wyatt (FIS Global (WorldPay))

"I really enjoyed my training session, with one of the best trainers I have met. She is very knowledgeable and engaging and goes at just the right pace for all that are on the course. I was very dubious as to how it would work remotely but I thought it was excellent!"

Sue Thomas (STMicroelectronics (R&D) Ltd)

"Everyone seemed to really enjoy the course, many of us have already found what we’ve learned useful for understanding aspects of ongoing projects that were going a little over our heads. Personally I have also been completing the additional exercises provided and have been surprised how much of this has stuck so really appreciate the course material provided. Will certainly keep you guys front of mind for any additional learning we may need to book for these subjects. Thanks again, and thanks especially to the trainer for beautifully dealing with us rowdy bunch for 3 days "

Jenna Sharples (Lex)

"Highly recommend. Really enjoyed, thank you! (SSIS) Very patient with us, not having been on the introduction course.(Adv Power BI) Feedback from colleagues was very positive."

Nichola Kelly (Manchester Metropolitan University)

"(SQL) Great course to get us up and running. Flexible and knowledgeable trainer. (SSRS & Report Builder) Very comprehensive course covering all aspects of SSRS. The trainer also devised some specific examples to show us the art of the possible. Answering everything we threw at him. Brilliant! "

Andy Webster (Countrywide)

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

Related Courses

Introduction to VB.NET

Introduction to VB

2 day course

Other Visual Basic training resources

Visual Basic exercises

Visual Basic exercises

Have a look at some of our VB exercises, to help you understand whether to book training with us in Visual Basic.

View VB.NET exercises

Visual Basic blogs

Visual Basic blogs

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

View Visual Basic blogs

This page has 0 threads Add post