curriculum
All lessons
31 hand-crafted exercises. Every one runs against a real SQLite database in your browser. Work through them in order, or jump straight to whatever you need.
0day streak
0XP
track_01
Foundations
SELECT, WHERE, ORDER BY: the bones of every query.
01
→
02
→
03
→
04
→
05
→
06
→
07
→
08
→
09
→
10
→
11
→
SELECT *
Not started
SELECT specific columns
Not started
WHERE ... Equals
Not started
WHERE ... Greater than
Not started
WHERE ... Greater than or equal
Not started
AND
Not started
OR
Not started
IN
Not started
DISTINCT
Not started
ORDER BY
Not started
LIMIT # of returned rows
Not started
track_02
Aggregations
COUNT, SUM, AVG, MAX/MIN, GROUP BY, subqueries, NULLs, dates.
track_03
Joins
Pull rows together from multiple tables: the SQL skill.
track_04