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
Preparing the Environment, Installation, and Configuration (SE2 Focus)
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2 and initializing the first database
- Post-installation settings (listeners, services, EM Express)
Oracle Database Architecture and Foundational 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 logs
Management Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common tasks
- Leveraging SQL Developer for administrative and development tasks
- Oracle Net Services and listener setup (basic dedicated/shared concepts)
Database Creation and Instance Oversight
- Creating databases via DBCA and SQL
- Startup/shutdown modes, services, and introductory PDB concepts (suitable for SE2)
- Initialization parameters and dynamic performance views (V$)
Best Practices for Storage Management
- Tablespaces and datafiles (local extent management, temp/undo)
- Segments, extents, blocks, and space usage tracking
- Managing growth, relocating datafiles, and OMF considerations
Security and Audit Implementation
- Users, roles, system/object privileges, and least-privilege design
- Password policies, profiles, and resource constraints
- Auditing concepts and SE2-appropriate implementation
Backup and Recovery Approaches with RMAN
- Backup types, retention policies, and recovery targets
- RMAN configuration, catalogs (where relevant), and verification
- Media recovery, point-in-time recovery, and failure scenarios
Performance Monitoring and Issue Resolution (SE2-Compliant Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and basic wait event analysis
- Proactive monitoring using data dictionaries and dynamic views
Migration from 11g to 19c
- Upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and validation procedures
- Post-upgrade actions, deprecated features, and testing
Recap and Future Directions
Requirements
- Fundamental understanding of SQL
- Proficiency in operating system administration (Linux or Windows)
- Familiarity with core networking concepts (ports, services, hostnames)
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.