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)
- Review of prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and initializing the first database
- Post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Exploring 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
- Fundamentals of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for administration and development workflows
- Configuring Oracle Net Services and listeners (dedicated/shared basics)
Database Creation and Instance Management
- Creating databases using DBCA and SQL commands
- Understanding startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate)
- Working with initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Managing tablespaces and datafiles (local extent management, temp/undo)
- Monitoring segments, extents, blocks, and space usage
- Handling growth, relocating datafiles, and considering OMF
Security and Auditing
- Implementing least-privilege design through users, roles, and system/object privileges
- Enforcing password policies, profiles, and resource limits
- Applying auditing concepts and practices suitable for SE2
Backup and Recovery Strategies with RMAN
- Defining backup types, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and validation processes
- Performing media recovery, point-in-time recovery, and addressing failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Analyzing execution plans via EXPLAIN PLAN and AUTOTRACE
- Using SQL tracing and understanding wait events
- Conducting proactive monitoring through the data dictionary and dynamic views
Migrating from 11g to 19c
- Assessing upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and validation procedures
- Executing post-upgrade tasks, addressing deprecated features, and testing
Summary and Next Steps
Requirements
- Fundamental understanding of SQL
- Proficiency in operating system administration (Linux or Windows)
- Knowledge 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.
