KickoffSQLSystemsnanoDBTransactionsDistributedData Systems
SQL

SQL Introduction

Learning Outcomes Spotify Database

Basic

Intro & Key Problems SELECT-FROM-WHERE NULLs GROUP BY HAVING Sets and Multisets JOINs Subqueries: Basic Subqueries: Correlated
Q
Basic SQL

Intermediate SQL

CTEs Window Functions Debug Tables Reading Queries Writing Queries Query Equivalence

Design & Execution

Schema Design How a Query Runs SQL Libraries Validating SQL

Quizzes

Q
Intermediate SQL

Reference

SQL Cheat Sheet
Why Learn SQL?
C
1.1: Claude's Agentic Stack
C
1.2: How ChatGPT Scales PostgreSQL
Q
Agentic Data Stacks
Colab: SQL Practice Problems Interview Prep

Intermediate SQL Quiz

Test your understanding of advanced SQL concepts including LLMs and SQL debugging, CTEs, and Window Functions.

DB Schema: Use spotify-db.html for table schemas and data while answering these questions.

← PreviousValidating SQLNext →SQL Cheat Sheet