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
Environment Setup, Installation, and Configuration (SE2 Focus)
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation setup, including listeners, services, and EM Express
Oracle Database Architecture and Core Infrastructure
- Distinguishing between instance and database concepts
- Key components such as SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Configuration of parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Connectivity
- Fundamentals of Enterprise Manager Express and typical administrative tasks
- Utilizing SQL Developer for both administration and development workflows
- Oracle Net Services and listener configuration (covering dedicated/shared basics)
Database Creation and Instance Administration
- Creating databases using DBCA and SQL commands
- Managing startup/shutdown modes, services, and basic PDB awareness (suitable for SE2)
- Working with initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Managing tablespaces and datafiles (including local extent management, temp/undo)
- Monitoring segments, extents, blocks, and overall space usage
- Handling growth, relocating datafiles, and considering OMF implementations
Security and Auditing Protocols
- Defining users, roles, system/object privileges, and adhering to least-privilege design principles
- Establishing password policies, profiles, and resource limitations
- Implementing auditing concepts and practices appropriate for SE2
RMAN-Based Backup and Recovery Strategies
- Understanding backup types, retention policies, and recovery objectives
- Setting up RMAN, configuring catalogs (where applicable), and performing validation
- Executing media recovery, point-in-time recovery, and addressing failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Analyzing execution plans using EXPLAIN PLAN and AUTOTRACE
- Applying SQL tracing and understanding wait events
- Conducting proactive monitoring via the data dictionary and dynamic views
Migration Path from 11g to 19c
- Evaluating upgrade paths, prerequisites, and compatibility factors
- Utilizing pre/auto-upgrade utilities and performing necessary validation steps
- Completing post-upgrade tasks, managing deprecated features, and conducting testing
Course Summary and Future Steps
Requirements
- Foundational understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Grasping of fundamental 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.
