TTOR20719: Oracle 19c Database Multitenant Architecture

Become an EPIC Affiliate

To view the class schedule you need to become an Affiliate

  • Largest “Guaranteed To Run” public technical training schedules available
  • Easy to become an Affiliate – no charge or fee
Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands-on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

Audience Profile

This course is introductory-level, but technical in nature.

At Course Completion

This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll explore:

· Core concepts of regular PDBs

· Creating a CDB, and then using different methods to create PDBs.

· How to start and shut down a CDB and how to open and close a PDB.

· Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.

· Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.

· How you can move data from a non-CDB environment to a PDB.

· How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.

Outline

1. Multitenant Architecture

· CDB Basics

· CDB and Regular PDBs

· Application PDBs and Application Installation

2. PDB Creation

· PDB Creation

· CDB and PDB Management

· Storage

3. Security

· Security

· Backup and Duplicate

· Recovery and Flashback

· Performance

· Resources Allocation

4. Data Movement

· Data Movement

· Upgrade Methods

· Miscellaneous

Prerequisites

In order to participate in the hands-pon labs you should have a basic understanding of database principles, basic scripting skills (in relation to Oracle) and basic analytics skills.