Fall 2026 Schedule

Weeks 1 to 10 • Tue and Thu • Nov 3 holiday • Test 1 on Thu Oct 29

SQL Systems nanoDB Transactions Distributed Systems

Attendance Requirements (for non-SCPD students)

Tests: Mandatory in-class attendance for Test 1 (Oct 29) and Test 2 (Final). No alternate exam schedules for those with exam conflicts. Please ensure you have no exam conflicts before enrolling in CS 145.
OAE accommodations: Tests will be on the same day with extended hours

Week	Dates	Topics	Deliverables
1	Sep 22 Sep 24	SQL Module 1: SQL Basics Kickoff. SQLite and BigQuery intro. Mission briefing: gear up with SQL.	Setup: Canvas • Gradescope • Ed Setup: BigQuery • Get Credits • Colab Sep 25 • PSET0
2	Sep 29 Oct 1	SQL Module 1: SQL Basics continued CTEs, subqueries, window functions. Debugging Text to SQL.	Oct 2 • PSET 1 (Short) (Module 1)
3	Oct 6 Oct 8	Systems Module 2: Systems Primer nanoDB Module 3: nanoDb BigSort. Hash partition. Foundations for nanoDB.	Oct 9 • PSET 1 (Long) (Module 1)
4	Oct 13 Oct 15	nanoDB Module 3: nanoDB Indexes. Joins. Query planning.	Oct 16 • PSET 2 (Short) (Module 2) Oct 16 • Project 1
5	Oct 20 Oct 22	nanoDb Module 5: Scaling Analytics Part 1: Data designs, Parallelism. Distributed systems.	Oct 30 • PSET 3 (Long) (Module 3)
6	Oct 27 Oct 29	TestTest 1 In class on Thu Oct 29	Oct 29 • Test 1
7	Nov 3 (No class) Nov 5 (Thu only)	Transactions Module 4: Transactions ACID properties. Ticketing case study.
8	Nov 10 Nov 12	Transactions Module 4: Transactions continued Concurrency control, 2PL, LSM Trees. Recovery.
9	Nov 17 Nov 19	Distributed Systems Module 5: Distributed Systems Sharding. Replication. Global consistency. Guest Spanner talk.	Nov 20: Project 2 (Data Science) Nov 20: Project 2 (Data Systems)
10	Nov 24 (No class) Nov 26 (No class)	-	Nov 24: Thanksgiving no class Nov 26: Thanksgiving no class
11	Dec 1 Dec 3	Lessons from industry	Dec 4 • PSET 4 (Long) (Module 4, 5) Dec 4 • PSET 5 (Long) (Distributed Systems)
Finals	Dec 7	TestTest 2 (Finals) In class • 7-10 pm	Dec 7 • Test 2 (Finals) • 7-10 pm