• Understand Oracle Database 19c multitenant architecture.
• Create and manage CDBs and PDBs.
• Work with regular and application PDBs.
• Clone, plug, unplug, relocate, and manage PDBs.
• Configure multitenant database security.
• Perform CDB and PDB backup and recovery.
• Monitor performance and allocate resources across PDBs.
• Move data between non-CDBs, PDBs, and CDBs.
• Apply PDB and CDB upgrade methods.

Module 1: CDB Basics

• Oracle Multitenant Architecture
• Non-CDB architecture
• Benefits of multitenant architecture
• Oracle Multitenant Container Database
• CDB configurations
• Containers
• Terminology
• Data dictionary and dynamic views
• Tools for managing CDBs and PDBs
• Provisioning a pluggable database

Module 2: CDB and Regular PDBs

• CDB architecture
• CDB root and PDB seed
• Regular PDB architecture
• CDB and PDB relationships
• Creating a new CDB
• Creating regular PDBs
• Managing CDB and PDB structures

Module 3: Application PDBs and Application Installation

• Application containers
• Application PDBs
• Application installation
• Application upgrades
• Application containers and PDBs
• Querying data across application PDBs

Module 4: PDB Creation

• Creating PDBs
• Cloning PDBs
• Hot and remote PDB cloning
• Cloning application containers
• Plugging and unplugging application containers
• Converting regular PDBs to application PDBs
• Relocating PDBs
• Proxy PDBs
• Dropping PDBs

Module 5: CDB and PDB Management

• Starting and shutting down a CDB
• Opening and closing PDBs
• Renaming PDBs
• Setting PDB parameter values
• Renaming PDB services
• Managing CDB and PDB states

Module 6: Storage

• Managing permanent tablespaces
• Managing temporary tablespaces
• Managing UNDO tablespaces
• Storage considerations in CDBs and PDBs

Module 7: Security

• Common and local users
• Common and local privileges
• Common and local roles
• Common and local objects
• Application container security
• PDB lockdown profiles
• Auditing operations in PDBs
• PDB keystores
• Encrypted PDBs
• Plugging and unplugging encrypted PDBs

Module 8: Backup and Duplicate

• CDB backup using RMAN
• PDB backup using RMAN
• Backup considerations for multitenant databases
• Duplicating a PDB
• Duplicating an on-premises CDB for cloud deployment

Module 9: Recovery and Flashback

• Recovery of CDBs and PDBs
• RMAN recovery
• Recovery following PDB datafile loss
• PDB point-in-time recovery
• Recovering plugged PDBs using pre-plug-in backups
• Flashback operations
• Restore points
• Flashing back application upgrades

Module 10: Performance

• CDB and PDB performance monitoring
• Performance monitoring at container level
• Automatic Database Diagnostic Monitor (ADDM)
• ADDM recommendations
• SQL execution monitoring at PDB level

Module 11: Resources Allocation

• PDB performance profiles
• Resource allocation between PDBs
• Managing PDB resources
• Session PGA memory management
• Avoiding excessive session PGA memory usage

Module 12: Data Movement

• Moving data between non-CDBs and PDBs
• Full Transportable Export/Import
• Moving data from a 12c non-CDB into a PDB
• Moving data from a PDB into a 19c PDB

Module 13: Upgrade Methods

• Upgrading a regular PDB to an application PDB
• Plugging remote PDBs using XTTS
• Upgrading a CDB
• PDB and CDB upgrade considerations

Module 14: Miscellaneous

• Additional multitenant administration considerations
• Miscellaneous CDB and PDB management topics

Module 15: Consolidated Database Replay Procedures

• Consolidated Database Replay
• Replay considerations for consolidated environments

4 Days

• Explore the CDB and PDB architecture.
• Configure and validate Enterprise Manager credentials.
• Explore CDB and PDBs using Enterprise Manager Cloud Control.
• Use Enterprise Manager Express.
• Create a new CDB.
• Create a new PDB.
• Install an application in an application container.
• Upgrade an application in an application container.
• Query data across application PDBs.
• Clone remote PDBs in hot mode.
• Clone application containers.
• Unplug and plug application containers.
• Convert a regular PDB to an application PDB.
• Relocate PDBs.
• Query across CDBs using proxy PDBs.
• Drop unnecessary PDBs.
• Start and shut down a CDB.
• Open and close PDBs.
• Rename PDBs and PDB services.
• Set parameter values for PDBs.
• Manage permanent and temporary tablespaces.
• Manage UNDO tablespaces.
• Manage common and local users, privileges, and roles.
• Manage common and local objects in application containers.
• Configure PDB lockdown profiles.
• Audit operations in PDBs.
• Manage PDB keystores.
• Plug and unplug encrypted PDBs.
• Perform RMAN whole-CDB backups.
• Perform RMAN PDB backups.
• Duplicate a PDB into an existing CDB.
• Duplicate an on-premises CDB for cloud deployment.
• Recover PDB datafiles using RMAN.
• Perform PDB point-in-time recovery.
• Recover plugged PDBs using pre-plug-in backups.
• Use restore points for Flashback operations.
• Monitor CDB and PDB performance.
• Obtain ADDM performance recommendations.
• Monitor SQL execution at the PDB level.
• Manage PDB performance profiles.
• Allocate resources between PDBs.
• Manage excessive session PGA memory usage.
• Perform full transportable export/import operations.
• Upgrade regular PDBs to application PDBs.
• Plug remote PDBs using XTTS.
• Upgrade a CDB to Oracle Database 19c.

Course Completion Certificate by Network Binary

• Oracle Database Administrators
• Cloud Database Administrators
• Database Architects
• IT professionals managing database consolidation
• Developers and architects designing multitenant applications
• Professionals managing Oracle Database 19c environments

• Basic knowledge of the Linux operating system.
• Familiarity with Oracle Database administration is recommended.
• Experience with Oracle Database environments is beneficial.