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)
- Reviewing prerequisites and identifying supported platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Completing post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Understanding SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Managing parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Exploring Enterprise Manager Express fundamentals and common administrative tasks
- Leveraging SQL Developer for both administration and development workflows
- Configuring Oracle Net Services and listeners, including dedicated and shared basics
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands
- Managing startup/shutdown modes, services, and gaining basic PDB awareness suitable for SE2
- Working with initialization parameters and dynamic performance views (V$)
Best Practices for Storage Management
- Managing tablespaces and datafiles, including local extent management, temp, and undo
- Monitoring segments, extents, blocks, and space usage
- Handling growth, moving datafiles, and considering OMF
Security and Auditing
- Managing users, roles, system/object privileges, and applying least-privilege design principles
- Implementing password policies, profiles, and resource limits
- Applying auditing concepts and implementations appropriate for SE2
Backup and Recovery Strategies using RMAN
- Understanding backup types, retention policies, and recovery objectives
- Configuring RMAN, managing catalogs (where applicable), and performing validation
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Approaches)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
- Analyzing SQL tracing and basic wait events
- Conducting proactive monitoring via the data dictionary and dynamic views
Migration from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility considerations
- Utilizing pre- and auto-upgrade utilities along with necessary validation steps
- Completing post-upgrade tasks, addressing deprecated features, and conducting testing
Summary and Future Directions
Requirements
- Fundamental understanding of SQL
- Familiarity with operating system administration on either Linux or Windows
- A solid 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.
