Get in Touch
 Duration 35 hours

Course Outline

Environment Preparation, Installation, and Configuration (SE2 Focus)

  • Prerequisites and supported platform requirements
  • Installation of Oracle Database 19c SE2 and initial database creation
  • Post-installation configuration, including listeners, services, and EM Express

Oracle Database Architecture and Core Infrastructure

  • Distinguishing between instance and database concepts
  • Overview of SGA, PGA, Shared Pool, Database Buffer Cache, Redo Logs, and background processes
  • Parameter files, diagnostic destinations, and alert/trace file management

Administration Tools and Connectivity

  • Essentials of Enterprise Manager Express and common administrative tasks
  • Utilizing SQL Developer for both administration and development activities
  • Configuration of Oracle Net Services and listeners (dedicated and shared basics)

Database Creation and Instance Management

  • Creating databases using DBCA and SQL commands
  • Startup/shutdown modes, service management, and basic PDB awareness (SE2-appropriate)
  • Management of initialization parameters and dynamic performance views (V$)

Storage Management Best Practices

  • Tablespaces and datafiles (local extent management, temp/undo)
  • Understanding segments, extents, blocks, and space monitoring
  • Managing growth, relocating datafiles, and OMF considerations

Security and Auditing

  • Managing users, roles, system/object privileges, and least-privilege design
  • Implementing password policies, profiles, and resource limits
  • Auditing concepts and implementation suitable for SE2

Backup and Recovery Strategies with RMAN

  • Backup types, retention policies, and recovery objectives
  • RMAN configuration, catalogs (where applicable), and validation procedures
  • Media recovery, point-in-time recovery, and failure scenario handling

Performance Monitoring and Troubleshooting (SE2-Safe Methods)

  • Interpreting execution plans using EXPLAIN PLAN and AUTOTRACE
  • Basics of SQL tracing and wait event analysis
  • Proactive monitoring utilizing data dictionary and dynamic views

Migrating from 11g to 19c

  • Upgrade paths, prerequisites, and compatibility considerations
  • Utilization of pre/auto-upgrade utilities and validation steps
  • Post-upgrade tasks, identification of deprecated features, and testing

Summary and Next Steps

Requirements

  • Foundational knowledge of SQL
  • Experience with operating system administration (Linux or Windows)
  • Understanding of core networking concepts, including ports, services, and hostnames

Audience

  • System administrators
  • Technical consultants
  • Database administrators

Testimonials (1)

Upcoming Courses

Related Categories