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 (Focus on SE2)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation configuration, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Concepts distinguishing instances from databases
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Fundamentals of Enterprise Manager Express and common operational tasks
- Using SQL Developer for administrative and development purposes
- Oracle Net Services and listener configuration, covering dedicated and shared basics
Database Creation and Instance Management
- Creating databases using DBCA and SQL
- Startup/shutdown modes, services, and basic awareness of PDBs relevant to SE2
- Initialisation parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles, including local extent management, temp/undo spaces
- Segments, extents, blocks, and space monitoring techniques
- Managing growth, relocating datafiles, and considerations for OMF
Security and Auditing
- Users, roles, system/object privileges, and designing for least privilege
- Password policies, profiles, and resource limits
- Auditing concepts and implementations suitable for SE2
Backup and Recovery Strategies using RMAN
- Backup types, retention policies, and recovery objectives
- Configuring RMAN, using 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 via EXPLAIN PLAN and AUTOTRACE
- SQL tracing and understanding wait events
- Proactive monitoring using data dictionaries and dynamic views
Migration from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations
- Leveraging pre/auto-upgrade utilities and validation steps
- Post-upgrade tasks, deprecated features, and testing protocols
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL
- Familiarity with operating system administration (either Linux or Windows)
- A clear 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.
