This is an advanced course in database management systems, data storage and related topics. Students learn about modern computer system storage requirements, SaaS (Storage as a Service), raw storage media and volume management, Redundant Array of Inexpensive Disks (RAID) system configuration, remote file systems, and various levels of access (file level vs block level).
On the database side, students learn how to backup and perform recovery on a database in a fast and efficient manner and to tune the database to maximize performance. Backup and recovery topics include: instance and media recovery structures, configuring the database archiving mode, user-managed backup and recovery, automatic backup and recovery, database maintenance, importing and exporting, and loading data.
Prerequisites
CSTP 1201.
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.
- Components and functions of database management systems (DBMSs)
- Model users' data requirements using conceptual modeling techniques
- Transform data models into normalized database designs
- Referential integrity through constraints
- Relational database designs and design views
- SQL statements to modify data and to retrieve data from multiple table
- Transaction management and concurrency control
- Non-procedural queries
- Query optimization techniques
Course schedules
Select your program to see the available course schedules.
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.