Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 35 hours
Course Outline
Environment Setup, Installation, and Configuration (SE2 Emphasis)
- Reviewing prerequisites and identifying supported platforms
- Deploying Oracle Database 19c SE2 and establishing the initial database instance
- Finalizing post-installation settings for listeners, services, and EM Express
Oracle Database Architecture and Foundational Infrastructure
- Distinguishing between instance and database concepts
- Exploring SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Managing parameter files, diagnostic locations, and alert/trace logs
Administration Tools and Connectivity
- Mastering Enterprise Manager Express fundamentals and routine tasks
- Utilizing SQL Developer for both administrative and development purposes
- Configuring Oracle Net Services and listener settings, including dedicated/shared basics
Database Creation and Instance Control
- Building databases using DBCA and SQL commands
- Managing startup/shutdown modes, services, and basic PDB awareness suitable for SE2
- Configuring initialization parameters and interpreting dynamic performance views (V$)
Storage Management Best Practices
- Handling tablespaces and datafiles, including local extent management and temp/undo segments
- Monitoring segments, extents, blocks, and overall space usage
- Controlling growth, relocating datafiles, and evaluating OMF implications
Security Framework and Auditing
- Implementing least-privilege design through users, roles, and system/object privileges
- Enforcing password policies, profiles, and resource limits
- Applying auditing concepts and strategies appropriate for SE2 environments
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives
- Setting up RMAN, managing catalogs where relevant, and validating backups
- Executing media recovery, point-in-time restoration, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Compliant Methods)
- Analyzing execution plans via EXPLAIN PLAN and AUTOTRACE
- Interpreting SQL traces and fundamental wait events
- Conducting proactive monitoring through data dictionaries and dynamic views
Migration Path from 11g to 19c
- Assessing upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and conducting validation checks
- Completing post-upgrade tasks, addressing deprecated features, and performing testing
Recap and Future Directions
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Proficiency in core networking concepts, including ports, services, and hostnames
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
