SQL basics
Seven chapters, 4 h 35 min: ask a database your own questions.
What you will be able to do
Write queries that filter, join and total real tables, check that the numbers are right, and answer one business question end to end. Everything runs in your browser.
SQL basics at a glance
Video
4 h 35 min
Chapters
7
Exercises
16, marked by an instructor
Level
Beginner
Fee
Yours to keep (Example prices)
$59
Chapter by chapter
7 chapters, 4 h 35 min of video. Each segment of the bar is one chapter, drawn to its length.
0:00:00
First queries
0:30:00
Filtering and sorting
1:08:00
Joins
2:00:00
Grouping and totals
2:44:00
Subqueries
3:20:00
Cleaning in SQL
3:55:00
A report from scratch
0:00:00
First queries
SELECT, FROM and reading a table you did not design
30 min
2 exercises
0:30:00
Filtering and sorting
WHERE, ORDER BY and the mistakes everyone makes with NULL
38 min
3 exercises
1:08:00
Joins
Putting two tables together and checking the row count
52 min
3 exercises
2:00:00
Grouping and totals
GROUP BY, HAVING and totals that match the finance report
44 min
3 exercises
2:44:00
Subqueries
Questions inside questions, and when to use a CTE instead
36 min
2 exercises
3:20:00
Cleaning in SQL
Text, dates and duplicates
35 min
2 exercises
3:55:00
A report from scratch
One business question answered end to end
40 min
1 exercise
Watch the first lesson of any course, free
Tell us which course and we email a login for its first chapter. No card, no trial that turns into a subscription.