Database Backup and Recovery with Lab

This course explores database backup and recovery strategies and tactics using both Oracle and SQL Server database systems. The course will include weekly lab work that will give students an opportunity to gain experience with Oracle and SQL Server databases. Topics include preparing backup, recovery and disaster plans, as well as performing complete and incomplete database recoveries using the Oracle Export/Import utility. Students also work with a SQL Server database, utilizing the SQL Server Management Studio. Students will be assigned a Linux Virtual environment that will be used for all Oracle administration, and they will install a SQL Server database locally that will be used for all SQL Server administration. Prerequisite: ICT 4400.