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.
Course Outline
Environment Preparation, Installation, and Configuration (SE2 Focus)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and creating the initial database
- Post-installation configuration (listeners, services, EM Express)
Oracle Database Architecture and Core Infrastructure
- Concepts of instance versus database
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic destinations, and alert and trace files
Administration Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common tasks
- Using SQL Developer for administration and development
- Oracle Net Services and listener configuration (dedicated and shared basics)
Database Creation and Instance Management
- Creating databases using DBCA and SQL
- Startup and shutdown modes, services, and basic PDB awareness (SE2-appropriate)
- Initialisation parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temporary and undo tablespaces)
- Segments, extents, blocks, and space monitoring
- Managing growth, moving datafiles, and OMF considerations
Security and Auditing
- Users, roles, system and object privileges, and least-privilege design principles
- Password policies, profiles, and resource limits
- Auditing concepts and implementation tailored for SE2
Backup and Recovery Strategies with RMAN
- Backup types, retention policies, and recovery objectives
- Configuring RMAN, recovery catalogs (where applicable), and validation procedures
- 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 wait event fundamentals
- Proactive monitoring using the data dictionary and dynamic views
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations
- Utilising pre-upgrade and auto-upgrade utilities along with validation steps
- Post-upgrade tasks, deprecated features, and testing procedures
Summary and Next Steps
Requirements
- Basic knowledge of SQL
- Familiarity with operating system administration (Linux or Windows)
- Understanding of core networking concepts (ports, services, hostnames)
Target Audience
- System administrators
- Technical consultants
- Database administrators
35 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
