Calendar
The table below links to the notes, reading, and homework for each week. Use the search feature to find specific activities, labs, examples, etc. The topics and order are subject to change as the course progresses. Exam dates are highlighted.
| Week / Topic | Tue | Thu | Reading | Homework |
|---|---|---|---|---|
| 1. Introduction | Aug 27 | Week 1 | ||
| 2. Basics of SQL | Sep 01 | Sep 03 | Week 2 | HW1 |
| 3. Python DB-API | Sep 08 | Sep 10 | Week 3 | HW2 |
| 4. Project Kickoff | Sep 15 | Sep 17 | Week 4 | GP1 |
| 5. ER/EER Models | Sep 22 | Sep 24 | Week 5 | HW3 |
| 6. PostgreSQL | Sep 29 | Oct 01 | Week 6 | GP2 |
| 7. SQLModel | Oct 06 | |||
| 8. Exam 1, ORM | Oct 13 | Oct 15 | Week 8 | HW4 |
| 9. Loading Data | Oct 20 | Oct 22 | Week 9 | GP3 + PE1 |
| 10. Advanced SQL | Oct 27 | Oct 29 | Week 10 | HW5 |
| 11. Views, Indexes | Nov 03 | Nov 05 | Week 11 | GP4 |
| 12. DB Backends | Nov 10 | Nov 12 | Week 12 | HW6 |
| 13. NoSQL Databases | Nov 17 | Nov 19 | Week 13 | GP5 |
| 14. Review, Exam 2 | Dec 01 | Dec 03 | ||
| 15. Prototyping | Dec 08 | Dec 10 | GP6 + PE2 |
Important Dates
See Academic Calendar and Fall Deadlines.
- Aug 26: First day of classes
- Sep 04: Add/drop deadline
- Oct 02–04: Family Weekend
- Oct 07–09: Fall Break
- Oct 16–18: Homecoming Weekend
- Oct 27: Withdraw deadline
- Nov 09: Spring enrollment begins
- Nov 23–27: Thanksgiving Break
- Dec 11: Last day of classes
- Dec 14–18: Final exams
- Dec 21: Grades submitted
Final Exam Times
See the official Fall 2026 Exam Schedule.
- Sec 1 (12:45pm): Tue, Dec 15th 10:30–12:30