Oracle 19C Database Multitenant Architecture

Description

Oracle 19c Database Multitenant Architecture is a hands-on, three-day course designed for Database Administrators seeking to master Oracle's cutting-edge Multitenant Architecture. Throughout the course you’ll deep dive into the essentials of Container Databases (CDBs) and Pluggable Databases (PDBs), covering topics such as CDB and PDB management, security, backup, recovery, and performance tuning. By learning these core concepts, you’ll  will enhance their ability to streamline database operations, boost data security, and optimize performance, directly benefiting your daily tasks and your organization's efficiency.

The interactive course combines 50% hands-on lab work with engaging discussions and group activities. Guided by an industry expert, you’ll engage in real-world scenarios through labs that simulate real-world scenarios, allowing you to practice tasks like configuring Multitenant environments, managing security within CDBs and PDBs, and executing backup and recovery procedures. These labs are designed to reflect the challenges you'll face in your role, preparing you for a range of projects, from routine database management to complex migrations and upgrades.  Upon completion, you’ll emerge with a comprehensive grasp of Oracle's Multitenant Architecture, equipped with advanced skills in CDB and PDB management. Youll have the skills needed to boost database performance, ramp up security, and smoothly navigate complex data challenges.

Learning Objectives

Working in a hands-on learning environment led by our expert facilitator, you’ll explore:

  • CDB Management Skills: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
  • PDB Operations Proficiency: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
  • Database Security Measures: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
  • Backup and Recovery Techniques: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
  • Performance Optimization: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
  • Data Movement and Storage Management: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.

Course Agenda

Lesson 1: CDB Basics

Lesson 2: CDB and Regular PDBs

Lesson 3: Application PDBs and Application Installation

Lesson 4: PDB Creation

Lesson 5: CDB and PDB Management

Lesson 6: Storage

Lesson 7: Security

Lesson 8: Backup and Duplicate

Lesson 9: Recovery and Flashback

Lesson 10: Performance

Lesson 11: Resources Allocation

Lesson 12: Data Movement

Lesson 13: Upgrade Methods

Lesson 14: Time Permitting / Extras

  • Using Xstreams with a CDB and PDB
  • Creating a Standby of a CDB
  • Instantiating a PDB on a Standby
  • Scheduling Operations in a PDB
  • Jobs Coordinator and Resources
  • Mining Statements of a PDB Using LogMiner

Similar courses

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. IT IS NOT A SQL QUERYING COURSE (SQL Querying syntax will not be discussed). The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

More Information

This class assumes a student is comfortable working in Oracle 19c. Lab activities will be conducted against and class content will be written against an Oracle 19c environment.

More Information

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. IT IS NOT A SQL QUERYING COURSE (SQL Querying syntax will not be discussed). The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

More Information