Course · Interactive

SQL Advanced

Third SQL course: advanced joins, recursive CTEs, window frames, cohort analytics, JSON, triggers, performance tuning, and shop BI capstones — 35 lessons of deep prose and auto-graded SQLite.

Who it's for

Learners who completed SQL Intermediate — comfortable with joins, subqueries, window functions, and CTEs.

What you'll learn

  • Design semi-joins, recursive CTEs, and advanced window frames
  • Build cohort, YoY, and KPI reports on shop and customer data
  • Apply JSON extraction, triggers, upsert, and index-aware query patterns
  • Deliver a full shop operations capstone report

Course contents

  1. 01Advanced joins & query decomposition
  2. 02Recursive CTEs & deep window analytics
  3. 03Time series, cohorts & JSON
  4. 04Integrity, performance & reporting patterns
  5. 05Shop operations capstone