Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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:
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).
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!
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
)
AS
-- 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.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the next SQL courses we have scheduled:
Course | Dates | Venue |
---|---|---|
Advanced SQL | 24-25 Oct | Online |
Introduction to SQL | 04-05 Nov | Online |
Introduction to SQL | 12-13 Nov | Online |
Advanced SQL | 19-20 Nov | London |
Advanced SQL | 21-22 Nov | Online |
Fast track SQL | 25-27 Nov | Online |
Introduction to SQL | 05-06 Dec | Online |
Advanced SQL | 09-10 Jan | Online |
Fast track SQL | 14-16 Jan | 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 training at your offices (we'll even provide the computers and projector).
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.
There are many ways in which we can help you learn SQL!
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.
For insights and education on writing SQL, have a browse through some of these blogs.
We've got over 30 videos to help you learn how to write SQL.
We've published the following short videos on learning and using SQL.
Our SQL free online tutorials can help you to learn SQL.
We run our SQL training classes in the following venues.
You can sample or license the following courseware manuals.
Not sure what your SQL skills are like? Try doing our online test.
If you can't invest the time to learn to write SQL, why not let our SQL gurus do it for you?
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.