Get in Touch
 Duration 35 hours

Course Outline

Preparing the Environment, Installation, and Configuration (SE2 Focus)

  • Prerequisites and compatible platforms
  • Installing Oracle Database 19c SE2 and initializing the first database
  • Post-installation settings (listeners, services, EM Express)

Oracle Database Architecture and Foundational 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 logs

Management Tools and Connectivity

  • Fundamentals of Enterprise Manager Express and common tasks
  • Leveraging SQL Developer for administrative and development tasks
  • Oracle Net Services and listener setup (basic dedicated/shared concepts)

Database Creation and Instance Oversight

  • Creating databases via DBCA and SQL
  • Startup/shutdown modes, services, and introductory PDB concepts (suitable for SE2)
  • Initialization parameters and dynamic performance views (V$)

Best Practices for Storage Management

  • Tablespaces and datafiles (local extent management, temp/undo)
  • Segments, extents, blocks, and space usage tracking
  • Managing growth, relocating datafiles, and OMF considerations

Security and Audit Implementation

  • Users, roles, system/object privileges, and least-privilege design
  • Password policies, profiles, and resource constraints
  • Auditing concepts and SE2-appropriate implementation

Backup and Recovery Approaches with RMAN

  • Backup types, retention policies, and recovery targets
  • RMAN configuration, catalogs (where relevant), and verification
  • Media recovery, point-in-time recovery, and failure scenarios

Performance Monitoring and Issue Resolution (SE2-Compliant Methods)

  • Interpreting execution plans (EXPLAIN PLAN, AUTOTRACE)
  • SQL tracing and basic wait event analysis
  • Proactive monitoring using data dictionaries and dynamic views

Migration from 11g to 19c

  • Upgrade paths, prerequisites, and compatibility factors
  • Utilizing pre/auto-upgrade utilities and validation procedures
  • Post-upgrade actions, deprecated features, and testing

Recap and Future Directions

Requirements

  • Fundamental understanding of SQL
  • Proficiency in operating system administration (Linux or Windows)
  • Familiarity with core networking concepts (ports, services, hostnames)

Target Audience

  • System administrators
  • Technical consultants
  • Database administrators

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories