Course Outline
Introduction and Core Concepts
- Overview of Oracle Database architecture.
- Distinguishing between the database instance and the database.
- Memory and process architecture (SGA, PGA, background processes).
- Parameter files, control files, redo logs, alert logs, and trace files.
- General introduction to Oracle Multitenant (CDB and PDB, scope within SE2).
Environment Setup 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.
Administrative Tools and Connectivity
- Connecting to an Oracle Database instance.
- SQL*Plus: essential commands and administration.
- Utilising Oracle SQL Developer.
- Oracle Enterprise Manager Express: monitoring and routine tasks.
- Configuring Net Services and listeners.
Instance and Database Management
- Startup and shutdown modes.
- Creating databases using 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 Strategies
- Establishing network connections.
- Naming methods: Easy Connect, Local Naming, and Directory Naming.
- Managing database services.
- Configuring the listener agent (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 (principle of least privilege).
- Profiles, password policies, and resource limits.
- Auditing concepts within Oracle SE2.
- Auditing of critical operations.
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery objectives.
- RMAN configuration and catalogs.
- Recovery scenarios: media, point-in-time, and common failures.
- Validating backups.
Monitoring and Performance Optimisation
- Using execution plans (EXPLAIN PLAN, AUTOTRACE).
- Diagnosing waits and common events.
- Proactive monitoring via data dictionary and dynamic views.
- Tuning methods specific to SE2.
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites.
- Pre- and auto-upgrade tools.
- Validation steps and resolving incompatibilities.
- Post-upgrade tasks and deprecated features.
- Post-migration testing.
Course Conclusion
- General summary.
- Recommendations for best practices.
Summary and Next Steps
Requirements
- A solid understanding of relational database concepts.
- Proficiency in SQL.
- Basic familiarity with operating systems such as Windows or Linux.
Target 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 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
good explanation on each points and provide assignment for practices.
