Programming Training Courses

If you're trying to learn to program, this page is for you! It lists all of our training courses in VB, C#, SQL, VBA and DAX, as well as giving links to many other training resources.

Macros and Programming classroom training

Programming classroom training

Our pure programming courses are listed below:

Can't see the course you want? Have a look at our onsite Macros and Programming training page, or see our other Programming training resources.

Not sure which course you want? See what you can learn on one of our Programming courses.

Which is the right Programming course for you?

We like programming!  To help you choose which language to learn, we've included a quick guide below.  To avoid any bias, the languages are listed in alphabetical order.

Language When and why you would use it
C# Visual C# allows you to build websites and forms-based systems in .NET.
DAX DAX allows you to create measures in Power BI Desktop, PowerPivot and SSAS Tabular.
SQL SQL allows you to extract information from SQL Server databases, and then manipulate it.
VB Like C#, Visual Basic allows you to build ASP.NET websites and Windows Forms systems, among other uses.
VBA Visual Basic for Applications is the language included in Microsoft Office, and allows you to automate Excel, Access and other programs.

Here are the main courses that we teach in each language:

If you're not a specialist programmer, you'll probably want to avoid learning VB or C#, but becoming proficient in SQL or VBA may well make you able to do day-to-day tasks more quickly, without needing to resort to getting help from your (busy) IT department all the time.

Whichever language you choose, you'll have to master the same core concepts:

Concept Explanation
Variables Variables are places in which you can store single items of data, such as integers, dates and bits of text.
Conditions At the heart of programming is the ability to test a condition, to see which execution path to follow.
Loops Also at the heart of programming is the ability to repeat a series of steps a number of times, perhaps while a particular condition is true.

The exception to the above is DAX, which is primarily a language used for calculation formulae.  You also won't encounter the above if you stick to learning the basics of SQL only.

10 things our Programming courses include

Each of our scheduled courses includes:

  1. Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer delegates.
  2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls (our average feedback scores are in the range 9.2 to 9.8 out of 10).
  3. Full colour courseware and exercises of oustanding quality (download a sample Programming courseware chapter to judge this claim for yourself) .
  4. A no cancellation guarantee (once you've booked/confirmed training, it will run).
  5. A computer for each delegate (obviously).
  6. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  7. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
  8. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a Sheaffer biro.
  9. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
  10. A certificate sent out digitally or in paper form (your choice) after each course, together with (for online courses) the trainer's thoughts on how the course went.

Have a look at our full list of benefits, or read hundreds of testimonials to the quality of our training.

Scheduled Programming training dates

Here are the Programming courses we have scheduled for the next 3 months:

Course Dates Days Venue Price Booking
Tue/Wed 11-12 December 2018 2 £850 Book places
Thu/Fri 13-14 December 2018 2 £895 Book places
Thu/Fri 13-14 December 2018 2 £695 Book places
Tue/Wed 08-09 January 2019 2 £795 Book places
Thu/Fri 10-11 January 2019 2 £695 Book places
Tue/Wed 15-16 January 2019 2 £750 Book places
Mon/Tue 21-22 January 2019 2 £795 Book places
Thu/Fri 24-25 January 2019 2 £695 Book places
Tue/Wed 29-30 January 2019 2 £895 Book places
Thu/Fri 31st Jan/1st February 2019 2 £850 Book places
Thu/Fri 31st Jan/1st February 2019 2 £695 Book places
Thu/Fri 31st Jan/1st February 2019 2 £795 Book places
Thu/Fri 14-15 February 2019 2 £950 Book places
Thu/Fri 14-15 February 2019 2 £750 Book places
Thu/Fri 14-15 February 2019 2 £795 Book places
Tue/Wed 19-20 February 2019 2 £695 Book places
Tue/Wed 19-20 February 2019 2 £795 Book places
Tue/Wed 26-27 February 2019 2 £895 Book places
Thu/Fri 28th Feb/1st March 2019 2 £695 Book places
Thu/Fri 28th Feb/1st March 2019 2 £795 Book places
Tue/Wed 05-06 March 2019 2 £750 Book places
Thu/Fri 07-08 March 2019 2 £695 Book places
Course Date(s) Venue
11/12
13/12
13/12
08/01
10/01
15/01
21/01
24/01
29/01
31/01
31/01
31/01
14/02
14/02
14/02
19/02
19/02
26/02
28/02
28/02
05/03
07/03

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite Programming training at your offices (we'll even provide the computers and projector).

About our Programming training

Programming has come on over the years, but the essential principles remain the same (in virtually every language you create variables, test conditions and iterate over loops).  To show the evolution of programming over the decades, here are the languages learnt by the oldest of the Wise Owls:

Decade Main language learnt Notes
1980s Fortran In early Fortran you had to colour in shapes on punch cards with a 2B pencil!  How times have changed ...
1990s VBA The 1990s saw Microsoft roll out Visual Basic for Applications across all of the MIcrosoft Office product range; it's still going strong today.
2000s SQL T-SQL is the dialect of SQL used for extracting data from SQL Server.
2010s C# C, C++, Java and JavaScript are all variants of C#.

We don't train in Fortran (thank goodness), but we do still train in the languages from the other 3 decades.

Other Macros and Programming training resources

Macros and Programming blogs

Blogs on Programming

Whether you're learning to program in SQL, VB, VBA or C#, we'll have written a blog to help you:

Macros and Programming courseware

Programming courseware manuals

To show what our training is like, you can download sample chapters from our courseware:

Macros and Programming videos

Videos on Programming

Our videos can help you to learn to program in SQL, VBA, C# or DAX:

Macros and Programming skills assessment

Test your Programming skills

Test your SQL or VBA programming skills using one of these categories:

Macros and Programming training venues

Programming training venues

Our scheduled programming courses run in the following venues:

Macros and Programming book

Programming books or publications

If you're teaching yourself VBA, we've also published our own book:

This page has 0 threads Add post