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 platform requirements
- Installation of Oracle Database 19c SE2 and initial database creation
- Post-installation configuration, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Parameter files, diagnostic destinations, and alert/trace file management
Administration Tools and Connectivity
- Essentials of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for both administration and development activities
- Configuration of Oracle Net Services and listeners (dedicated and shared basics)
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands
- Startup/shutdown modes, service management, and basic PDB awareness (SE2-appropriate)
- Management of initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temp/undo)
- Understanding segments, extents, blocks, and space monitoring
- Managing growth, relocating datafiles, and OMF considerations
Security and Auditing
- Managing users, roles, system/object privileges, and least-privilege design
- Implementing password policies, profiles, and resource limits
- Auditing concepts and implementation suitable for SE2
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives
- RMAN configuration, catalogs (where applicable), and validation procedures
- Media recovery, point-in-time recovery, and failure scenario handling
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
- Basics of SQL tracing and wait event analysis
- Proactive monitoring utilizing data dictionary and dynamic views
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations
- Utilization of pre/auto-upgrade utilities and validation steps
- Post-upgrade tasks, identification of deprecated features, and testing
Summary and Next Steps
Requirements
- Foundational knowledge of SQL
- Experience with operating system administration (Linux or Windows)
- Understanding of core networking concepts, including ports, services, and hostnames
Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.