🏠 CS145: SQL

Day1kickoff

Course Logistics Metro Map

SQL Introduction

Learning Outcomes Why SQL? Spotify Database

Basic

SELECT-FROM-WHERE NULLs GROUP BY HAVING Sets and Multisets JOINs Subqueries: Basic Subqueries: Correlated 📝 Quiz

Intermediate

LLMs and SQL CTEs Window Functions 📝 Quiz

Problem Solving

Debug Tables Reading Queries Writing Queries Query Equivalence

DB Design For...

Startups Parallelism Big Tech Complex Data Types Popular Workflows 📝 Quiz 1 Zero Trust Data Security Data Privacy 📝 Quiz 2 Interview Tips

Architecture Quiz

Test your understanding of SQL to parallel execution and database system use cases.