Data Management

Author

Philippe Mongeon

Published

January 4, 2023

Course overview

This course (and this accompanying website) is designed to provide 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 every day and feel confident in your ability to work with data and design effective databases that meet the needs of your users.

Note

This book can be accessed directly from your browser (without going through Brightspace) using the following URL: https://pmongeon.github.io/info6540/

Schedule

Week Topics
Week 1 (Jan 6-10) Course overview
Week 2 (Jan 13-17) Thinking about data
Week 3 (Jan 20-24) Relational model
Week 4 (Jan 27-31) Relational model
Week 5 (Feb 3-7) Relational model
Week 6 (Feb 10-14) Relational database management systems
Reading week (Feb 17-21)
Week 7 (Feb 24-28) Structured Query Language (SQL)
Week 8 (Mar 3-7) Structured Query Language (SQL)
Week 9 (Mar 10-14) Free lab time
Week 10 (Mar 17-21) Document databases
Week 11 (Mar 24-28) Graph databases
Week 12 (Mar 31-Apr 4) Course wrap-up

Assignments

Important

Use the course’s BrightSpace to:

  • Access the syllabus (under the content - overview tab).

  • Access assignments instructions and due dates.

  • Submit your assignments.