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.
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
International Student Fees:$500
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Free Exam Practice Test
- How to Pass Oracle 1z0-518 Oracle EBS R12.1 Receivables Essentials Exam Dumps
- How to Pass Oracle 1z0-870 MySQL 5 Certified Associate
- How to Pass Oracle 1z0-908 MySQL 8.0 Database Administration
- How to Pass Oracle Data Integrator 12c Essentials
Related Courses
Oracle Database Administration – OCP/OCA
Oracle Database 12c: Installation and Administration
Oracle Database 19c Administration (DBA Complete Course)