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.
Prerequisites
CSTP 1105.
Course type
This course is offered as part of a VCC program and cannot be taken individually.
International students: Eligibility is determined at the program level. Visit the program page for international student requirements and application information.
- SQL databases
- Entity Relational Diagrams
- Data tables and normalization
- Queries and tables
- Queries and manipulating data
- SQL Stored Procedures
- Forms and reports functionality
- Code procedures and functions
- Triggers
- ACID property of a well designed db
- JOIN for db queries
- DB Admin: Backup, Restore
Course schedules
Select your program to see the available course schedules.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 40908 |
January 6, 2026 to April 10, 2026 |
Lab | VCC Downtown Campus | See full schedule |
Online courses listed without scheduled meeting times can be completed on your own schedule. All self-paced courses have on-campus tests. Off-site certified invigilation centres may be used at the student's expense.
How to take this course
This course is offered as part of a VCC program only.
Contact us
If you have any questions, please email at [email protected].
† 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.