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.
Programming classroom training
Our pure programming courses are listed below:
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:
Introduction to C# (2 days)
Advanced C# (3 days)
|DAX||Programming in DAX (2 days)|
Introduction to SQL (2 days)
|VB||Introduction to VB (2 days)|
Excel VBA Introduction (2 days)
Advanced VBA (2 days)
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:
|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:
- Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
- A computer for each delegate (obviously).
- A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
- Full colour courseware of oustanding quality (download a sample Programming courseware chapter to judge this claim for yourself) .
- Interesting exercises to reinforce what you've learnt (you can review some of the Programming exercises we use here).
- Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
- 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.
- A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
- A Sheaffer biro and notepad.
- 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).
Scheduled Programming training dates
Here are the Programming courses we have scheduled for the next 3 months:
|Intermediate C#||Thu/Fri 21-22 June 2018||2||Manchester||£795||Book places|
|Introduction to SQL||Thu/Fri 28-29 June 2018||2||London||£795||Book places|
|Advanced SQL||Thu/Fri 05-06 July 2018||2||Manchester||£750||Book places|
|Advanced VBA||Tue/Wed 17-18 July 2018||2||Manchester||£750||Book places|
|Introduction to Visual C#||Tue/Wed 17-18 July 2018||2||Manchester||£695||Book places|
|Introduction to SQL||Thu/Fri 19-20 July 2018||2||Manchester||£695||Book places|
|Advanced SQL||Tue/Wed 24-25 July 2018||2||London||£895||Book places|
|Excel VBA macros||Thu/Fri 26-27 July 2018||2||Manchester||£695||Book places|
|Introduction to SQL||Thu/Fri 26-27 July 2018||2||London||£795||Book places|
|Excel VBA macros||Thu/Fri 02-03 August 2018||2||London||£850||Book places|
|Intermediate C#||Thu/Fri 02-03 August 2018||2||Manchester||£795||Book places|
|Introduction to SQL||Tue/Wed 14-15 August 2018||2||Manchester||£695||Book places|
|Advanced SQL||Tue/Wed 21-22 August 2018||2||Manchester||£750||Book places|
|Introduction to SQL||Thu/Fri 30-31 August 2018||2||London||£795||Book places|
|Advanced SQL||Tue/Wed 04-05 September 2018||2||London||£895||Book places|
|Excel VBA macros||Thu/Fri 13-14 September 2018||2||London||£850||Book places|
|Introduction to VB.NET||Thu/Fri 13-14 September 2018||2||Manchester||£695||Book places|
|DAX||Tue/Wed 18-19 September 2018||2||Manchester||£795||Book places|
|Advanced VBA||Thu/Fri 20-21 September 2018||2||Manchester||£750||Book places|
|Introduction to Visual C#||Thu/Fri 20-21 September 2018||2||Manchester||£695||Book places|
|Introduction to SQL||28/06||London|
|Introduction to Visual C#||17/07||Manchester|
|Introduction to SQL||19/07||Manchester|
|Excel VBA macros||26/07||Manchester|
|Introduction to SQL||26/07||London|
|Excel VBA macros||02/08||London|
|Introduction to SQL||14/08||Manchester|
|Introduction to SQL||30/08||London|
|Excel VBA macros||13/09||London|
|Introduction to VB.NET||13/09||Manchester|
|Introduction to Visual C#||20/09||Manchester|
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.|
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
Blogs on Programming
Videos on Programming
Programming training venues
Programming books or publications
If you're teaching yourself VBA, we've also published our own book: