SQL Notes

SQL Notes & Handbooks

Curated revision notes, syntax cheat sheets, and concept guides — organised by skill level.

BEGINNER · BOOK 01

Beginner Notes

Foundational SQL concepts, table basics, and fundamental query syntax to get you started.

SELECT WHERE ORDER BY LIMIT GROUP BY HAVING
17 topics available
INTERMEDIATE · BOOK 02

Intermediate Notes

Multi-table relationships, joins, groupings, and nested queries for deeper SQL mastery.

JOIN GROUP BY HAVING UNION DISTINCT CASE
15 topics covered
ADVANCED · BOOK 03

Advanced Notes

Analytical window functions, CTEs, indexing strategies, and query performance tuning.

CTE Window Functions Subqueries Indexes Query Optimization
18 topics covered