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 setting up the initial database.
- Post-installation configuration, including listeners, services, and EM Express.
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts.
- Understanding SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes.
- Managing parameter files, diagnostic destinations, and alert or trace files.
Administration Tools and Connectivity
- Basics of Enterprise Manager Express and common administrative tasks.
- Leveraging SQL Developer for both administration and development.
- Configuring Oracle Net Services and listeners (covering dedicated and shared basics).
Database Creation and Instance Management
- Creating databases using DBCA and SQL.
- Startup and 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, and undo).
- Segments, extents, blocks, and space monitoring.
- Managing growth, moving datafiles, and considerations for OMF.
Security and Auditing
- Users, roles, system and object privileges, and least-privilege design principles.
- Password policies, profiles, and resource limits.
- Auditing concepts and implementations appropriate for SE2.
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives.
- Configuring RMAN, catalogs (where applicable), and validation processes.
- 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.
- SQL tracing and understanding basic wait events.
- Proactive monitoring through data dictionaries and dynamic views.
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations.
- Using pre-auto upgrade utilities and validation steps.
- Post-upgrade tasks, deprecated features, and testing procedures.
Summary and Next Steps
Requirements
- Foundational knowledge of SQL.
- Proficiency with operating system administration (Linux or Windows).
- A solid understanding 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.
