Back
|
|
|
Oracle Database 11g DBA - Part I
Delegates: |
|
Anyone who needs to administer, monitor and support an Oracle 11g database. |
Objectives: |
|
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 Oracle11g 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.
|
Topics Covered: |
- Oracle Database Architecture
- Installing and Configuring Oracle
- Creating and Managing an Oracle Instance and Database
- Administering an Oracle Instance and Database
- Configuring the Oracle Network Environment
- 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
- Managing Data and Concurrency
- Maintaining Database Security
- Database Maintenance
- Managing Performance
- Moving Data with SQL*Loader and Data Pump
- Backing up and Recovering the Database
- Support Workbench, Metalink, Service Requests and Patches
|
Requirements:
|
|
A working knowledge of SQL is required. This can be gained by attendance on the pre-requisite course. Knowledge of PL/SQL would be beneficial.
|
|
|
|
