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
- Watt, A., & Eng, N. (2014). Database Design, 2nd Edition. Opentext. https://opentextbc.ca/dbdesign01/
- Darwen, H. (2014). An Introduction to Relational Database Theory. https://enciklopediamoderne.files.wordpress.com/2014/09/hugh-darwen-an-introduction-to-relational-databse-theory.pdf
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