This page has 0 threads | Add post

Group classroom and online training courses

SQL Training Courses

Our live online or classroom SQL training courses have no more than 6 people per course. Have a look at our introductory and advanced SQL courses, and our other SQL training resources.

We currently run the following scheduled SQL courses:

Introduction to SQL Advanced SQL (stored procedures) Azure Data Studio (*) Three-day fast-track SQL

(*) This course is a new course; for all other courses our no cancel guarantee applies.

Not exactly the course contents you want? Why not consider organising your own tailored SQL course)?

More about our SQL training

Sick of having to contact your IT people or third party supplier to get at your own data? Learn to write queries to get at it yourself, using either SQL Server Management Studio or (by request) Azure Data Studio. We run two scheduled courses: a two-day introduction to SQL course, and a two-day advanced SQL course.

If you're a quick learner you could consider combining these two courses together and attending our single three-day fast-track course (but only if you're a quick learner).

Two-day introductory course - selecting data using SQL

This course will show you how to write queries like the one below using T-SQL, the dialect of SQL used within Microsoft's SQL Server:

-- show how many films there are for each certificate

SELECT

c.Certificate,

COUNT(*) as 'Number of films'

FROM

Film as f

INNER JOIN Certificate AS c

ON f.CertificateID = c.CertificateID

GROUP BY

c.Certificate

ORDER BY

-- show most popular certificate first

'Number of films' DESC

This won't necessarily make much sense to you now, but it will do after the course!

Two-day advanced SQL course - programming stored procedures

This course assumes that you know how to write queries, and shows you how to program in SQL, including using variables, writing stored procedures and functions and using table variables and temporary tables. Here's a sample of what you'll learn to do:

CREATE PROC spListFilms(

@minOscars int,

@maxOscars int

)

-- list films winning this many Oscars

SELECT

f.Title,

f.OscarWins

FROM

Film AS f

WHERE

f.OscarWins between @minOscars and @maxOscars

Still not sure which is the right course for you? There's more help available here.

10 things our courses include

Each of our scheduled courses (whether classroom or online) includes:

Small course sizes - we have a maximum of 6 people on each classroom or online course.
A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
Full colour courseware and exercises of oustanding quality.
A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
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).
A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

A computer for each delegate (obviously).
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.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

Scheduled SQL training dates

Here are the next SQL courses we have scheduled:

Course	Dates	Days	Venue	Price	Booking
Fast track SQL	Wed/Fri 27-29 November 2024	27-29 Nov	3	Online	£1,295	Book places
Introduction to SQL	Thu/Fri 05-06 December 2024	05-06 Dec	2	Online	£825	Book places
Advanced SQL	Thu/Fri 09-10 January 2025	09-10 Jan	2	Online	£950	Book places
Fast track SQL	Tue/Thu 14-16 January 2025	14-16 Jan	3	Manchester	£1,595	Book places
Introduction to SQL	Mon/Tue 20-21 January 2025	20-21 Jan	2	Online	£825	Book places
Fast track SQL	Wed/Fri 29-31 January 2025	29-31 Jan	3	Online	£1,295	Book places
Introduction to SQL	Mon/Tue 03-04 February 2025	03-04 Feb	2	Manchester	£995	Book places
Advanced SQL	Mon/Tue 03-04 February 2025	03-04 Feb	2	Manchester	£1,095	Book places
Advanced SQL	Mon/Tue 10-11 February 2025	10-11 Feb	2	Online	£950	Book places
Introduction to SQL	Mon/Tue 17-18 February 2025	17-18 Feb	2	Online	£825	Book places

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 training at your offices (we'll even provide the computers and projector).

About our SQL training

Not only do we train on SQL, but we use it too! Our systems are powered by SQL Server. At the time of writing, these use the following objects, for example:

What	Tables	Stored procedures
External website	120	122
Internal site (intranet)	128	163

So we definitely practise what we preach! We're also big believers in teaching you not just how to write queries, but how to write them well, following our own internal SQL coding standards.

Other SQL training resources

There are many ways in which we can help you learn SQL!

Exercises

You can get a good flavour of what a Wise Owl SQL course would be like by having a look at one or two of the following exercises.

Exercises

Blogs

For insights and education on writing SQL, have a browse through some of these blogs.

Standard queries

Programming

Videos

We've got over 30 videos to help you learn how to write SQL.

Selecting data

Advanced programming

SQL Server 2016

SQL Server 2017

Shorts

We've published the following short videos on learning and using SQL.

Selecting data

Tutorials

Our SQL free online tutorials can help you to learn SQL.

SQL tutorials

Training venues

We run our SQL training classes in the following venues.

SQL training in Manchester

SQL training in London

Onsite SQL training (UK)

Courseware manuals

You can sample or license the following courseware manuals.

Introduction

Advanced

Fast-track

Test your skills

Not sure what your SQL skills are like? Try doing our online test.

Test your SQL skills

Consultancy

If you can't invest the time to learn to write SQL, why not let our SQL gurus do it for you?

SQL consultancy

This page has 0 threads

Add a new post

SQL Training Courses

More about our SQL training

Two-day introductory course - selecting data using SQL

Two-day advanced SQL course - programming stored procedures

10 things our courses include

Scheduled SQL training dates

About our SQL training

Other SQL training resources

Exercises

Blogs

Videos

Shorts

Tutorials

Training venues

Courseware manuals

Test your skills

Consultancy

Head office

London

Manchester