"Education is the most powerful weapon which you can use to change the world"

Join Now

Creating CDBs and Regular PDBs

·       Configure and create a CDB

·       Create a new PDB from the CDB seed

·       Explore the structure of PDBs


Manage CDBs and PDBs

·       Manage PDB service names and connections

·       Manage startup, shutdown and availability of CDBs and PDBs

·       Change the different modes and settings of PDBs

·       Evaluate the impact of parameter value changes

·       Performance management in CDBs and PDBs

·       Control CDB and PDB resource usage with the Oracle Resource Manager


Backup and Duplicate

·       Perform Backup and Recover CDBs and PDBs

·       Duplicate an active PDB

·       Duplicate a Database


Upgrading and Transporting CDBs and Regular PDBs

·       Upgrade an Oracle Database

·       Transport Data


Manage Application PDBs

·       Explain the purpose of application root and application seed

·       Define and create application PDBs

·       Install, upgrade and Patch applications

·       Create and administer Application PDBS

·       Clone PDBs and Application containers

·       Plug and unplug operations with PDBs and application containers

·       Comparing Local Undo Mode and Shared Undo Mode


Manage Security in Multitenant databases

·       Manage Security in Multitenant databases

·       Manage PDB lockdown profiles

·       Audit Users in CDBs and PDBs

·       Manage other types of policies in application containers


Recovery and Flashback

·       Restore and Recovering Databases with RMAN

·       Perform CDB and PDB flashback


Backup Strategies and Terminology

·       Perform Full and Incremental Backups and Recoveries

·       Compress and Encrypt RMAN Backups

·       Use a media manager

·       Create multi-section backups of very large files

·       Create duplexed backup sets

·       Create archival backups

·       Backup of recovery files

·       Backup non database files

·       Back up ASM meta data


Restore and Recovery Concepts

·       Employ the best Oracle Database recovery technology for your failure situation

·       Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery


Using Flashback Technologies

·       Configure  your Database  to support Flashback

·       Perform flashback operations


Duplicating a Database

·       Duplicate Databases


Configuring and Using RMAN

·       Configure RMAN and the Database for Recoverability

·       Configureand Using an RMAN recovery catalog


Diagnosing Failures

·       Detect and repair database and database block corruption

·       Diagnosing Database Issues


Performing Recovery

·       Restore and Recovering Databases with RMAN

·       Perform Non RMAN database recovery


Transporting Data

·       Transport Data


RMAN Troubleshooting and Tuning

·       Interpret the RMAN message output

·       Diagnose RMAN performance issues


Install Grid Infrastructure and Oracle Database

·       Install Grid Infrastructure for a Standalone server

·       Install Oracle Database software


Patching Grid Infrastructure and Oracle Database

·       Patch Grid Infrastructure and Oracle Database


Upgrading to Oracle Grid Infrastructure

·       Upgrade Oracle Grid Infrastructure


Oracle Database 18c: New Features

·       Image and RPM based Database Installation


Creating an Oracle Database by using DBCA

·       Create, Delete and Configure Databases using DBCA


Oracle Restart

·       Configure and use Oracle Restart to manage components


Upgrade the Oracle Database

·       Plan for Upgrading an Oracle Database

·       Upgrade an Oracle Database

·       Perform Post-Upgrade tasks


Install Grid Infrastructure for a Standalone server

·       Rapid Home Provisioning


Using General Overall Database Enhancements

·       Install Oracle Database software

·       Create, Delete and Configure Databases using DBCA

·       Creating CDBs and Regular PDBs

·       Use Miscellaneaous 19c New Features


Using Availability Enhancements

·       Use an RMAN recovery catalog

·       Use Flashback Database


Using Diagnosibility Enhancements

·       Use new Diagnoseability Features


Monitoring and Tuning Database Performance

·       Managing Memory Components

·       Understanding The Automatic Workload Repository (AWR)

·       Understanding The Advisory Framework

·       Monitoring Wait Events, Sessions, and Services

·       Managing Metric Thresholds and Alerts

·       Understanding and Using The Performance Tuning Methodology

·       Performing Performance Planning

·       Understanding The Automatic Database Diagnostic Monitor (ADDM)


Tuning SQL Statements

·       Understanding The Oracle Optimizer

·       Using The SQL Tuning Advisor

·       Managing Optimizer Statistics

·       Using The SQL Access Advisor

·       Understanding The SQL Tuning Process