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