SQLZoo
sqlzoo.net
A free interactive SQL tutorial with real database exercises covering SELECT, JOIN, aggregation, subqueries, and window functions — runnable directly in the browser against live datasets.
Why it is useful
One of the most effective ways to learn SQL because every exercise runs immediately against real data, so you see the output of your query instantly. The progression from basic SELECT to complex window functions is well-paced. The Nobel Prize, World, and COVID datasets used in the exercises are interesting enough to keep you engaged. No account required, and the exercises get genuinely challenging.
More in Learning Resources
Other learning resources you might not have heard of.
- 3Blue1BrownVisual mathematics videos and interactive lessons that build genuine intuition for complex topics.
- JavaScript.infoA comprehensive and modern JavaScript tutorial covering the language from fundamentals to advanced topics — prototypes, async/await, closures, generators, and the DOM — with interactive exercises throughout.
- Stanford Encyclopedia of PhilosophyA comprehensive, peer-reviewed online encyclopedia of philosophy maintained by Stanford University — free, authoritative, and continuously updated.
- Advent of CodeAn annual set of 25 daily programming puzzles released each December, solvable in any language, with a global leaderboard.
- PGExercisesA free PostgreSQL practice site with 80+ exercises covering joins, aggregation, subqueries, window functions, recursive queries, and date operations — running against a realistic club membership dataset.
- Typing.comFree touch typing course with structured lessons, games, and progress tracking for all skill levels.