SQL Easy
free forever Start learning →
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.

Overall progress 0 / 31 exercises · 0%
0day streak 0XP
track_01

Foundations

SELECT, WHERE, ORDER BY: the bones of every query.
01
SELECT *
Not started
→ 02
SELECT specific columns
Not started
→ 03
WHERE ... Equals
Not started
→ 04
WHERE ... Greater than
Not started
→ 05
WHERE ... Greater than or equal
Not started
→ 06
AND
Not started
→ 07
OR
Not started
→ 08
IN
Not started
→ 09
DISTINCT
Not started
→ 10
ORDER BY
Not started
→ 11
LIMIT # of returned rows
Not started
→
track_02

Aggregations

COUNT, SUM, AVG, MAX/MIN, GROUP BY, subqueries, NULLs, dates.
12
COUNT(*)
Not started
→ 13
COUNT(*) ... WHERE
Not started
→ 14
SUM
Not started
→ 15
AVG
Not started
→ 16
MAX and MIN
Not started
→ 17
GROUP BY
Not started
→ 18
Nested queries
Not started
→ 19
NULL
Not started
→ 20
Date
Not started
→
track_03

Joins

Pull rows together from multiple tables: the SQL skill.
21
Inner joins
Not started
→ 22
Multiple joins
Not started
→ 23
Joins with WHERE
Not started
→ 24
Left joins
Not started
→ 25
Table alias
Not started
→ 26
Column alias
Not started
→ 27
Self joins
Not started
→
track_04

String & logic functions

LIKE, CASE, SUBSTR, COALESCE: the everyday tools.
28
LIKE
Not started
→ 29
CASE
Not started
→ 30
SUBSTR
Not started
→ 31
COALESCE
Not started
→