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 |