| 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 | |