Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Overview to the multitenant architecture
- Benefits of multitenant architecture
- Components: container database (CDB) and pluggable databases (PDBs)
Multitenant Architecture Components
- Understanding container database (CDB)
- Understanding pluggable databases (PDBs)
- Differences between non-CDB and CDB architectures
Installing and Configuring Multitenant Architecture
- Installation of Oracle Database 19c with multitenant option
- Configuration of a multitenant environment
- Creating a CDB
Creating and Managing PDBs
- Creating PDBs using SQL, DBCA, and PDB seed
- Managing PDBs: start, stop, and clone
- PDB administration
Security in Multitenant Environment
- User security in CDB and PDBs
- Managing roles and privileges
- Implementing transparent data encryption (TDE) in PDBs
Backup and Recovery of Multitenant Databases
- Backup strategies for CDB and PDBs
- Recovery scenarios in a multitenant environment
- Using RMAN with a multitenant architecture
Performance Tuning in Multitenant Architecture
- Resource management in a multitenant environment
- Tuning PDBs for optimal performance
- Monitoring performance using Enterprise Manager
Managing Data in PDBs
- Moving data between PDBs
- Importing and exporting data in PDBs
- Using Oracle Data Pump in a multitenant architecture
Patching and Upgrading in a Multitenant Environment
- Patching strategies for CDBs and PDBs
- Upgrading PDBs: best practices
- Downtime minimization techniques
High Availability and Disaster Recovery
- Configuring Data Guard with multitenant databases
- Failover and switchover scenarios in a multitenant environment
- Implementing Oracle RAC with a multitenant architecture
Troubleshooting Multitenant Databases
- Common issues in multitenant architecture
- Diagnostic tools and techniques
- Troubleshooting techniques for PDBs
Best Practices for Multitenant Architecture
- Security best practices
- Backup and recovery best practices
- Performance tuning best practices
Summary and Next Steps
Requirements
- Basic understanding of Oracle database administration
- Familiarity with SQL and PL/SQL
Audience
- Database administrators
- IT professionals
21 Hours
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
