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.
Duration 49 hours
Course Outline
Introduction and Core Concepts
- Overview of Oracle Database architecture
- Distinguishing between a database instance and a database
- Memory and process structures (SGA, PGA, background processes)
- Parameter files, control files, redo logs, alert logs, and trace files
- General introduction to Oracle Multitenant (CDB and PDB, specifically within the SE2 context)
Environment Setup and Installation
- Prerequisites and supported platforms
- Installing Oracle Database 19c SE2
- Initialising the first database (using DBCA)
- Post-installation setup: configuring listeners, services, and Enterprise Manager Express
Administration Tools and Connectivity
- Connecting to an Oracle Database instance
- SQL*Plus: fundamental commands and administrative tasks
- Utilising Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and routine operations
- Configuring Net Services and listeners
Instance and Database Management
- Startup and shutdown modes
- Creating databases using DBCA and SQL
- Initialisation 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 listener agents (dynamic and static)
Multitenant Architecture (CDB and PDB) – SE2 Specifics
- Understanding CDB and PDB concepts
- Creating PDBs (utilising PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- Managing PDBs (modes, parameters, and host/port configuration)
- Removing PDBs
- Configuring shared servers (SGA, PGA, and 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 datafile migration
Security and Auditing
- Users, roles, and privileges (adhering to the principle of least privilege)
- Profiles, password policies, and resource limits
- Auditing concepts specific to Oracle SE2
- Auditing 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 failure handling
- Validating backups
Monitoring and Performance Optimisation
- Analysing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and common events
- Proactive monitoring via the data dictionary and dynamic views
- Tuning methods applicable to SE2
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre- and auto-upgrade tools
- Validation procedures and resolving incompatibilities
- Post-upgrade tasks and handling deprecated features
- Post-migration testing
Course Conclusion
- General summary
- Recommendations for best practices
Recap and Future Directions
Requirements
- A solid grasp of relational database principles
- Proficiency in SQL
- Fundamental knowledge of operating systems such as Windows or Linux
Target Audience
- Database administrators
- System administrators
- IT professionals tasked with overseeing Oracle environments
Testimonials (1)
good explanation on each points and provide assignment for practices.
