Course Outline
Preparing the Environment, Installation, and Configuration (SE2 Focus)
- Review of prerequisites and supported platforms
- Installation of Oracle Database 19c SE2 and creation of the initial database
- Post-installation setup, including 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 Log, and background processes
- Configuration of parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Connectivity
- Fundamentals and common tasks in Enterprise Manager Express
- Utilizing SQL Developer for both administrative and development workflows
- Setting up Oracle Net Services and listener configurations (dedicated/shared basics)
Database Creation and Instance Management
- Creating databases via DBCA and SQL commands
- Managing startup/shutdown modes, services, and basic PDB awareness (as applicable to SE2)
- Configuring initialization parameters and utilizing dynamic performance views (V$)
Best Practices for Storage Management
- Managing tablespaces and datafiles, including local extent management, temp/undo segments
- Monitoring segments, extents, blocks, and space usage
- Handling growth, migrating datafiles, and considering OMF
Security and Auditing
- Designing with least privilege in mind for users, roles, and system/object privileges
- Implementing password policies, profiles, and resource limits
- Introducing auditing concepts and implementation suitable for SE2
RMAN Backup and Recovery Strategies
- Understanding backup types, retention policies, and recovery objectives
- Configuring RMAN, managing catalogs (where applicable), and validating backups
- Executing media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Basics of SQL tracing and wait events
- Implementing proactive monitoring through data dictionary and dynamic views
Migration from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Leveraging pre/auto-upgrade utilities and executing validation steps
- Completing post-upgrade tasks, addressing deprecated features, and testing
Summary and Next Steps
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Basic grasp of core networking concepts, such as ports, services, and hostnames
Target Audience
- System administrators
- Technical consultants
- Database administrators
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 7250 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated