Skip to content

MSIT 5210 - Databases: Learning Materials

Get Ready For Your College Courses

To best prepare for your future studies, please review the below preparation resources. We encourage you to use the time before starting your first term, to get a taste of the topics of your upcoming courses. There’s no better time to start than now! Good luck with your studies!

Learn Principles of Databases

Course Overview

Developing and managing efficient and effective database applications requires understanding the fundamentals of database management systems, techniques for the design of databases, and database administration principles. This course will emphasize database concepts, developments, use, and management in three main areas: database concepts, practice, and emerging trends. Relational database systems are the main focus, but other types, including object-oriented databases, are studied. The practical design of databases and developing database applications using modern software tools will be emphasized.

Preparation Resources

Additional resources to all required reading will be provided in the course Learning Guide for each week.

 

MSIT 5210 Databases - Course Schedule and Topics:

This course will cover the following topics in eight learning sessions, with one Unit per week.

Week 1: Unit 1 - Database System Fundamentals

Week 2: Unit 2 - Database Design and Models

Week 3: Unit 3 - Structured Query Language (SQL)

Week 4: Unit 4 - Database Administration

Week 5: Unit 5 - Database Security and Ethicals

Week 6: Unit 6 - Back-up and Recovery Options

Week 7: Unit 7 - Data Marts and Data Warehouses

Week 8: Unit 8 - Emerging Database Technologies