Calendar
This calendar is subject to change. Please check back regularly for updates.
All readings are from the textbook unless otherwise noted.
| Week | Day | Lecture | Readings | Assignment Release | Assignments Due |
|---|---|---|---|---|---|
| 1 | Mon Mar 24 | Class Intro & Relational Model | Ch. 1 | Syllabus Quiz / HW0 | |
| Tue Mar 25 | |||||
| Wed Mar 26 | Relational Model & DB Overview | Ch. 2, Ch. 10.1 | |||
| Thu Mar 27 | |||||
| Fri Mar 28 | Rust Primer | Syllabus Quiz Due | |||
| 2 | Mon Mar 31 | SQL (1/2) | Ch. 4, Ch. 5 | SQL Out | |
| Tue Apr 01 | |||||
| Wed Apr 02 | SQL (2/2) & Application Development | Ch. 9 | |||
| Thu Apr 03 | |||||
| Fri Apr 04 | Rust Primer I Due | ||||
| 3 | Mon Apr 07 | Schema / Database Design | Ch. 6 | ||
| Tue Apr 08 | |||||
| Wed Apr 09 | Data Storage Architectures | Ch. 13.1 - Ch. 13.3 | CrustyDB1 Out | ||
| Thu Apr 10 | |||||
| Fri Apr 11 | SQL Due / Late Syllabus Quiz | ||||
| 4 | Mon Apr 14 | Indexes (1/2) | Ch. 14.1 - Ch. 14.2, 14.5 | ||
| Tue Apr 15 | |||||
| Wed Apr 16 | Indexes (2/2) | Ch. 14.3 | |||
| Thu Apr 17 | |||||
| Fri Apr 18 | |||||
| 5 | Mon Apr 21 | Advanced Indexes and Buffering | Ch. 13.5, Ch. 24.2 | ||
| Tue Apr 22 | |||||
| Wed Apr 23 | Query Execution | Ch. 15 | Rust Primer 2 Out | ||
| Thu Apr 24 | |||||
| Fri Apr 25 | CrustyDB2 Out | CrustyDB 1 Due | |||
| 6 | Mon Apr 28 | Midterm Review | |||
| Tue Apr 29 | |||||
| Wed Apr 30 | Query Optimization | Ch. 15 | Midterm at 7-9pm | ||
| Thu May 01 | |||||
| Fri May 02 | Rust Primer 2 Due | ||||
| 7 | Mon May 05 | Transactions | Ch. 17 | ||
| Tue May 06 | |||||
| Wed May 07 | Concurrency Control | Ch. 18.1 - Ch. 18.4 | |||
| Thu May 08 | |||||
| Fri May 09 | CrustyDB 3 Out | CrustyDB2 Due | |||
| 8 | Mon May 12 | Recovery | Ch. 19 | ||
| Tue May 13 | |||||
| Wed May 14 | Distributed and Parallel DBs (1/2) | Ch. 20-20.5, Ch. 21 | |||
| Thu May 15 | |||||
| Fri May 16 | |||||
| 9 | Mon May 19 | Distributed and Parallel DBs (2/2) | Ch. 23 | ||
| Tue May 20 | |||||
| Wed May 21 | Non-Relational Database Systems | ||||
| Thu May 22 | |||||
| Fri May 23 | CrustyDB 3 Due | ||||
| RP | Mon May 26 | Final Review? | |||
| Exam Week | Tue May 27 | ||||
| Wed May 28 | Final 5:30-7:30 | ||||
| Thu May 29 | |||||
| Fri May 30 |