Databases
Oracle Database Administration
Master Oracle Database 19c administration and earn OCA/OCP readiness.
5 DaysAdvancedOracle DBA Certification readiness (OCA/OCP)
Course Curriculum
Module 1Oracle Architecture
- Instance and database structure
- Memory structures: SGA and PGA
- Process architecture
- Logical and physical storage
Module 2Administration Essentials
- Creating and configuring databases
- Oracle Net Services and listener
- User management and privileges
- Tablespace management
Module 3Backup & Recovery
- RMAN architecture and configuration
- Full, incremental, and archivelog backups
- Flashback technology
- Data Pump export and import
Module 4High Availability
- Oracle Data Guard setup
- Physical and logical standby databases
- Oracle RAC concepts
- Switchover and failover procedures
Module 5Performance Tuning
- AWR and ADDM reports
- ASH for session analysis
- SQL Tuning Advisor
- Index management and statistics
Prerequisites
- SQL and relational database fundamentals
- Linux administration experience
- Basic understanding of database architecture
Who Should Attend
- DBAs migrating from other database platforms
- Oracle developers taking DBA responsibilities
- Candidates preparing for OCA/OCP exams
Get Started
Interested in Oracle Database Administration?
Our training advisors will help you choose the right batch format, dates, and pricing for your team or individual goals.