|
ORACLE DBA Administrator Program:
This job oriented training program will help give you a jump start into the highly paid and challenging career opportunities in Oracle DBA administration.
Prerequisites:
Basic database concepts
ORACLE DBA Training Curriculum:
The following topics will be covered with hands on training and course materials will be provided.
|
|
|
PART I - Database Administration
|
| |
 |
Oracle database architecture
|
|
Installing Oracle software & creating an Oracle database |
| |
|
Starting and shutdown Oracle database |
|
Managing control files, redo Log, archive log |
|
Managing and storage structure, schema objects, database security |
| |
|
Managing table spaces, data files and undo space |
|
Managing table, indexes, views, partitions etc. |
|
Security policies, managing users, privileges and roles, auditing |
| |
|
|
|
PART II – Performance Tuning |
| |
|
Writing and tuning SQL |
|
Overview of SQL processing |
|
Gathering optimizer statistics |
|
Goals for tuning |
|
SQL-related performance tools |
|
Using explain plan |
|
SQL trace and TKPROF |
|
Database tuning |
|
Creating database and tables for better performance |
|
Memory configuration – tuning |
|
Buffer cache, shared pool, PGA tuning |
|
Tuning UNDO and TEMP segments |
|
Using Statspack |
|
| |
|
| |
PART III – Database Backups and Recovery, Oracle Utilities |
| |
|
Using Oracle Utilities such as SQLLDR, export, import. |
|
Using Log Miner. |
|
Cold, hot and Rman backups and recovery |
|
Oracle Enterprise Manager |
|
Using Enterprise Manager to manage databases, etc. |
|
Agent, jobs, events setup. |
|
| |
|
|
|
