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 Preparation, Installation, and Configuration (SE2 Focus)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation configuration, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common administrative tasks
- Utilising SQL Developer for both administration and development purposes
- Oracle Net Services and listener configuration (covering dedicated/shared basics)
Database Creation and Instance Management
- Creating databases via DBCA and SQL commands
- Startup/shutdown modes, services, and basic PDB awareness (suitable for SE2)
- Initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (including local extent management, temp/undo)
- Segments, extents, blocks, and space monitoring techniques
- Managing growth, relocating datafiles, and OMF considerations
Security and Auditing
- Users, roles, system/object privileges, and least-privilege design principles
- Password policies, profiles, and resource limitations
- Auditing concepts and implementation methods appropriate for SE2
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and data validation
- Media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans (using EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and fundamental wait event analysis
- Proactive monitoring using data dictionaries and dynamic views
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations
- Utilising pre/auto-upgrade utilities and validation procedures
- Post-upgrade tasks, deprecated features, and testing protocols
Summary and Next Steps
Requirements
- Fundamental understanding of SQL
- Proficiency in operating system administration (Linux or Windows)
- Comprehension of 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.
