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 22 | HW 0 | 1.1 – 1.5, Syllabus | |
| 2. Basics of SQL | Aug 27 | Aug 29 | HW 1 | 2.1 – 2.6, sqlite3 |
| 3. Key Constraints | Sep 03 | Sep 05 | HW 2 | 2.7 – 2.12, Connector |
| 4. ER / EER Models | Sep 10 | Sep 12 | GP 1 | 3.1 – 3.6, 4.1 – 4.3 |
| 5. EER to Relational | Sep 17 | Sep 19 | HW 3 | 3.7 – 3.9, 4.4 – 4.6 |
| 6. Normalization | Sep 24 | Sep 26 | GP 2 | 3.10 – 3.12, 5.1 – 5.2 |
| 7. Complex Queries | Oct 01 | Oct 03 | HW 4 | 5.3 – 5.7, Set Ops |
| 8. Data Generation | Oct 08 | Oct 10 | GP 3 | 5.8, Faker, Psycopg |
| 9. Fall Break | Oct 15 | |||
| 10. Web Applications | Oct 22 | Oct 24 | HW 5 | Flask, Jinja, Charts |
| 11. Query Processing | Oct 29 | Oct 31 | GP 4 | 6.3 – 6.7 |
| 12. Transactions | Nov 05 | Nov 07 | HW 6 | 7.1, 7.5, SQL, PL/pgSQL |
| 13. Complex Data | Nov 12 | Nov 14 | GP 5 | 8.1 – 8.3, FTS, JSON |
| 14. NoSQL Databases | Nov 19 | Nov 21 | HW 7 | 9.1 – 9.6, MongoDB |
| 15. Course Wrap-Up | Dec 03 | Dec 05 | GP 6 |
Important Dates¶
See Academic Calendar and Fall Deadlines.
- Aug 21: First day of classes
- Aug 30: Add/drop deadline
- Sep 27–29: Family Weekend
- Oct 16–18: Fall Break
- Oct 23: Withdraw deadline
- Oct 25–27: Homecoming Weekend
- Nov 04: Spring enrollment begins
- Nov 25–29: Thanksgiving Break
- Dec 06: Last day of classes
- Dec 09–13: Final exams
- Dec 16: Grades submitted
Final Exam Times¶
See the official Fall 2024 Exam Schedule.
- Sec 1 (12:45pm): Tue, Dec 10th 10:30–12:30
- Sec 2 (2:20pm): Thu, Dec 12th 1:00–3:00