1

 

Oracle Database Managing Multitenant Architecture

Oracle Database 19c Managing Multitenant Architecture

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explore the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

This course will help you to learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for business applications.


Learning Objectives:

After completing this Oracle Certification Course, you will be able to:

  • 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 the backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resource 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.

Course Content: 

Module 1: Introduction to Oracle Database

  • Overview of the Oracle Database
  • Overview of the Oracle Cloud
  • Relational Database Concepts
  • Database Administration Tasks

Module 2: Oracle Database Architecture

  • Overview of the Oracle Database Architecture
  • The Oracle Database Instance
  • Oracle Database Memory Structures
  • Process Architecture and Structures
  • Server and Client Processes
  • Oracle Database Storage Architecture
  • Connect to the Oracle Database Instance

Module 3;Multitenant Architecture

  • CDB Basics
  • CDB and Regular PDBs
  • Application PDBs and Application Installation

Module 4: PDB Creation

  • PDB Creation
  • CDB and PDB Management
  • Storage

 Module 5: Security

  • Security
  • Backup and Duplicate
  • Recovery and Flashback
  • Performance
  • Resources Allocation

Module 6: Data Movement

  • Data Movement
  • Upgrade Methods
  • Miscellaneous

Course Prerequisites
  • Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
  • Knowledge of non-CDB configuration and management
  • Working knowledge of SQL and use of PL/SQL packages
  • Oracle Database 19c: Administration Workshop
  • Oracle Database 19c: Backup and Recovery
  • Basic knowledge of Linux operating system

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now