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.
Course Outline
Environment Preparation, Installation, and Configuration (SE2 Focus)
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2 and creating the initial database
- Post-install configuration (listeners, services, 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
- 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
35 Hours
Testimonials (5)
I liked very much the format of the training, hands on, directly in sql developer.
Andreea - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
The exercises were explained very good.
Monica - DB Global Technology
Course - PL/SQL in Oracle 19c
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
