Classroom Training
Classroom training course - online version also available
£695 + VAT for most venues (£795 + VAT for London)
2 days
You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them. You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!
The contents of this course are as follows:
If time
If time
There aren't any pre-requisites for this course, although you'll find it easier if you've already seen a relational database (one with lots of tables joined together). The course uses SQL Server Management Studio, although if you're booking an onsite SQL course we will on request use Azure Data Studio instead.
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Matt Jenkins (Wiggin LLP)
Lisa De Prudhoe (DataQ Ltd)
Pete Mills (LICC (The London Institute for Contemporary Christianity))
Philip Wood (Macquarie Energy Leasing)
Anne McMillan (DHL Supply Chain)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Here are the classroom Introduction to SQL courses we have scheduled for the next 3 months:
Dates | Days | Venue | Price | Booking |
---|---|---|---|---|
Wed/Thu 03-04 March 2021 | 2 | Manchester | £695 | Book places |
Tue/Wed 13-14 April 2021 | 2 | London | £795 | Book places |
Tue/Wed 11-12 May 2021 | 2 | Manchester | £695 | Book places |
Tue/Wed 22-23 June 2021 | 2 | London | £795 | Book places |
Tue/Wed 22-23 June 2021 | 2 | Manchester | £695 | Book places |
Thu/Fri 29-30 July 2021 | 2 | Manchester | £695 | Book places |
Thu/Fri 19-20 August 2021 | 2 | London | £795 | Book places |
Date(s) | Venue |
---|---|
03/03 | Manchester |
13/04 | London |
11/05 | Manchester |
22/06 | London |
22/06 | Manchester |
29/07 | Manchester |
19/08 | London |
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SQL training at your offices (we'll even provide and set up the computers).
View SQL exercises
View Selecting data in SQL, SQL Server 2016, Advanced SQL (programming) or SQL Server 2017 videos
View Test your SQL skills skills assessment tests
View SQL blogs