Weeks 1 to 10 • Tue and Thu • Nov 3 holiday
PSETs and projects are due at 11:59 pm Pacific on the stated deadline. You have 2 PSET late days and 2 project late days for the quarter; they cannot be exchanged. Each adds exactly 24 hours, including weekends and holidays. Use one day on each of two assignments or both on one, within the same category. Submissions beyond your allowed extension receive no credit. No late days apply to the Project 2 proposal, due October 30 at 11:59 pm Pacific. In case of extenuating circumstances, only the head CA can grant additional extensions. Please reach out through a private Ed post before the deadline, or as soon as you can if circumstances prevent that.
These requirements apply to non-CGOE students.
Attend in person. We cannot offer alternate times for exam conflicts, so resolve any conflict before enrolling.
The exam remains on Dec 7; extended time will be scheduled that day.
Contact your CGOE proctor or administrator. We will coordinate the final through CGOE and email the exam information to your proctor.
Upcoming times, in Pacific time.
Following the course. Use the live slides below, read the course notes, and complete the matching PSET. The optional module quiz is a quick, self-graded check; there is nothing to submit. Modules build on one another. The lecture PDF archive keeps fixed copies of the slides.
Course notes. Notes linked below are required unless marked Optional at the top of the page. Open Modules to revisit a topic, and use Video mode for a fast pass.
Assignments. PSETs and projects are graded deliverables; nano quizzes provide optional Path 1 credit. Use the exam prep path to prepare for the final. PSET and project deadlines appear below.
New to CS145? Read Logistics/FAQs, browse the 20 questions this course answers, or take the .
| Week | Lectures (Tue / Thu) | Sections and Deliverables | Reading |
|---|---|---|---|
| 1Sep 22, 24 |
M1 Basic SQL |
|
Required · 4 Full Module · In scope for the final |
| 2Sep 29, Oct 1 |
M1 Intermediate SQLM6 Patterns of Big Data SystemsM2 Systems Basics |
Clarification: PSET 1
No deliverables this week
|
Required · 5 Full Module · In scope for the final |
| 3Oct 6, 8 |
M2 M2 BasicsM3 Starting nanoDB |
Oct 5PSET 1
|
Required · 6 Full Module · In scope for the final |
| 4Oct 13, 15 |
M3 Indexing and Query PlanningThu, Oct 15: Query planning. |
Clarification: Project 1 & PSET 3
|
Required · 6 Full Module · In scope for the final |
| 5Oct 20, 22 |
M4 Transactions Intro |
Clarification: PSET 3
|
Required · 4 Full Module · In scope for the final |
| 6Oct 27, 29 |
M4 Concurrency Control |
Project 2 Deep-Dives
Parallel sessions on Systems and Science. Clarification: Project 2 Questions
Oct 30Project 2 Proposal
|
Required · 4 Full Module · In scope for the final |
| 7Nov 3 (no class), Nov 5 |
M4 Recovery and Logging |
Full walkthrough: Macroschedules, Microschedules, WAL & Recovery.
No deliverables this week
|
Required · 4 Full Module · In scope for the final |
| 8Nov 10, 12 |
M5 Scaling Analytics |
Clarification: Project 2 Details
Nov 9PSET 4 · coming soon
|
Required · 5 Full Module · In scope for the final |
| 9Nov 17, 19 |
M5 Distributed Systems |
Systems Design & PSET 5 Prep
Sharding, replication, consistency trade-offs. Clarification: PSET 5 Details
Nov 20Project 2 (Data Science)
Nov 20Project 2 (Systems)
|
Required · 4 Full Module · In scope for the final |
| 10Nov 24, 26 |
Thanksgiving Break
|
No section this week
No deliverables this week
|
Required Thanksgiving. |
| 11Dec 1, 3 |
Lessons from industry
|
Dec 2PSET 5 · coming soon
|
Required · 6 |