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.
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
- 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
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.
| 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.
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.