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

Agentic Data Stacks Quiz

Check your understanding of the module: the ambiguity one English question hides, the four parts of the loop that closes it, the semantic layer and eval set Anthropic built around it, and scaling reads with replicas.

DB Schema: Use spotify-db.html for the table schemas and data while you answer.

← PreviousCase Study 1.2: How ChatGPT Stores Its ChatsNext →Reading Queries