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

Basic SQL Quiz

Test your understanding of SQL concepts including SELECT-FROM-WHERE, NULLs, GROUP BY, HAVING, JOINs, and Subqueries.

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

← PreviousSubqueries: CorrelatedNext →CTEs