Description

This course is designed to give the student an in-depth review of the Oracle DBMS architecture and physical components. The student is also introduced to common DBA skills to set up, maintain, and troubleshoot an Oracle 11g database. Students learn to leverage the 11g architecture to build and configure databases, manage database objects and logical/phsical storage, configuration of Oracle processes and memory, manage user accounts, privileges and roles, and backup recovery strategy. Students also learn database organization including a comprehensive examination of Oracle's data dictionary, space management, table and index segments, undo and rollback segments, logical and physical block sizing, and key dynamic and static parameter files. Progessive hands-on labs utilizing the latest release of Oracle 11g Enterprise Server reinforces key concepts learned. Successful comletion of this course prepares students for the Oracle Database Administration I certification exam and also qualifies as an oracle 10g DBA OCP Hands-On Approved Course. Prerequisite: None. Credits: 3.0