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 35 hours
Course Outline
Preparing the Environment, Installation, and Configuration (SE2 Emphasis)
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2 and initializing the first database
- Post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Fundamental Infrastructure
- Distinguishing between instance and database concepts
- Components including SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic locations, and alert/trace files
Administrative Tools and Connectivity
- Basics of Enterprise Manager Express and routine tasks
- Utilizing SQL Developer for both administration and development workflows
- Oracle Net Services and listener configuration, covering dedicated and shared basics
Creating Databases and Managing Instances
- Database creation using DBCA and SQL commands
- Startup/shutdown modes, service management, and introductory PDB concepts suitable for SE2
- Initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Handling tablespaces and datafiles, including local extent management, temp/undo segments
- Managing segments, extents, blocks, and monitoring space usage
- Controlling growth, relocating datafiles, and considering OMF
Security Framework and Auditing
- Defining users, roles, system/object privileges, and adhering to least-privilege design principles
- Enforcing password policies, profiles, and resource constraints
- Implementing auditing concepts and practices appropriate for SE2
Developing Backup and Recovery Strategies with RMAN
- Understanding backup types, retention policies, and recovery goals
- Setting up RMAN, managing catalogs where applicable, and validating backups
- Performing media recovery, point-in-time recovery, and handling failure scenarios
Monitoring Performance and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans via EXPLAIN PLAN and AUTOTRACE
- Analyzing SQL traces and understanding wait events
- Proactive monitoring through the data dictionary and dynamic views
Migrating from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Leveraging pre/auto-upgrade utilities and performing validation checks
- Completing post-upgrade tasks, addressing deprecated features, and conducting testing
Summary and Future Directions
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Comprehension of essential networking concepts, including ports, services, and hostnames
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.