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 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, specific to SE2)
Environment Setup and Installation
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2
- Creating the initial database using DBCA
- Post-installation setup: listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Connecting to an Oracle Database instance
- SQL*Plus: essential commands and administrative tasks
- Utilizing Oracle SQL Developer
- Oracle Enterprise Manager Express: monitoring and routine tasks
- Configuring Net Services and listeners
Instance and Database Management
- Startup and shutdown procedures
- Creating databases via DBCA and SQL
- Initialization parameters and dynamic performance views (V$)
- Managing alert logs, trace files, and the Automatic Diagnostic Repository
- Understanding 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 Context
- Concepts of CDB and PDB
- Creating PDBs (using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters)
- Managing PDBs (modes, parameters, host/port settings)
- Removing PDBs
- Shared server configuration (SGA, PGA, and shared server mode)
Storage Management
- Tablespaces and datafiles
- Temporary and undo tablespaces
- Segments, extents, blocks, and space allocation
- File growth, OMF (Oracle Managed Files), and datafile relocation
Security and Auditing
- Users, roles, and privileges (applying the principle of least privilege)
- Profiles, password policies, and resource constraints
- Auditing concepts within Oracle SE2
- Auditing critical operations
Backup and Recovery (RMAN)
- Backup strategies: types, retention policies, and recovery goals
- Configuring RMAN and managing catalogs
- Recovery scenarios: media, point-in-time, and common failures
- Validating backups
Monitoring and Performance Tuning
- Analyzing execution plans (EXPLAIN PLAN, AUTOTRACE)
- Diagnosing waits and typical events
- Proactive monitoring using data dictionaries and dynamic views
- Tuning techniques specific to SE2
Migration from Oracle 11g to 19c
- Upgrade paths and prerequisites
- Pre-upgrade and auto-upgrade tools
- Validation steps and resolving incompatibilities
- Post-upgrade tasks and handling deprecated features
- Post-migration testing
Course Conclusion
- Comprehensive summary
- Best practice recommendations
Summary and Future Steps
Requirements
- A solid grasp of relational database concepts
- Proficiency in SQL
- Basic knowledge of operating systems like 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.
