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.
Course Outline
Environment Preparation, Installation, and Configuration (SE2 Focus)
- Prerequisites and supported platforms for government
- Installing Oracle Database 19c SE2 and creating the initial database
- Post-install configuration (listeners, services, EM Express) for government systems
Oracle Database Architecture and Core Infrastructure
- Instance vs. database concepts
- SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes for government operations
- Parameter files, diagnostic destinations, and alert/trace files for government use
Administration Tools and Connectivity
- Enterprise Manager Express basics and common tasks for government administrators
- Using SQL Developer for administration and development in government environments
- Oracle Net Services and listener configuration (dedicated/shared basics) for government networks
Database Creation and Instance Management
- Creating databases with DBCA and SQL for government applications
- Startup/shutdown modes, services, and basic PDB awareness (SE2-appropriate) for government systems
- Initialization parameters and dynamic performance views (V$) for government databases
Storage Management Best Practices
- Tablespaces and datafiles (local extent management, temp/undo) for government storage solutions
- Segments, extents, blocks, and space monitoring for government databases
- Managing growth, moving datafiles, and OMF considerations for government systems
Security and Auditing
- Users, roles, system/object privileges, and least-privilege design for government security
- Password policies, profiles, and resource limits for government users
- Auditing concepts and implementation appropriate for SE2 in government environments
Backup and Recovery Strategies with RMAN
- Backup types, retention, and recovery objectives for government data
- Configuring RMAN, catalogs (where applicable), and validation for government systems
- Media recovery, point-in-time recovery, and failure scenarios for government databases
Performance Monitoring and Troubleshooting (SE2-Safe Methods)
- Reading execution plans (EXPLAIN PLAN, AUTOTRACE) for government applications
- SQL tracing and wait event basics for government databases
- Proactive monitoring using data dictionary and dynamic views for government systems
Migrating from 11g to 19c
- Upgrade paths, prerequisites, and compatibility considerations for government migrations
- Using pre/auto-upgrade utilities and validation steps for government databases
- Post-upgrade tasks, deprecated features, and testing for government systems
Summary and Next Steps
Requirements
- Fundamental knowledge of SQL
- Experience with operating system administration (Linux or Windows)
- Proficiency in core networking concepts (ports, services, hostnames)
Audience for Government
- System administrators
- Technical consultants
- Database administrators
35 Hours
