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 to Core Concepts
- Comprehensive overview of Oracle Database architecture
- Distinguishing between a database instance and a database
- Memory structures and process architectures (SGA, PGA, and background processes)
- Management of parameter files, control files, redo logs, alert logs, and trace files
- General introduction to Oracle Multitenant technology (CDB and PDB, and their scope within SE2)
Environment Setup and Installation
- Reviewing prerequisites and supported platform requirements
- Step-by-step installation of Oracle Database 19c SE2
- Initial database creation using DBCA
- Configuring post-installation elements: listeners, services, and Enterprise Manager Express
Administrative Tools and Connectivity
- Establishing connections to Oracle Database instances
- Basic commands and administration tasks in SQL*Plus
- Leveraging Oracle SQL Developer for development and administration
- Utilizing Oracle Enterprise Manager Express for monitoring and routine tasks
- Configuration of Net Services and listener parameters
Instance and Database Governance
- Understanding various startup and shutdown modes
- Creating databases via DBCA and SQL scripts
- Managing initialization parameters and dynamic performance views (V$)
- Oversight of alert logs, trace files, and the Automatic Diagnostic Repository
- Exploring the data dictionary
Connectivity Protocols and Naming Strategies
- Setting up network connections
- Implementing naming methods: Easy Connect, Local Naming, and Directory Naming
- Managing database services
- Configuring listener agents (both dynamic and static registration)
Multitenant Architecture (CDB and PDB) – SE2 Focus
- Core concepts of CDBs and PDBs
- Creating PDBs using PDB$SEED, OMF, and PDB_FILE_NAME_CONVERT parameters
- Managing PDBs, including modes, parameters, and host/port settings
- Procedures for removing PDBs
- Configuring shared servers (SGA, PGA, and shared server modes)
Storage Management
- Handling tablespaces and datafiles
- Managing temporary and undo tablespaces
- Understanding segments, extents, blocks, and space management strategies
- Managing file growth, Oracle Managed Files (OMF), and datafile relocation
Security Frameworks and Auditing
- Defining users, roles, and privileges (adhering to the principle of least privilege)
- Establishing profiles, password policies, and resource limitations
- Overview of auditing concepts within Oracle SE2
- Implementing audits for critical operations
Backup and Recovery Strategies (RMAN)
- Developing backup strategies: types, retention policies, and recovery targets
- Configuring RMAN and managing catalogs
- Addressing recovery scenarios: media failure, point-in-time recovery, and common errors
- Validating backup integrity
Performance Monitoring and Optimization
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Diagnosing wait states and common events
- Proactive monitoring through data dictionary and dynamic views
- Applying tuning techniques specific to SE2
Migrating from Oracle 11g to 19c
- Identifying upgrade paths and meeting prerequisites
- Utilizing pre-upgrade and auto-upgrade tools
- Performing validation steps and resolving compatibility issues
- Executing post-upgrade tasks and addressing deprecated features
- Conducting post-migration testing
Course Conclusion
- Comprehensive summary of key topics
- Recommendations for best practices
Recap and Future Steps
Requirements
- A solid grasp of relational database fundamentals
- Proficiency in writing SQL queries
- Foundational knowledge of operating systems, such as Windows or Linux
Intended Audience
- Database administrators
- System administrators
- IT specialists tasked with overseeing Oracle database environments
Testimonials (1)
good explanation on each points and provide assignment for practices.