Chapters
SQL chapters roadmap
The full SQL learning path in 500 SQL Queries Explained includes foundational topics, intermediate logic, advanced query patterns, real-world reporting, and bonus interview-prep chapters.
Getting Started
Chapter 1 — Getting Started with NovaMart
1–10 queriesIntroduces the sample database and core mindset behind practical SQL work.
Chapter 2 — Basic SELECT and Filtering
11–25 queriesBuilds the foundation for retrieving and narrowing rows with real examples.
Chapter 3 — WHERE, ORDER BY, and LIMIT
26–40 queriesCovers filters, ordering, and basic result control in everyday reporting queries.
Beginner
Chapter 4 — NULLs and Operators
41–60 queriesExplains logical comparisons, null handling, and practical edge cases.
Chapter 5 — String and Date Functions
61–90 queriesShows how to clean, transform, and analyze text and time-based data.
Chapter 6 — Numeric Functions
91–110 queriesFocuses on arithmetic, rounding, and common data-calculation patterns.
Chapter 7 — Grouping Fundamentals
111–130 queriesIntroduces aggregation and summary thinking for business reporting.
Chapter 8 — Advanced Beginner Skills
131–146 queriesConnects fundamentals to more realistic business questions and patterns.
Intermediate
Chapter 9 — Aggregate Functions
147–170 queriesCoversCOUNT, SUM, AVG, MIN, and MAX with real-world reporting examples.
Chapter 10 — GROUP BY and HAVING
171–190 queriesExplains segmentation and filtering on grouped results.
Chapter 11 — JOINs
191–220 queriesCovers the common join patterns used in relational reporting.
Chapter 12 — Subqueries
221–245 queriesIntroduces nested logical queries and practical use cases.
Chapter 13 — Set Operations and CASE
246–270 queriesShows conditional logic and combining result sets in SQL.
Chapter 14 — INSERT, UPDATE, and DELETE
271–295 queriesExplains data modification patterns with safe and readable examples.
Chapter 15 — Views and Data Operations
296–320 queriesBuilds reusability and abstraction when working with business data.
Advanced
Chapter 16 — CTEs
321–340 queriesIntroduces logical query breakdowns and reusable intermediate sets.
Chapter 17 — Window Functions
341–370 queriesCovers PARTITION BY, ranking, and analytical calculations across rows.
Chapter 18 — Tables, Constraints, and Schema Design
371–390 queriesDiscusses structure, rules, and database integrity in meaningful examples.
Chapter 19 — Indexes and Transactions
391–420 queriesFocuses on performance, correctness, and database reliability.
Chapter 20 — Stored Procedures, Functions, and Triggers
421–450 queriesExplores automation and reusable logic inside relational databases.
Chapter 21 — JSON and Semi-Structured Data
451–480 queriesShows how modern SQL handles structured and nested information.
Chapter 22 — Performance Tuning and Query Optimization
481–500 queriesTeaches how to reason about performance, indexing, and execution plans.
Real-World SQL
Chapter 23 — Business Analytics and Reporting
501–520 queriesTurns SQL into decision-making, metrics, and daily operational analysis.
Chapter 24 — Practical Case Studies
521–530 queriesApplies the full NovaMart dataset to realistic business reporting questions.
Bonus Chapters
Chapter 25 — SQL Interview Questions and Puzzles
531–545 queriesIncludes interview-style questions and tricky SQL logic scenarios.
Chapter 26 — Advanced Query Tuning and Performance
546–547 queriesCovers the tuning techniques and optimization patterns used in real systems.
Ready to learn SQL with real examples?
Learn SQL step by step with practical examples, queries, and interview-focused problem solving.
Get the eBook