Course Overview
This course is for students who have a special interest in database technology. Topics include: database transactions, concurrency control and recovery techniques in multi-user database systems, database security, distributed databases, and current trends in database technologies. Students will use common industry database software products such as Microsoft SQL Server and/or MySQL DBMSs.
Prerequisite(s)
- 50% in COMP 3920
Credits
5.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion, the student will be able to:
- Identify the key requirements of a multi-user as well as a distributed database management system.
- Evaluate the role of transaction management, concurrency control and recovery in meeting these requirements.
- Discuss current trends in database technologies.
- Implement and administer a relational database system, such as MySQL and/or SQL Server DBMSs.
- Develop database applications that use a relational database to retrieve, store and modify data for data persistence.
Effective as of Fall 2024
Related Programs
Database Systems 2 (COMP 4921) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
School of Computing and Academic Studies
- Computer Systems Technology
Diploma Full-time
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.