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

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