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 initializing the database
- Post-installation configuration (listeners, services, 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
- Essentials of Enterprise Manager Express and routine tasks
- Utilizing SQL Developer for administrative and development workflows
- Oracle Net Services and listener configuration (dedicated/shared basics)
Database Creation and Instance Management
- Creating databases via DBCA and SQL commands
- Startup/shutdown modes, services, and basic PDB awareness (appropriate for SE2)
- Initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temp/undo)
- Segments, extents, blocks, and space monitoring
- 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 limits
- Auditing concepts and implementation suitable 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)
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and understanding wait events
- Proactive monitoring using the data dictionary 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
Summary and Next Steps
Requirements
- Fundamental 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
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 8000 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
good explanation on each points and provide assignment for practices.
