Oracle 11g Database Administration

    

Summary:
This course provides students with the skills needed to administer and maintain an Oracle 11g database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery. The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also examined to provide access to additional information about a database and instance.This course includes additional topics not presented in the Oracle 11g Database Administration Lite course. Some topics presented in both courses will be covered in more detail in this course.

Duration:
5 Days/Lecture & Lab

Audience:
This course is designed for Database Administrators responsible for the administration of an existing Oracle 11g database. Programmers and Analysts seeking a greater understanding of the Oracle DBMS will also find this class helpful.

Topics:

• Overview of Oracle Architecture
• Manageability Features
• Tablespaces & Data Files
• User Administration
• Tables
• Indexes
• Clusters
• Documenting Objects
• Synonyms
• Sequences
• Views
• Managing UNDO Data
• Utilities
• Resumable Space Allocation
• Online Data Evolution
• Overview of Oracle's Client-Server Architecture

Prerequisites:
Students should have taken the Oracle 11g SQL Fundamentals course. Oracle 11g PL/SQL Programming not required, but would be helpful.

Last Update: May 18, 2013