No products in the cart.
Overview
Course Description
This advanced Oracle Database 19c administration course builds on foundational database administration skills and focuses on enterprise-level management tasks. Students learn advanced storage management, multitenant database administration, backup and recovery strategies, performance tuning, security implementation, automation, and high-availability planning.
Prerequisites
Students should have completed Oracle Database Administration Part 1 or possess equivalent experience with:
-Oracle architecture
-Database creation and configuration
-User and privilege management
-Basic tablespace administration
-Oracle networking fundamentals
-SQL fundamentals
Learning Objectives
Upon completion of this course, students will be able to:
-Manage Oracle multitenant environments
-Configure advanced storage structures
-Implement RMAN backup and recovery solutions
-Perform database recovery operations
-Monitor and tune database performance
-Secure Oracle databases using advanced features
-Automate administrative tasks
-Support high availability and disaster recovery initiatives
Day 1: Advanced Storage and Multitenant Administration
Module 1: Oracle Multitenant Architecture Review
CDB and PDB architecture
Resource management in multitenant environments
Administrative considerations
Module 2: Managing Pluggable Databases
Creating PDBs from seed databases
Cloning PDBs
Unplugging and plugging databases
Refreshable PDBs
PDB relocation
Module 3: Advanced Storage Management
Oracle Managed Files
Bigfile tablespaces
Temporary tablespace groups
Undo management
Space management and monitoring
Labs
Create and clone PDBs
Relocate a PDB
Configure advanced tablespace options
Day 2: Backup and Recovery with RMAN
Module 4: Backup Architecture
Recovery objectives
ARCHIVELOG mode
Flash Recovery Area
Backup planning
Module 5: RMAN Administration
RMAN architecture
Full backups
Incremental backups
Image copies
Backup optimization
Module 6: Recovery Catalog Management
Creating a recovery catalog
Registering databases
Catalog maintenance
Labs
Configure RMAN
Create backup schedules
Manage recovery catalog operations
Day 3: Advanced Recovery Techniques
Module 7: Database Recovery Operations
Instance recovery
Crash recovery
Media recovery
Lost control file recovery
Lost redo log recovery
Module 8: Flashback Technologies
Flashback Query
Flashback Table
Flashback Database
Recycle Bin management
Module 9: Point-in-Time Recovery
Database PITR
Tablespace PITR
Object recovery techniques
Labs
Recover lost data files
Perform Flashback operations
Execute point-in-time recovery
Day 4: Performance Monitoring and Tuning
Module 10: Performance Monitoring Framework
Wait events
Performance views
Metrics and alerts
Module 11: Automatic Diagnostic Tools
AWR
ADDM
ASH
SQL Monitoring
Module 12: SQL and Memory Tuning
Identifying inefficient SQL
Optimizer concepts
Memory advisors
Resource Manager
Labs
Analyze AWR reports
Tune SQL statements
Optimize memory settings
Day 5: Security, Automation, and High Availability
Module 13: Advanced Security Administration
Unified Auditing
Privilege analysis
Transparent Data Encryption
Security best practices
Module 14: Automation and Maintenance
Oracle Scheduler
Automated maintenance tasks
Health monitoring
Maintenance windows
Module 15: High Availability and Disaster Recovery Concepts
Oracle Data Guard architecture
Physical and logical standby databases
Fast-Start Failover concepts
Business continuity planning
Capstone Administration Workshop
Create and manage a PDB
Configure secure access
Implement RMAN backups
Recover from simulated failures
Analyze performance bottlenecks
Automate routine maintenance
Labs
Configure auditing
Schedule maintenance jobs
Implement backup and recovery scenarios
Analyze performance issues
FAQ
What if I have to reschedule my class due to conflict?
Ten (10) business days’ notice is required to reschedule a class with no additional fees. Notify TOPTALENT LEARNING as soon as possible at 469-721-6100 or by written notification to info@toptalentlearning.com to avoid rescheduling penalties.
How do I enroll for this class?
Please contact our team at 469-721-6100; we will gladly guide you through the online purchasing process.
What happens once I purchase a class?
You will receive a receipt and an enrollment confirmation sent to the email you submitted at purchase. Your enrollment email will have instructions on how to access the class. Any additional questions our team is here to support you. Please call us at 469-721-6100.
What is your late policy?
If a student is 15 minutes late, they risk losing their seat to a standby student. If a student is 30 minutes late or more, they will need to reschedule. A no-show fee will apply. Retakes are enrolled on a stand-by basis. The student must supply previously issued courseware. Additional fees may apply.
What happens when I finish my class?
You will receive a ‘Certificate of Completion’ once you complete the class. If you purchased an exam voucher for the class, a team member from TOPTALENT LEARNING will reach out to discuss your readiness for the voucher and make arrangements to send it.