| Week | Topics |
|---|---|
| Week 1 (Jan 8-12) | Course overview |
| Week 2 (Jan 15-19) | Thinking about data |
| Week 3 (Jan 22-26) | Relational model |
| Week 4 (Jan 29-Feb 2) | Relational model |
| Week 5 (Feb 5-9) | Relational model |
| Week 6 (Feb 12-16) | Relational database management systems |
| Reading week (Feb 19-23) | |
| Week 7 (Feb 26-Mar 1) | Structured Query Language (SQL) |
| Week 8 (Mar 4-8) | Structured Query Language (SQL) |
| Week 9 (Mar 11-15) | Free lab time |
| Week 10 (Mar 18-22) | Document databases |
| Week 11 (Mar 25-29) | Graph databases |
| Week 12 (Apr 1-5) | Course wrap-up |
Data Management
Course overview
This course (and this accompanying website) are designed to provide you with a practical introduction to data management. It is a hands-on course in which you will get comfortable working with data, with a focus on data structures and database design. After completing this course, you hopefully will have a better understanding of how data infrastructures support the organizations, websites and applications that we use everyday, and feel confident in your ability to work with data and design effective databases that meet the needs of your users.
Schedule
For the Winter 2024 semester, the course will be online, with optional (but strongly recommended) lab times on Tuesday night 5:35 pm to 8:25 pm in Rowe 1016 and Thursday afternoons from 1:00 pm to 4:00 pm at Rowe 4025.
If you wish to book a meeting with me on Teams or outside of office hours, please use this link.
Assignments
Important
Use the course’s BrightSpace to:
Access the detailed instructions and due dates for the assignments.
Submit your assignments.
Other resources
- Course syllabus (in case of discrepancy, the course website and Brightspace prevail).