SQL lessons

SQL lessons

A progressive learning path using simplified finance and business data: queries, joins, grouping, aggregations and overdue balance analysis.

Recommended learning path
QuerySELECT ยท WHERE
JoinJOIN ยท LEFT JOIN
AnalyzeGROUP BY ยท HAVING
01
Beginner 3 related exercises

SELECT, FROM and WHERE

Query a table and filter the relevant rows.

Open lesson
02
Beginner 1 related exercises

ORDER BY and LIMIT

Sort results to produce a useful output.

Open lesson
03
Intermediate 4 related exercises

JOIN: connect multiple tables

Connect tables through primary and foreign keys.

Open lesson
04
Intermediate 6 related exercises

GROUP BY and aggregate functions

Calculate metrics from multiple rows.

Open lesson
05
Advanced 3 related exercises

LEFT JOIN, NULL and COALESCE

Identify missing or incomplete data.

Open lesson
06
Advanced 5 related exercises

HAVING, subqueries and finance calculations

Filter calculated metrics and build analytical queries.

Open lesson