Students learn the basics of relational and non-relational database management systems (SQL and NoSQL). It covers the fundamental concepts of relational databases such as records, tables, normal forms, join operations, queries, data modeling, and data integrity. Students learn how to configure and manage SQL database systems and how to perform basic database administration tasks such as creating users and database schema, applying constraints, setting up access control, assigning memory, defining storage structures and manipulating data. They learn fundamental concepts such as transnational operations, ACID (Atomicity, Consistency, Isolation, and Durability), backup and redundancy, data recovery, database user roles, and concurrency control. Finally, students gain hands-on experience with non-relational (NoSQL) databases such as MongoDB.
Prerequisites
CSTP 1130 or equivalent, taken prior to or concurrently.
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 data retrieval
- Queries and data manipulation
- SQL stored procedures
- Forms and reports
- NoSQL databases
- ACID property of well designed databases
- Database administration
Course schedules
Select your program to see the available course schedules.
| CRN# | Duration | Delivery | Location | ||
|---|---|---|---|---|---|
| 42436 |
January 4, 2027 to April 15, 2027 |
Lecture | 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.