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)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and initializing the database
- Post-installation setup (listeners, services, EM Express)
Oracle Database Architecture and Core Infrastructure
- Distinction 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
Administrative Tools and Connectivity
- Basics of Enterprise Manager Express and common administrative tasks
- Leveraging SQL Developer for administration and development
- Oracle Net Services and listener configuration (dedicated/shared basics)
Database Creation and Instance Management
- Creating databases using DBCA and SQL
- Startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate)
- Initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Tablespaces and datafiles (local extent management, temp/undo)
- Segments, extents, blocks, and space monitoring
- Managing growth, moving datafiles, and OMF considerations
Security and Auditing
- Users, roles, system/object privileges, and least-privilege design
- Password policies, profiles, and resource limits
- Auditing concepts and implementation suitable for SE2
RMAN-Based Backup and Recovery Strategies
- Backup types, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and validation processes
- Media recovery, point-in-time recovery, and failure scenario management
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and understanding wait events
- Proactive monitoring using data dictionary and dynamic views
Migration from 11g to 19c
- Upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and validation steps
- Post-upgrade tasks, deprecated features, and testing procedures
Summary and Next Steps
Requirements
- Foundational understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Knowledge of 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.
