Database Systems (CSTP 1210)
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.
Course code: CSTP 1210
Credits: 3.0
Length: 60.0 hours
Course outline:
view
https://www.vcc.ca/vccphp/courseoutline?subject=CSTP&number=1210
Prerequisites
CSTP 1130 or equivalent, taken prior to or concurrently.
* The amount shown is the approximate cost of tuition (for courses with tuition) or fees (for courses that do not have tuition).
Tuition and 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.