Course Name

Oracle Database 19c: Multitenant Architecture

  • Code: D99340GC20
  • Duration: 4 Day(s)
  • Date: 14 Oct, 2024
  • Price: R22, 500.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

Architecture Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods.

The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance component.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Administrator
  • Architect
  • Database Administrator

Course Prerequisites

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

Required Prerequisite:

  • Oracle Database 19c: Administration Workshop
  • Oracle Database 19c: Administration Workshop

Course Objectives

Upon completion of this course, students will be able to:

  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Understand regular and application pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and regular and application pluggable databases.
  • Monitor performance and manage resources within a multitenant container database and pluggable databases.
  • Perform backup, recover, and flashback operations on a multitenant container database and regular and application pluggable databases.
  • Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing.
  • Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.

Course Content

  • Module 1: CDB Basics
  • Module 2: CDB and Regular PDBs
  • Module 3: Application PDBs and Application Installation
  • Module 4: PDB Creation
  • Module 5: CDB and PDB Management
  • Module 6: Storage
  • Module 7: Security
  • Module 8: Backup and Duplicate
  • Module 9: Recovery and Flashback
  • Module 10: Performance Monitoring
  • Module 11: Resources Allocation
  • Module 12: Data Movement
  • Module 13: Upgrade methods
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

Architecture Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods.

The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance component.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Administrator
  • Architect
  • Database Administrator

Course Prerequisites

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

Required Prerequisite:

  • Oracle Database 19c: Administration Workshop
  • Oracle Database 19c: Administration Workshop

Course Objectives

Upon completion of this course, students will be able to:

  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Understand regular and application pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and regular and application pluggable databases.
  • Monitor performance and manage resources within a multitenant container database and pluggable databases.
  • Perform backup, recover, and flashback operations on a multitenant container database and regular and application pluggable databases.
  • Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing.
  • Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault.

Course Content

  • Module 1: CDB Basics
  • Module 2: CDB and Regular PDBs
  • Module 3: Application PDBs and Application Installation
  • Module 4: PDB Creation
  • Module 5: CDB and PDB Management
  • Module 6: Storage
  • Module 7: Security
  • Module 8: Backup and Duplicate
  • Module 9: Recovery and Flashback
  • Module 10: Performance Monitoring
  • Module 11: Resources Allocation
  • Module 12: Data Movement
  • Module 13: Upgrade methods

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US