This is an advanced course in database management systems, data storage and related topics. Students learn about modern computer system storage requirements, SaaS (Storage as a Service), raw storage media and volume management, Redundant Array of Inexpensive Disks (RAID) system configuration, remote file systems, and various levels of access (file level vs block level).
On the database side, students learn how to backup and perform recovery on a database in a fast and efficient manner and to tune the database to maximize performance. Backup and recovery topics include: instance and media recovery structures, configuring the database archiving mode, user-managed backup and recovery, automatic backup and recovery, database maintenance, importing and exporting, and loading data.
Prerequisites
CSTP 1201 Introduction to Database Management Systems (DBSM)
Missing prerequisites?
Learn more about VCC's academic upgrading or English as a Second Language (ESL) courses, or discover which university transfer options are right for you.
What you will learn
- Components and functions of database management systems (DBMSs)
- Model users' data requirements using conceptual modeling techniques
- Transform data models into normalized database designs
- Referential integrity through constraints
- Relational database designs and design views
- SQL statements to modify data and to retrieve data from multiple table
- Transaction management and concurrency control
- Non-procedural queries
- Query optimization techniques
How to register
This course is offered as part of a VCC program only.
Course schedules
Select your program to see the available course schedules.
Contact us
If you have any question, please email at advising@vcc.ca.
† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.