Oracle Database 19c: Multitenant Architecture

Go to class
Write Review

Free Online Course: Oracle Database 19c: Multitenant Architecture provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Oracle Database 19c: Multitenant Architecture is taught by Bob Bryla.

Overview
  • This course teaches database administrators to create and effectively utilize resources within multitenant databases.

Syllabus
  • Introduction

    • Multitenant
    • What you should know
    1. Multitenant Architecture
    • Components of a multitenant environment
    • CDB root
    • PDB seed
    • Connecting to CDBs and PDBs
    • Multitenant data dictionary views
    • Challenge: Connect to the CDB and PDB
    • Solution: Connect to the CDB and PDB
    2. Create and Clone PDBs and Users
    • Creating a container database
    • Creating a PDB from the seed database
    • Copying a PDB
    • Dropping a PDB
    • Creating and managing local and common users
    • Moving a PDB
    • Upgrading a PDB to a new database version
    • Challenge: Move a PDB to a new container with SQL Developer
    • Solution: Move a PDB to a new container with SQL Developer
    3. Application PDBs
    • Creating application containers and application PDBs
    • Installing an application in an application PDB
    • Challenge: Upgrade an application PDB
    • Solution: Upgrade an application PDB
    4. Multitenant Backup and Recovery
    • Back up a CDB and PDB with RMAN
    • Recover a CDB or one of the PDBs
    • Challenge: Recover a PDB tablespace
    • Solution: Recover a PDB tablespace
    Conclusion
    • Next steps