Elevate your Oracle 19c database skills to expertly manage, tune, and secure robust database environments, perfect for seasoned DBAs.
EnrollMaster creation and management of CDBs (Container Databases) and PDBs (Pluggable Databases).
Implement effective backup, recovery, and database duplication strategies.
Optimize database performance with advanced tuning and monitoring techniques.
Enhance database security and manage RMAN (Recovery Manager) configurations.
This course builds on foundational Oracle 19c DBA skills, guiding participants through advanced database administration concepts. You'll work hands-on with contemporary Oracle database features, tuning performance for efficiency, mastering Multitenant architecture, and securing your data. Whether upgrading existing skills or learning new, in-demand techniques, this course provides the critical insights needed to maintain powerful, dependable database systems.
September 22-26, 2025
10:00 AM - 6:00 PM
Virtual: Online - US/Eastern
$2095
Setup and configure a Container Database (CDB)
Initiate Pluggable Databases (PDBs) from seeds
Examine PDB structure
Oversee PDB service and connectivity
Control CDB/PDB startup, shutdown, and access
Adjust PDB settings and modes
Assess changes to parameter values
Manage CDB/PDB resource usage with Oracle Resource Manager
Execute backup and recovery for CDBs and PDBs
Perform PDB duplication
Clone databases
Manage Oracle database upgrades
Implement data transport solutions
Conduct full and incremental backups
Utilize RMAN for compressing and encrypting data
Create multi-section and duplexed backup sets
Archive backups and manage ASM (Automatic Storage Management) metadata
Apply best recovery practices for various data loss scenarios
Utilize crash, complete, and point-in-time recovery technologies
Configure database for Flashback operations
Conduct flashback operations
Clone databases efficiently
Set up grid infrastructure for standalone servers
Install Oracle Database software
Apply patches to grid infrastructure
Upgrade grid infrastructure effectively
Install and manage databases with DBCA (Database Configuration Assistant)
Explore new features in Oracle 19c
Manage database memory components
Leverage the Automatic Workload Repository (AWR)
Employ the Advisory Framework for performance insights
Track performance metrics and alerts
Define and manage application PDBs
Handle PDB cloning and migration
Utilize local and shared undo modes
Configure security policies and lockdown profiles
Conduct user audits
Utilize RMAN for database restoration and recovery
Perform flashback operations on CDBs and PDBs
Set up RMAN and recovery catalogs
Identify and rectify database corruption issues
Manage recovery with and without RMAN
Deploy data transportation techniques
Analyze RMAN outputs for performance adjustments
Use Oracle Optimizer and SQL Tuning Advisor
Manage optimizer statistics
Your team deserves training as unique as they are.
Let us tailor the course to your needs at no extra cost.
Trusted by Engineers at:
and more...
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier