🏠 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 SQL for Complex Types Data Privacy

DB Architectures

SQL to Parallel System Use Cases Popular Workflows 📝 Architecture Quiz 📝 Quiz 2

Architecture Quiz

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