In this course students will learn how to manage SQL database systems, including performing basic database administration. Students will learn how to configure a database to support different applications and to perform tasks such as creating users and database schema, applying constraints, setting up access control, assigning memory, defining storage structures and manipulating data. Since database administration does not end after the database is created, students will learn the importance of backup and recovery strategy. Students will become familiar with fundamental concepts in the field such as transnational operations, ACID property, backup and redundancy, data integrity, various database roles (database admin, database programmer, database designer), database normal forms, join operations, and how to perform queries.
Course code: CSTP 1201
Length: 80 hours
Course outline: viewhttps://www.vcc.ca/deptUploads/course-outlines/CSTP-1201.pdf
PrerequisitesCSTP 1105 Introduction to Programming
* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.
† 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.