🏠 CS145: SQL

Day1kickoff

Course Logistics Metro Map

SQL Introduction

Learning Outcomes 📘 Case Study 1.1: UberEats Spotify Database

Basic

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

Intermediate

CTEs Window Functions Debug Tables LLMs and SQL Query Equivalence 📝 Quiz

Problem Solving

Reading Queries Writing Queries 📘 Case Study 1.2: SQL vs Pandas 📘 Case Study 1.3: Key-Value 📘 Case Study 1.4: Mobile SQL Colab: SQL Practice Problems

DB Systems

Parallel Execution Zero Trust Data Security Data Privacy 📘 Case Study 1.5: Privacy 📝 Quiz

Optional

📘 Case Study 1.6: Modern Trends Architecture: Startups Architecture: Big Tech Data Types: JSON, Geo, Vectors Interview Prep 📝 Quiz

Architecture Quiz

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