Courses
Course : ORACLE
Sub Course : ORACLE10gDBA
Content :

Day 1:

Introduction to Oracle 10g

Day 2:

Architecture – I

Day 3:

Architecture – II

Day 4:

Architecture – III

Day 5:

Oracle 10g installation on Linux

Day 6:

Oracle Database creation

Day 7:

Table space management

Day 8:

User management

Day 9:

Undo and Storage

Day 10:

Networking, db Linux, materialized views, OMF, SP file and P file
Control, Archive, Online redo log files management and renaming of Database

Day 12:

Logical backups (exp/IMP)

Day 13:

Logical backup (data pump)

Day 14:

Physical backup (cold)

Day 15:

Physical backup (hot)

Day 16:

Backup and recovery scenario

Day 17:

Introduction to R man backups

Day 18:

R man configuration backups

Day 19:

R man recoveries and reporting

Day 20:

Database cloning (hot & cold)

Day 21:

R man cloning and R man point in time recovery

Day 22:

Introduction to high availability

Day 23:

Configuring physical standby database and different protection modes

Day 24:

Configuring logical standby

Day 25:

Flashback technologies, Transportable Table Space

Day 26:

Introduction to Performance Tuning

Day 27:

Application tuning (sal tuning)

Day 28:

Statistics gathering (AWF, ADDM, ASMM etc)

Day 29:

Memory tuning – I

Day 30:

Memory tuning – II

Day 31:

Indexes and partitions

Day 32:

Fragmentation, RDW Migration and Row chaining

Day 33:

Database auditing, Fragmentation

Day 34:

Log miner, sal loader

Day 35:

OEM
Day 36:
Up gradation

Sub Courses
ORACLE10g
ORACLE10gDBA
APPSDBA
ORACLE Techno Functional
OBIEE