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.
| Week / Topic | Tue | Thu | Homework | Reading |
|---|---|---|---|---|
| 1. Introduction | Aug 21 | HW0 | 1.1, 3.1 | |
| 2. Basic Queries | Aug 26 | Aug 28 | HW1 | 1.2, 1.3, 1.4 |
| 3. Python DB-API | Sep 02 | Sep 04 | HW2 | 1.5, 1.6, 1.7 |
| 4. ER/EER Models | Sep 09 | Sep 11 | GP1 | 2.1, 2.2 |
| 5. Database Design | Sep 16 | Sep 18 | GP2 | 2.3, 2.4 |
| 6. EER to Relational | Sep 23 | (Sep 25) | GP3 | 1.9, 3.4 |
| 7. Data Generation | Sep 30 | Oct 02 | HW3 | Faker, Psycopg |
| 8. Midterm Exam | Oct 07 | Oct 09 | ||
| 9. Object-Relational | Oct 14 | Oct 16 | HW4 | SQLAlchemy |
| 10. Fall Break | Oct 21 | GP4 | Model Views | |
| 11. Complex Queries | Oct 28 | (Oct 30) | HW5 | 1.8, 1.10, 1.11 |
| 12. Web Applications | Nov 04 | Nov 06 | GP5 | Forms, Charts |
| 13. NoSQL Databases | Nov 11 | Nov 13 | HW6 | MongoDB, Cypher |
| 14. Special Topics | Nov 18 | Nov 20 | GP6 | PL/pgSQL, 3.3 |
| 15. Course Wrap-Up | Dec 02 | Dec 04 |
Important Dates¶
See Academic Calendar and Fall Deadlines.
- Aug 20: First day of classes
- Aug 29: Add/drop deadline
- Sep 26–28: Family Weekend
- Oct 17–19: Homecoming Weekend
- Oct 21: Withdraw deadline
- Oct 22–24: Fall Break
- Nov 03: Spring enrollment begins
- Nov 24–28: Thanksgiving Break
- Dec 05: Last day of classes
- Dec 08–12: Final exams
- Dec 15: Grades submitted
Final Exam Times¶
See the official Fall 2025 Exam Schedule.
- Sec 1 (12:45pm): Thu, Dec 11th 10:30–12:30
- Sec 2 (2:20pm): Tue, Dec 9th 1:00–3:00