Oracle Database 10g DBA - Part I

Anyone who needs to administer, monitor and support an Oracle 10g database.

Course Content

Installing and Configuring Oracle
Creating and Managing an Oracle database
Administering an Oracle database
Configuring the Oracle Network Environment
Configuring Shared Servers
Creating and Managing Database Storage Structures
Managing Redo Log Files and Control Files
Managing Schema Objects
Managing Users, Profiles, Privileges and Roles
Managing Undo Data and Temporary Segments
Monitoring and Resolving Lock Conflicts
Maintaining Database Security
Monitoring the Performance of the Database
Loading and Unloading Data
Backing up and Recovering the Database
Flashback

Skills

This course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle database. The Oracle database administrator will gain practical experience in setting up, administering and troubleshooting an Oracle10g database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. This course covers the main topics of the Oracle exam #1Z1-042 Oracle Database 10g: Administration I.

Prerequisites

A working knowledge of SQL*Plus is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.

Pre-Requisite Courses:

SQL