Course Details

About the Course

Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.

You will also learn to use various Oracle Features like Backup Recovery, Database Utilities, Resource Manager, Scheduler and Database Vault in Multitenant Architecture.

Versions Covered: 19c, 18c, 12c

Key Highlights:

• High-Quality Learning Content
• Downloadable Course Material
• Extensive curriculum
• In-depth explanation
• Hands-on demonstrations
• Lecture discussions
• Doubt clarifications
• Learn at your own pace
• Learn at your own comfort
• Course Completion Certificate
• 12 months unlimited access

Course Curriculum

Module-1: Overview of Multitenant Architecture

• Introduction to Multitenant Architecture
• Benefits of Multitenant Architecture
• Overview of Multitenant Architecture
• Overview of Containers in a CDB
• Overview of Commonality in a CDB
• Overview of Applications in an Application Container
• Overview of Services in a CDB
• Overview of Tablespaces and Database Files in a CDB
• Overview of Backup and Recovery in a CDB
• Overview of Flashback PDB in a CDB
• Overview of Resource Manager in a CDB

Module-2: Creating and Removing PDBs and Application Containers

• Overview of PDB Creation
• Creating a PDB from scratch
• Cloning a PDB or Non-CDB
• Relocating a PDB
• Plugging in an Unplugged PDB
• Creating a PDB as a Proxy PDB
• Unplugging a PDB from a CDB
• Dropping a PDB
• Creating and Removing Application Containers and Seeds

Module3- Administering Multitenant Environment

• Modifying CDBs and PDBs
• Cross Container Operations
• Running Oracle Supplied SQL scripts in CDB
• Startup and Shutdown of CDB and PDBs
• Managing Tablespaces in CDB
• Administering CDB Fleet
• Restricting Container Data View
• PDB Lockdown Profiles
• Administering Application Containers and Applications

Module4- Using Oracle Features in Multitenant Environment

• Backup and Recovery in Multitenant Environment
• Flashback Database in Multitenant Environment
• Using Data Pump
• Using Resource Manager
• Patching in Multitenant Environment

Module5- Upgrading Container Database

• Overview of Upgrading CDB
• Performing the Upgrade