BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//CS145//Fall 2026//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:CS145 Fall 2026
X-WR-TIMEZONE:America/Los_Angeles
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260922
DTEND;VALUE=DATE:20260923
SUMMARY:CS145 Lecture: Module 1 SQL Basics
DESCRIPTION:Kickoff. SQLite and BigQuery intro.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260924
DTEND;VALUE=DATE:20260925
SUMMARY:CS145 Lecture: Module 1 SQL Basics
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260925
SUMMARY:CS145 Due: PSET 0
DESCRIPTION:Setup: Canvas, Gradescope, Ed, BigQuery, Colab
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260929
DTEND;VALUE=DATE:20260930
SUMMARY:CS145 Lecture: Module 1 SQL continued
DESCRIPTION:CTEs, subqueries, window functions.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261001
DTEND;VALUE=DATE:20261002
SUMMARY:CS145 Lecture: Module 1A Data Systems
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261002
SUMMARY:CS145 Due: PSET 1 (Short) - Module 1
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261006
DTEND;VALUE=DATE:20261007
SUMMARY:CS145 Lecture: Module 2 Systems Primer
DESCRIPTION:IO cost model, storage hierarchy.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261008
DTEND;VALUE=DATE:20261009
SUMMARY:CS145 Lecture: Module 3 nanoDB
DESCRIPTION:BigSort, Hash partition. Foundations for nanoDB.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261009
SUMMARY:CS145 Due: PSET 1 (Long) - Module 1
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261013
DTEND;VALUE=DATE:20261014
SUMMARY:CS145 Lecture: Module 3 nanoDB
DESCRIPTION:Indexes, Joins, Query planning.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261015
DTEND;VALUE=DATE:20261016
SUMMARY:CS145 Lecture: Module 3 nanoDB continued
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261016
SUMMARY:CS145 Due: PSET 2 (Short) - Module 2
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261016
SUMMARY:CS145 Due: Project 1
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261020
DTEND;VALUE=DATE:20261021
SUMMARY:CS145 Lecture: Module 5 Scaling Analytics
DESCRIPTION:Data designs, Parallelism, Distributed systems.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261022
DTEND;VALUE=DATE:20261023
SUMMARY:CS145 Lecture: Module 5 continued
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261023
SUMMARY:CS145 Due: PSET 3 (Long) - Module 3
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261027
DTEND;VALUE=DATE:20261028
SUMMARY:CS145 Lecture: Module 4 Transactions
DESCRIPTION:ACID properties, Ticketing case study.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261029
DTEND;VALUE=DATE:20261030
SUMMARY:CS145 Lecture: Module 4 Transactions continued
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261030
SUMMARY:CS145 Due: Project 2 Proposal
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261105
DTEND;VALUE=DATE:20261106
SUMMARY:CS145 Lecture: Module 4 Transactions (2PL, LSM)
DESCRIPTION:Nov 3 holiday - no class. Thursday only.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261110
DTEND;VALUE=DATE:20261111
SUMMARY:CS145 Lecture: Module 4 WAL & Recovery
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261112
DTEND;VALUE=DATE:20261113
SUMMARY:CS145 Lecture: Module 4 continued + Guest Speakers
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261117
DTEND;VALUE=DATE:20261118
SUMMARY:CS145 Lecture: Module 5 Distributed Systems
DESCRIPTION:Sharding, Replication, Global consistency.
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261119
DTEND;VALUE=DATE:20261120
SUMMARY:CS145 Lecture: Module 5 + Guest Spanner talk
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261120
SUMMARY:CS145 Due: Project 2 (Data Science)
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261120
SUMMARY:CS145 Due: Project 2 (Data Systems)
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261201
DTEND;VALUE=DATE:20261202
SUMMARY:CS145 Lecture: Industry Lessons
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261203
DTEND;VALUE=DATE:20261204
SUMMARY:CS145 Lecture: Industry Lessons
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261204
SUMMARY:CS145 Due: PSET 4 (Long) - Module 4/5
END:VEVENT
BEGIN:VEVENT
DTSTART;VALUE=DATE:20261204
SUMMARY:CS145 Due: PSET 5 (Long) - Distributed Systems
END:VEVENT
BEGIN:VEVENT
DTSTART:20261207T190000
DTEND:20261207T220000
SUMMARY:CS145 Final Exam
DESCRIPTION:In class, 7-10pm. Mandatory attendance.
END:VEVENT
END:VCALENDAR