We are happy to advise you!
+49 40 253346-10     Contact
> > > D103130

Oracle Database 18c: Managing Multitenant Architecture (D103130)

 

Course Overview

This course covers all aspects of the multitenant architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a CDB and its regular and application PDBs, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged PDBs in CDBs using various methods.

In addition, you learn how to ensure the security within the containers of the CDB. You create common and local users, grant common and local privileges and roles, and administer database security to meet your business requirements by using encryption, Database Vault and auditing.

This course includes CDB and PDBs backup, duplicate, recovery and flashback procedures.

You learn how to monitor the performance and manage resources within a CDB and its PDBs, and within each PDB.

It introduces the data movement capabilities between non-CDBs and PDBs, and between PDBs.

Finally, it is also covers the procedures of upgrading an Oracle Database 12.2 CDB to an Oracle Database 18c CDB or an Oracle Database 12.2 PDB to an Oracle Database 18c PDB.

Who should attend

  • Administrator
  • Architect
  • Database Administrator

Prerequisites

Suggested Prerequisite
  • Basic knowledge of Linux operating system
  • Working knowledge of SQL and use of PL/SQL packages
Required Prerequisite

Course Objectives

  • Manage PDB snapshots
  • Encrypt data in PDBs and isolate PDB keystore
  • Monitor performance in CDBs and PDBs
  • Audit users in CDB and PDBs
  • Protect data with Database Vault policies in CDB and PDBs
  • Manage a CDB fleet
  • Manage resource allocation between PDBs and within a PDB
  • Use Data Pump operations from a non-CDB or CDB into a PDB
  • Upgrade 12c CDBs or PDBs to 18c
  • Configure and create a CDB
  • Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
  • Startup and shutdown CDBs and PDBs
  • Manage tablespaces in CDB and PDBs
  • Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
  • Manage PDB lockdown profiles
  • Backup, duplicate, recover and flashback CDB and PDBs

Course Content

  • CDB Basics
  • CDB and Regular PDBs
  • Application PDBs and Application Installation
  • PDB Creation
  • CDB and PDB Management
  • Storage
  • Security
  • Backup and Duplicate
  • Recovery and Flashback
  • Performance Monitoring
  • Resources Allocation
  • Data Movement
  • Upgrade methods
  • Miscellaneous
Classroom Training

Duration 4 days

incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware

Courseware language: English

 
Click on town name to book Schedule
Germany
11/05/2020 - 14/05/2020 Frankfurt
17/08/2020 - 20/08/2020 Düsseldorf
30/11/2020 - 03/12/2020 Munich
Switzerland
23/03/2020 - 26/03/2020 Zurich
13/07/2020 - 16/07/2020 Zurich
26/10/2020 - 29/10/2020 Zurich
Austria
17/02/2020 - 20/02/2020 Vienna (iTLS)
22/06/2020 - 25/06/2020 Vienna (iTLS)
21/09/2020 - 24/09/2020 Vienna (iTLS)
 
...