In this module, we will delve into the Oracle Database Multitenant Architecture, covering both the 12.1 and 12.2 versions. You will explore the architecture’s key components and examine the improvements and new features introduced in the 12.2 version.

In this module, we will guide you through the process of creating Container Databases (CDBs) and Pluggable Databases (PDBs). You will engage in hands-on practice to build a CDB, starting with preparing the environment and then creating and managing CDBs and PDBs in multiple parts.

In this module, we will explore fundamental concepts of Oracle Database Multitenant administration and cover essential tasks such as managing CDBs and PDBs. You will also participate in practical exercises to reinforce your understanding and skills in performing basic administration tasks.

In this module, we will explore the multiple methods available for creating Pluggable Databases (PDBs) within the Oracle Multitenant framework. You’ll gain practical experience by cloning PDBs, plugging in unplugged PDBs, converting non-CDBs, and creating proxy and refreshable PDBs using advanced techniques.

In this module, we will focus on the management of connectivity and services within Oracle Multitenant environments. You will learn about different connectivity options, how to set up and manage services for effective communication, and techniques for troubleshooting common connectivity issues.

In this module, we will delve into the security aspects of Oracle Multitenant databases, focusing on user management and lockdown profiles. You’ll learn how to manage both local and common users and apply PDB lockdown profiles to enhance security. Hands-on exercises will solidify your understanding of these critical security practices.

In this module, we will cover essential strategies for managing backup, recovery, and flashback operations within Oracle Multitenant databases. You will learn how to perform backups, recover from failures, and utilize flashback and point-in-time recovery features. Hands-on practices will reinforce your ability to protect and restore both CDBs and PDBs efficiently.

In this module, we will explore the use of Oracle Resource Manager within a multitenant database environment. You will learn how to configure and manage Resource Manager plans to ensure optimal resource distribution among CDBs and PDBs, enhancing overall database performance and efficiency.

In this module, we will cover a range of miscellaneous topics related to Oracle Multitenant databases, including advanced features and tools. You will engage in practical exercises to apply these topics, such as using the Data Pump utility for data export and import within PDBs, to further refine your multitenant database administration skills.

In this module, we will focus on managing applications and application containers within Oracle Multitenant databases. You will learn how to handle application common objects, perform essential maintenance tasks, and manage applications effectively. Hands-on practices will solidify your skills in administering applications within a multitenant environment.

In this module, we will explore the latest features introduced in Oracle Database Multitenant with versions 18c and 19c. You will learn how to prepare and configure the Oracle Database 19c environment to take full advantage of these enhancements through step-by-step practice sessions.

In this module, we will cover the management of a CDB fleet, focusing on how to oversee multiple Container Databases within a multitenant architecture. You will learn strategies for effective fleet management and engage in hands-on practices to administer and monitor a CDB fleet successfully.

In this module, we will dive into the PDB Snapshot Carousel feature, which allows you to manage and maintain snapshots of Pluggable Databases (PDBs) over time. You’ll learn how to set up and configure a snapshot carousel, manage snapshots effectively, and practice restoring PDBs from these snapshots through a series of practical exercises.

In this module, we will explore the process of switching over a refreshable clone Pluggable Database (PDB) within Oracle Multitenant. You will learn the scenarios where this feature is beneficial, and through practical exercises, you’ll gain the skills to perform a switchover, ensuring continuous availability and data integrity.

In this module, we will cover the process of cloning and relocating Pluggable Databases (PDBs) using the Database Configuration Assistant (DBCA). You will learn how to effectively use DBCA for these tasks, and through practical exercises, you’ll gain the skills to clone and relocate PDBs in different environments, ensuring smooth database operations.