Oracle Database Multitenant Administration (12c to 19c)

Master Oracle Multitenant Architecture: A Comprehensive Guide

This course equips you with the skills to build and manage Oracle Multitenant Architecture (MTA), a key technology for modern database environments. You'll gain practical experience with releases including Oracle 12.1, 12.2, 18c, and 19c, preparing you for cloud database management.

What You'll Learn:

• Understanding Oracle Multitenant Architecture: Delve into the core concepts of MTA and its benefits.
• Creating Container Databases (CDBs): Learn to create a multitenant CDB and understand its structure.
• Pluggable Databases (PDBs): Master various methods for creating PDBs, including:
  • Creating a PDB from a seed
  • Cloning PDBs (local and remote, including refreshable PDBs)
  • Plugging in an Unplugged PDB
  • Relocating a PDB
  • Creating a PDB from a non-CDB database
  • Creating Proxy PDBs
• Security Management: Secure your multitenant environment by:
  • Creating and managing common and local user accounts and roles
  • Managing PDB lockdown profiles
• Backup & Recovery: Implement robust data protection strategies with:
  • Backup and recovery techniques
  • PITR (Point-in-Time Recovery)
  • Flashback Database
• Resource Management: Utilize the Resource Manager to control resource consumption within your multitenant environment.
• Data Pump Utility: Efficiently manage data with the Data Pump utility in conjunction with PDBs.
• Application Management: Learn to manage applications, application containers, application PDBs, and common objects.
• Oracle 18c & 19c New Features: Explore advanced capabilities including:
  • Managing a CDB fleet
  • Managing a PDB Snapshot Carousel
  • Switching Over a Refreshable Clone PDB
  • PDB Cloning and Relocation using DBCA

Course Highlights:

• Hands-on Practice: Each concept is reinforced with practical exercises, supported by video demonstrations and downloadable guides.
• Comprehensive Coverage: 72 lectures and over 13 hours of video content provide in-depth knowledge.
• Cloud-Ready Skills: Gain the expertise to manage Oracle databases in cloud environments.

Who Should Take This Course?

This course is designed for Oracle Database Administrators looking to embrace the next generation of database technology. Gain the skills to build, manage, and secure Oracle Multitenant Architecture and prepare for the demands of modern database administration.