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 Focus)
- Reviewing prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Configuring post-installation settings, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Examining the SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Mastering Enterprise Manager Express basics and common tasks
- Utilizing SQL Developer for both administrative and development activities
- Configuring Oracle Net Services and listeners (covering dedicated and shared basics)
Database Creation and Instance Management
- Building databases using DBCA and SQL
- Managing startup/shutdown modes, services, and basic PDB awareness (relevant to SE2)
- Adjusting initialization parameters and utilizing dynamic performance views (V$)
Storage Management Best Practices
- Handling tablespaces and datafiles, including local extent management, temp/undo, and OMF considerations
- Monitoring segments, extents, blocks, and space usage
- Managing growth and datafile relocation
Security and Auditing
- Designing least-privilege access through users, roles, and system/object privileges
- Implementing password policies, profiles, and resource limits
- Applying auditing concepts and implementations suitable for SE2
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and performing validation
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
- Analyzing SQL tracing and basic wait events
- Conducting proactive monitoring via the data dictionary and dynamic views
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility considerations
- Employing pre/auto-upgrade utilities and executing validation steps
- Completing post-upgrade tasks, addressing deprecated features, and performing testing
Summary and Next Steps
Requirements
- Fundamental understanding of SQL
- Proficiency in operating system administration (either Linux or Windows)
- Knowledge of core networking concepts, including ports, services, and hostnames
Intended Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
