Course Outline
Introduction and Core Fundamentals
- Overview of Oracle Database architecture
- Distinguishing between a database instance and a database
- Memory and process architecture (SGA, PGA, background processes)
- Parameter files, control files, redo logs, alert logs, and trace files
- General overview of Oracle Multitenant (CDB and PDB, scope within SE2)
Environment Preparation and Installation
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2
- Creating the initial database using DBCA
- Post-installation configuration: listeners, services, and Enterprise Manager Express
Administration Tools and Connectivity
- Connecting to an Oracle Database instance
- SQL*Plus: basic commands and administrative tasks
- Utilizing Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and common tasks
- Configuring Net Services and listeners
Instance and Database Management
- Startup and shutdown modes
- Creating databases with DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- The data dictionary
Connectivity and Naming Methods
- Establishing network connections
- Naming methods: Easy Connect, Local Naming, and Directory Naming
- Managing database services
- Configuring listener agents (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Scope
- Concepts of CDB and PDB
- Creating PDBs (using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- Managing PDBs (modes, parameters, host/port configuration)
- Removing PDBs
- Configuring shared servers (SGA, PGA, shared server mode)
Storage Administration
- Tablespaces and datafiles
- Temporary and undo tablespaces
- Segments, extents, blocks, and space management
- File growth, OMF (Oracle Managed Files), and moving datafiles
Security and Auditing
- Users, roles, and privileges (adhering to the principle of least privilege)
- Profiles, password policies, and resource limits
- Auditing concepts within Oracle SE2
- Auditing critical operations
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives
- RMAN configuration and catalogs
- Recovery scenarios: media failure, point-in-time, and common issues
- Validating backups
Monitoring and Performance Optimization
- Using execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring using the data dictionary and dynamic views
- Tuning methods specific to SE2
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre-auto-upgrade tools
- Validation steps and resolving incompatibilities
- Post-upgrade tasks and deprecated features
- Post-migration testing
Course Closure
- General summary
- Recommendations for best practices
Summary and Next Steps
Requirements
- A solid understanding of relational database concepts
- Practical experience with SQL
- Basic familiarity with operating systems such as Windows or Linux
Audience
- Database administrators
- System administrators
- IT professionals tasked with managing Oracle environments
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