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
Setting Up the Environment, Installation, and Configuration (SE2 Specific)
- Review of prerequisites and supported platforms
- Deployment of Oracle Database 19c SE2 and initialization of the first database
- Post-installation adjustments, including listeners, services, and EM Express setup
Oracle Database Architecture and Fundamental Infrastructure
- Distinguishing between instance and database concepts
- Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
- Management of parameter files, diagnostic locations, and alert/trace files
Management Tools and Connectivity
- Core functionalities of Enterprise Manager Express and typical administrative tasks
- Utilizing SQL Developer for both administration and development workflows
- Configuration of Oracle Net Services and listeners (covering dedicated/shared basics)
Creating Databases and Managing Instances
- Establishing databases using DBCA and SQL commands
- Startup/shutdown procedures, services, and basic PDB awareness relevant to SE2
- Initialization parameters and usage of dynamic performance views (V$)
Best Practices in Storage Management
- Tablespaces and datafiles, including local extent management and temp/undo usage
- Understanding segments, extents, blocks, and space monitoring techniques
- Managing growth, relocating datafiles, and considering OMF
Security and Auditing Protocols
- Managing users, roles, system/object privileges, and designing for least privilege
- Implementing password policies, profiles, and resource constraints
- Auditing principles and implementation suitable for SE2 environments
Backup and Recovery Strategies Using RMAN
- Backup classifications, retention policies, and recovery goals
- RMAN configuration, catalogs (where relevant), and validation processes
- Media recovery, point-in-time recovery, and handling failure scenarios
Performance Monitoring and Troubleshooting (SE2-Appropriate Methods)
- Interpreting execution plans via EXPLAIN PLAN and AUTOTRACE
- SQL tracing and an introduction to wait events
- Proactive monitoring using the data dictionary and dynamic views
Transitioning from 11g to 19c
- Upgrade pathways, prerequisites, and compatibility factors
- Utilization of pre/auto-upgrade utilities and validation procedures
- Post-upgrade activities, handling deprecated features, and testing
Recap and Future Directions
Requirements
- Fundamental understanding of SQL
- Experience with operating system administration (either Linux or Windows)
- Grasp 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.
