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 Query Equivalence

Design & Execution

Schema Design How a Query Runs SQL Libraries Validating SQL

Quizzes

Q
Intermediate SQL
Why Learn SQL?
C
1.1: Claude's Agentic Stack
C
1.2: How ChatGPT Stores Its Chats
Q
Agentic Data Stacks
Reading Queries Writing Queries 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 →Why Learn SQL?