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, Installing, and Configuring (Focus on SE2)
- Prerequisites and compatible platforms
- Installing Oracle Database 19c SE2 and establishing the initial database
- Post-installation configuration (listeners, services, EM Express)
Oracle Database Architecture and Fundamental Infrastructure
- Distinguishing between instance and database concepts
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Parameter files, diagnostic destinations, and alert/trace files
Administrative Tools and Connectivity
- Essentials of Enterprise Manager Express and common tasks
- Utilizing SQL Developer for administration and development
- Oracle Net Services and listener configuration (basics of dedicated/shared modes)
Database Creation and Instance Oversight
- Creating databases using DBCA and SQL
- Startup/shutdown modes, services, and fundamental PDB awareness (suitable for SE2)
- Initialization parameters and dynamic performance views (V$)
Best Practices in Storage Management
- Tablespaces and datafiles (local extent management, temp/undo)
- Segments, extents, blocks, and space monitoring
- Managing growth, relocating datafiles, and OMF considerations
Security and Auditing Protocols
- Users, roles, system/object privileges, and least-privilege design
- Password policies, profiles, and resource limits
- Auditing concepts and implementations suitable for SE2
Backup and Recovery Strategies using RMAN
- Types of backups, retention policies, and recovery objectives
- Configuring RMAN, catalogs (where applicable), and validation processes
- Media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
- SQL tracing and fundamentals of wait events
- Proactive monitoring using data dictionaries and dynamic views
Migration from 11g to 19c
- Upgrade paths, prerequisites, and compatibility factors
- Employing pre/auto-upgrade utilities and verification steps
- Post-upgrade tasks, deprecated features, and testing procedures
Conclusion and Future Steps
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (Linux or Windows)
- Grasp of core networking concepts (ports, services, hostnames)
Target Audience
- System administrators
- Technical consultants
- Database administrators
Testimonials (1)
good explanation on each points and provide assignment for practices.
