Data Storage

In this module on databases, database management systems will be covered. A basic understanding of SQL is considered as a prerequisite, and students can refer to the slides and additional resources if needed. For evaluation, students will install and explore the advantages of different DBMSs as a graded project.

In this first class, we introduce the basics of database management systems and cover high level DBMS functionality.

Slides

For the next class, students should install PostgreSQL and MongoDB on their local machines.

Additional Resources

• PostgreSQL documentation
• MongoDB documentation
• SQLBolt - SQL exercises
• Databases introduction (fr)
• A comprehensive overview of database systems (en)