CSTP 2101 — Database Management & Storage
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.