Course Outline
Introduction
- Overview of multi-tenant architecture
- Advantages of adopting a multi-tenant design
- Key components: Container Database (CDB) and Pluggable Databases (PDBs)
Components of Multi-Tenant Architecture
- In-depth look at the Container Database (CDB)
- In-depth look at Pluggable Databases (PDBs)
- Distinctions between non-CDB and CDB architectures
Installation and Configuration of Multi-Tenant Architecture
- Deploying Oracle Database 19c with the multi-tenant option
- Setting up a multi-tenant environment
- Creating a Container Database (CDB)
Creation and Management of PDBs
- Creating PDBs via SQL, DBCA, and PDB seeds
- Managing PDBs: starting, stopping, and cloning
- Administrative tasks for PDBs
Security in a Multi-Tenant Environment
- User security within CDBs and PDBs
- Role and privilege management
- Deploying Transparent Data Encryption (TDE) in PDBs
Backup and Recovery for Multi-Tenant Databases
- Backup strategies for CDBs and PDBs
- Recovery scenarios within a multi-tenant setup
- Utilizing RMAN in a multi-tenant architecture
Performance Tuning in Multi-Tenant Architecture
- Resource allocation and management in multi-tenant environments
- Optimizing PDB performance
- Performance monitoring via Enterprise Manager
Data Management in PDBs
- Transferring data between PDBs
- Importing and exporting data within PDBs
- Leveraging Oracle Data Pump in multi-tenant architectures
Patching and Upgrades in Multi-Tenant Environments
- Patching strategies for CDBs and PDBs
- Best practices for upgrading PDBs
- Techniques to minimize downtime
High Availability and Disaster Recovery
- Configuring Data Guard with multi-tenant databases
- Failover and switchover scenarios in multi-tenant contexts
- Implementing Oracle RAC with multi-tenant architectures
Troubleshooting Multi-Tenant Databases
- Common challenges in multi-tenant setups
- Diagnostic tools and methodologies
- Specific troubleshooting techniques for PDBs
Best Practices for Multi-Tenant Architecture
- Security best practices
- Backup and recovery best practices
- Performance tuning best practices
Summary and Future Steps
Requirements
- Foundational knowledge of Oracle database administration
- Proficiency with SQL and PL/SQL
Target Audience
- Database Administrators
- IT Specialists
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4350 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated