Knowledge
| Resource | What it covers |
|---|---|
| Book: Database System Concepts — Silberschatz, Korth & Sudarshan (McGraw-Hill, 7th ed.) | Standard text for SQL foundations. Covers DDL, DML, joins, aggregation, subqueries, and advanced SQL (Ch. 3–5). |
| Reference: SELECT syntax — PostgreSQL Documentation | Definitive syntax reference for SELECT, FROM, WHERE, GROUP BY, HAVING, WINDOW, ORDER BY. Use for settling syntax and execution-order questions. |
| Reference: SQL Window Functions — PostgreSQL Documentation | Canonical guide to OVER, PARTITION BY, ranking and aggregate windows. Use for window-function lessons. |
| Book: Learning SQL — Alan Beaulieu (O’Reilly, 3rd ed.) | Hands-on, example-driven SQL tutorial from SELECT basics through transactions and indexes. Use for runnable exercises. |
Wisdom (Communities)
| Resource | What it covers |
|---|---|
| Stack Overflow — SQL tag | Use for specific “why does this query behave this way” questions and dialect differences. |
| r/SQL | Practitioner Q&A on query design, performance, and schema tradeoffs. Use for seeing how experts reason about real queries. |