SQL Setup [~6 mins]
SQL Setup [~6 mins]
SQL Colab -- Section 1
Embedded Files
Video 0 [2 mins]: Intro to Example Systems
Video 1 [4 mins]: DB Setup for SQL lite, Setup Spotify schema, Load data
SQL Basics [~22 mins]
SQL Basics [~22 mins]
SQL Colab -- Section 1
Video 2 [12 mins]: SELECT, WHERE, GROUP BY, JOINs, HAVING
Video 3 [5 mins]: NULL values, SET operators
Video 4 [5 mins]: Subqueries
SQL Intermediate [~19 mins]
SQL Intermediate [~19 mins]
SQL Colab -- Section 2, 3, 4
Video 5 [2.5 mins]: How to write queries by breaking down problems into sub-goals?
Video 6 [7.5 mins]: Modular code using CTEs, Partition/Window functions
Video 7 [9 mins]: Text 2 SQL using LLMs (e.g., GPT-4o). Correctness, debug tables, equivalent queries
SQL use cases [~8 mins]
SQL use cases [~8 mins]
Video 8 [5 mins]: SQL in other engines
SQL Colab on DuckDB, BigQuery, Spark
Video 9 [3 mins]: Example SQL use cases for building consumer apps, data science, and ETL to extract-transform-load data
Optional reads
Optional reads
Below will not be tested in cs145. Useful for general awareness and interviews
Industry blogs
Uber's blogs on MySQL, BigQuery, Spanner, PrestoSQL
Spotify blog on MySQL, BigQuery
Notion blog on scaling PostgresSQL
Why noSQL systems (like HBASE) systems are failing at scale? [opinion piece]
Page updated
Google Sites
Report abuse