Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Oracle Database 19c: Multitenant Architecture

via LinkedIn Learning

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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
  • Refreshable PDB Clones
Conclusion
  • Next steps

Taught by

Bob Bryla

Reviews

4.7 rating at LinkedIn Learning based on 186 ratings

Start your review of Oracle Database 19c: Multitenant Architecture

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.