| Sr. |
Topic |
Hours |
Days |
| Part I: Basic Database Administration |
| 1. |
Getting Started with Database Administration |
1 |
3 |
| 2. |
Creating and Configuring an Oracle Database |
2 |
| 3. |
Starting Up and Shutting Down |
0.5 |
| 4 |
Configuring Automatic Restart of an Oracle Database |
0.5 |
| 5 |
Managing Processes |
2 |
| 6 |
Managing Memory |
| 7 |
Managing Users and Securing the Database |
| 8 |
Monitoring the Database |
| 9 |
Managing Diagnostic Data |
| Part II Oracle Database Structure and Storage |
| 10 |
Managing Control Files |
2 |
3.5 |
| 11 |
Managing the Redo Log |
| 12 |
Managing Archived Redo Log Files |
| 13 |
Managing Tablespaces |
2 |
| 14 |
Managing Data Files and Temp Files |
| 15 |
Transporting Data |
1 |
| 16 |
Managing Undo |
1 |
| 17 |
Using Oracle Managed Files |
1 |
| Part III Schema Objects |
| 18 |
Managing Schema Objects |
5 |
2.5 |
| 19 |
Managing Space for Schema Objects |
| 20 |
Managing Tables |
| 21 |
Managing Indexes |
| 22 |
Managing Clusters |
| 23 |
Managing Hash Clusters |
| 24 |
Managing Views, Sequences, and Synonyms |
| 25 |
Repairing Corrupted Data |
| Part IV Database Resource Management and Task Scheduling |
| 26 |
Managing Automated Database Maintenance Tasks |
4 |
2 |
| 27 |
Managing Resources with Oracle Database Resource Manager |
| 28 |
Oracle Scheduler Concepts |
| 29 |
Scheduling Jobs with Oracle Scheduler |
| 30 |
Administering Oracle Scheduler |
| Part V Managing a Multitenant Environment |
| 31 |
Overview of Managing a Multitenant Environment |
4 |
2 |
| 32 |
Creating and Configuring a CDB |
| 33 |
Creating and Removing PDBs with SQL*Plus |
| 34 |
Creating and Removing PDBs with Cloud Control |
| 35 |
Administering a CDB with SQL*Plus |
| 36 |
Administering CDBs and PDBs with Cloud Control |
| 37 |
Administering PDBs with SQL*Plus |
| 38 |
Viewing Information About CDBs and PDBs with SQL*Plus |
| 39 |
Using Oracle Resource Manager for PDBs with SQL*Plus |
| 40 |
Using Oracle Resource Manager for PDBs with Cloud Control |
| 41 |
Using Oracle Scheduler with a CDB |
| Part VI Managing Oracle Net Service |
| 42 |
Configuring Listener |
2 |
1 |
| 43 |
Configuring Naming methods |
| 44 |
Testing and verifying database connection |
| Part VII Backup and recovery |
| 45 |
Types of failures |
8 |
6 |
| 46 |
Backup and Recovery tools, RMAN |
| 47 |
Physical backup of the database |
| |
– Archive log mode and No archivelog mode |
| |
– Hot backup and cold backup |
| 48 |
Database Recovery scenarios |
| |
– Full database recovery |
| |
– Incomplete database recovery |
| |
– Recovering from the loss of a control file |
| |
– Recovering from the loss of database files |
| 49 |
Logical backup |
|
| |
– Export and Import |
2 |
| 50 |
Doubt clearing – concluding the session |
2 |
| |
Total |
40 |
20 |
