Course Outline
Environment Preparation, Installation, and Configuration (Focus on SE2)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and creating the initial database
- Post-installation configuration (listeners, services, EM Express)
Oracle Database Architecture and Core Infrastructure
- Concepts of Instance vs. database
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Basics of Enterprise Manager Express and common tasks
- Using SQL Developer for administration and development
- Oracle Net Services and listener configuration (basics of dedicated/shared modes)
Database Creation and Instance Management
- Creating databases with DBCA and SQL
- Startup/shutdown modes, services, and basic PDB awareness (appropriate for SE2)
- Initialization parameters and dynamic performance views (V$)
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temp/undo)
- Segments, extents, blocks, and space monitoring
- Managing growth, moving datafiles, and OMF considerations
Security and Auditing
- Users, roles, system/object privileges, and least-privilege design
- Password policies, profiles, and resource limits
- Auditing concepts and implementation appropriate for SE2
Backup and Recovery Strategies with RMAN
- Backup types, retention, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and validation
- Media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Reading execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and basics of wait events
- Proactive monitoring using the data dictionary and dynamic views
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations
- Using pre/auto-upgrade utilities and validation steps
- Post-upgrade tasks, deprecated features, and testing
Summary and Next Steps
Requirements
- Basic knowledge of SQL
- Familiarity with operating system administration (Linux or Windows)
- Understanding of core networking concepts (ports, services, hostnames)
Audience
- System administrators
- Technical consultants
- Database administrators
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
