PGExercises
pgexercises.com
A 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.
Why it is useful
Focuses specifically on PostgreSQL rather than generic SQL, covering features like CTEs, window functions, and the LATERAL join that most SQL tutorials skip. The exercises use a realistic schema (a sports club with members, facilities, and bookings) rather than toy tables, which makes the problems feel like real work. The solution explanations are detailed enough to teach the reasoning, not just the answer.
More in Learning Resources
Other learning resources you might not have heard of.
- AnimagraffsEducational site publishing animated technical explainers on engines, aircraft, electronics, infrastructure, vehicles, watches, and other mechanical or scientific systems.
- CodeCraftersA platform where you rebuild production software from scratch — your own Redis, Git, Docker, SQLite, or HTTP server — guided by test suites that verify your implementation competes with the real thing.
- Khan AcademyFree world-class education platform covering math, science, humanities, and test prep for all ages.
- Missing SemesterMIT course teaching the practical CS tools that university curricula skip — shell, git, vim, and more.
- Refactoring GuruA beautifully illustrated guide to design patterns and refactoring techniques — covering all 23 Gang of Four patterns and dozens of refactoring recipes with before/after code examples in multiple languages.
- Stanford Encyclopedia of PhilosophyA comprehensive, peer-reviewed online encyclopedia of philosophy maintained by Stanford University — free, authoritative, and continuously updated.