Course · Interactive

SQL Intermediate

Second SQL course: multi-table joins, subqueries, window functions, CTEs, views, transactions, and academy analytics projects — 32 lessons of deep prose and auto-graded SQLite.

Who it's for

Learners who completed SQL Beginner or equivalent — comfortable with SELECT, JOIN, and GROUP BY.

What you'll learn

  • Write correlated subqueries and EXISTS patterns
  • Use window functions for ranking and running totals
  • Structure reports with CTEs and views
  • Complete multi-step analytics projects on academy data

Course contents

  1. 01Advanced joins & subqueries
  2. 02Functions, CASE, and set operations
  3. 03Window functions & CTEs
  4. 04Schema, performance, transactions
  5. 05Analytics projects & capstone