This syllabus is a living document; please be aware that many elements on this page will change throughout the semester, including the course schedule. It is the student's responsibility to review this page periodically for updates.
I value any and all student feedback. If you would like to provide anonymous course feedback, use this submission form here. Please be constructive in any comments so that I can adjust the course as best possible.
| WEEK | DATE | ANNOUNCEMENTS | TOPIC & READING | ASSIGNMENTS |
|---|---|---|---|---|
| 1 | Sep 04 | Introduction to Databases
| ||
Sep 06 | Data Storage and Buffer Management
| |||
| 2 | Sep 11 | |||
Sep 13 |
Drop/Add ends (Sep 14) | ER Model
| ||
| 3 | Sep 18 | |||
Sep 20 | Relational Model
| |||
| 4 | Sep 25 | |||
Sep 27 | ||||
| 5 | Oct 02 | File Organization
| ||
Oct 04 | ||||
| 6 | Oct 09 | B+ Tree Index
| ||
Oct 11 | ||||
Oct 16 | Fall break | |||
Oct 18 | ||||
| 7 | Oct 23 | Hash Index
| ||
Oct 25 | ||||
| 8 | Oct 29 | Midterm Exam 7-9pm Science Center 199 | ||
Oct 30 | Relational Algebra
| |||
Nov 01 | ||||
| 9 | Nov 06 | SQL (and External Sorting)
| ||
Nov 08 |
CR/NC and Withdraw deadline (Nov 09) | |||
| 10 | Nov 13 | |||
Nov 15 | ||||
| 11 | Nov 20 | Query Evaluation/Optimization/Parallelization
|
Homework 2: Hash Index, Sorting, Relational Algebra, and SQL | |
Nov 22 | Thanksgiving | |||
| 12 | Nov 27 | Query Evaluation/Optimization/Parallelization
(continued) | ||
Nov 29 | ||||
| 13 | Dec 04 | Transaction Management
| ||
Dec 06 | ||||
| 14 | Dec 11 | Distributed Databases, noSQL
| ||
Dec 17 | Final Exam 2-5pm Science Center 199 | |||