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 compatible platforms
- 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
- Distinction between instance and database concepts
- Components such as SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Connectivity
- Essential tasks in Enterprise Manager Express
- Utilizing SQL Developer for both administration and development workflows
- Oracle Net Services and listener configuration, including dedicated/shared basics
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands
- Startup/shutdown modes, services, and basic PDB awareness suitable for SE2
- Initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and space usage
- Managing growth, relocating datafiles, and OMF considerations
Security and Auditing
- Managing users, roles, system/object privileges, and least-privilege design
- Configuring password policies, profiles, and resource limits
- Auditing concepts and implementation suitable for SE2 environments
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives
- RMAN configuration, 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 (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and understanding wait events
- Proactive monitoring using data dictionary and dynamic views
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility checks
- Using pre/auto-upgrade utilities and performing validation steps
- Post-upgrade tasks, addressing deprecated features, and testing
Summary and Recommended Next Steps
Requirements
- Fundamental knowledge of SQL
- Proficiency in operating system administration (Linux or Windows)
- Grasp 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.