ITS 229AD - Database Administration II

Institution:

Kapiolani Community College

Subject:

Description:

3 hours lecture per week Prerequisite(s): ITS 149AD or consent of the instructor or BE department chair. ITS 229AD advances students' knowledge of database administration. In this class, students will learn how to configure a database server for multilingual applications. They will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. Students will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. They will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. Upon successful completion of ITS 229AD, the student should be able to: Use RMAN to create and manage backup sets and image copies. Recover the database to a previous point in time. Use Oracle Secure Backup to backup and recover a database. Use Oracle's Flashback technology to recover your database. Detect block corruptions and take appropriate measures to correct them. Use the various Database advisors and views to monitor and improve database performance. Control database resource usage with the Resource Manager. Simplify management tasks by using the Scheduler. Review database log files for diagnostic purposes. Customize language-dependent behavior for the database and individual sessions. Administer a VLDB. Implement a secure database. Transport data across platforms.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

kapiolani.hawaii.edu/page/home

Phone Number:

(808) 734-9000

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.