Course Outline
Environment Setup, Installation, and Configuration (Focused on SE2)
- Prerequisites and supported platforms
- 安装 Oracle Database 19c SE2 并创建初始数据库 (Installing Oracle Database 19c SE2 and creating the initial database)
- 安装后配置 (Post-install configuration including listeners, services, and EM Express)
Oracle Database Architecture and Core Infrastructure
- 实例与数据库概念 (Instance vs. database concepts)
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- 参数文件 (Parameter files), diagnostic destinations, and alert/trace files
Administration Tools and Connectivity
- Enterprise Manager Express basics and common tasks
- Using SQL Developer for administration and development
- Oracle Net Services and listener configuration (dedicated/shared basics)
Database Creation and Instance Management
- Creating databases with DBCA and SQL
- Startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate)
- 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 failure scenarios
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Reading execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and wait event basics
- Proactive monitoring using 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
- Fundamental knowledge of SQL
- 凶旺同事的工作体会 (Familiarity with operating system administration on Linux or Windows)
- A solid understanding of core networking concepts, including ports, services, and hostnames
Target 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
