
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 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:
OEMDay 36: Up gradation |
