SQL Intermediate Level Guide - Ebook with Saud Ansari

Develop SQL skills beyond basic SELECT queries.

Topics include JOINs, grouping, subqueries, CTEs, window functions, date and pattern matching, data modification and query performance.

What you receive

A ZIP download with the revised 53-page PDF, fictional SQL starter data and beginner answers plus a foundational JOIN example. Updated 6 October 2026 with corrected recursion syntax, regex, weekday handling and performance explanations.

SQL Server / T-SQL is the primary dialect; other dialect examples are labeled. Intermediate examples use additional illustrative schemas. Basic SQL knowledge is required. The starter data is not a complete dataset for every chapter.

By Saud Ansari | DataTalksWithSaud