Course Description

Course Overview

The Oracle 19c DBA II course is a comprehensive training program designed for database administrators who already have a foundational knowledge of Oracle Database administration. This course builds upon the concepts covered in the Oracle 19c DBA I course and focuses on advanced administration tasks, performance tuning, backup and recovery strategies, and high availability solutions. Participants will learn how to optimize database performance, implement effective backup and recovery strategies, and configure high availability solutions using Oracle technologies.

Prerequisites

To derive maximum benefit from this course, participants should have a solid understanding of Oracle Database administration concepts and have completed the Oracle 19c DBA I course or possess equivalent knowledge. Familiarity with SQL, basic database security, and backup and recovery concepts is required.

Methodology

The course utilizes a combination of theoretical instruction, demonstrations, and hands-on labs. Participants will receive detailed explanations of advanced administration concepts and techniques, followed by practical demonstrations of their implementation. They will also have the opportunity to apply their learning in hands-on labs, gaining practical experience in advanced database administration tasks. The course is delivered through instructor-led sessions, allowing participants to interact, ask questions, and engage in discussions.

Course Outline

• Advanced Oracle Database Architecture
• Understanding Oracle memory structures
• Managing memory and performance
• Monitoring and troubleshooting database performance
• Configuring database for optimal performance
• Advanced Backup and Recovery Strategies
• Advanced RMAN backup and recovery techniques
• Implementing backup optimization and performance tuning
• Configuring RMAN for centralized backup and recovery
• Implementing backup and recovery for specific database components (e.g., tablespaces, data files)
• Advanced Database Security
• Implementing fine-grained access control
• Configuring database auditing and compliance
• Database security best practices
• Implementing database encryption and transparent data encryption
• Managing High Availability
• Introduction to Oracle Data Guard
• Configuring Oracle Data Guard for high availability and disaster recovery
• Performing switchover and failover operations
• Monitoring and troubleshooting Data Guard configurations
• Oracle Grid Infrastructure and Real Application Clusters (RAC)
• Understanding Oracle Grid Infrastructure architecture
• Installing and configuring Oracle RAC
• Managing RAC instances and services
• Monitoring and troubleshooting RAC environments
• Oracle Automatic Storage Management (ASM)
• Introduction to ASM and its benefits
• Configuring and managing ASM disk groups
• Implementing ASM mirroring and striping
• Monitoring and troubleshooting ASM
• Performance Tuning and Optimization
• Identifying and resolving performance bottlenecks
• SQL tuning and optimization techniques
• Indexing strategies and best practices
• Optimizer statistics and histograms
• Advanced Database Administration Tools and Techniques
• Using Oracle Enterprise Manager for advanced administration
• Implementing and managing database patches and upgrades
• Configuring and managing database backups using Oracle Secure Backup
• Implementing and managing Oracle Flashback technologies

Course Outcome

Upon completion of the course, participants will:

• Have a comprehensive understanding of advanced Oracle Database administration concepts and tasks.
• Be proficient in performance tuning and optimization techniques.
• Understand advanced backup and recovery strategies using Oracle Recovery Manager (RMAN).
• Possess the skills to configure and manage high availability solutions, such as Oracle Data Guard and Real Application Clusters (RAC).
• Be familiar with advanced database security measures and best practices.
• Possess knowledge of Oracle Grid Infrastructure, Automatic Storage Management (ASM), and Oracle Flashback technologies.
• Have the ability to use advanced administration tools, such as Oracle Enterprise Manager, for monitoring and management.

Course Labs

The course includes hands-on labs that provide participants with practical experience in advanced Oracle Database administration tasks. The labs cover various scenarios, allowing participants to practice performance tuning, backup and recovery strategies, configuring high availability solutions, implementing advanced security measures, and using advanced administration tools. The labs are designed to reinforce the concepts learned during the theoretical instruction and help participants build confidence in their advanced database administration skills.