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 (Focused on SE2)
- Review of prerequisites and supported platforms
- Installation of Oracle Database 19c SE2 and creation of the initial database
- Post-installation configuration, covering listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
- Configuration of parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Essentials of Enterprise Manager Express and common administrative tasks
- Utilizing SQL Developer for both administration and development workflows
- Setup of Oracle Net Services and listener configuration, including dedicated/shared basics
Database Creation and Instance Management
- Creating databases via DBCA and SQL commands
- Managing startup/shutdown modes, services, and foundational PDB awareness (suitable for SE2)
- Configuration of initialization parameters and monitoring via dynamic performance views (V$)
Storage Management Best Practices
- Management of tablespaces and datafiles, including local extent management and temp/undo areas
- Understanding segments, extents, blocks, and monitoring space usage
- Strategies for managing growth, moving datafiles, and considerations for OMF
Security and Auditing
- Management of users, roles, system/object privileges, and implementing least-privilege design
- Defining password policies, profiles, and resource limits
- Implementation of auditing concepts appropriate for SE2 environments
Backup and Recovery Strategies with RMAN
- Understanding backup types, retention policies, and recovery objectives
- Configuring RMAN, setting up catalogs (where applicable), and validating backups
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
- Basics of SQL tracing and analyzing wait events
- Implementing proactive monitoring through the data dictionary and dynamic views
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and performing validation steps
- Completing post-upgrade tasks, addressing deprecated features, and conducting testing
Summary and Next Steps
Requirements
- Fundamental proficiency in SQL
- Working knowledge of operating system administration (Linux or Windows)
- Basic 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.
