Get in Touch
 Duration 35 hours

Course Outline

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

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

Oracle Database Architecture and Fundamental Infrastructure

  • Distinguishing between instance and database concepts
  • Components including SGA, PGA, Shared Pool, Database Buffer Cache, Redo Log, and background processes
  • Parameter files, diagnostic locations, and alert/trace files

Administrative Tools and Connectivity

  • Basics of Enterprise Manager Express and routine tasks
  • Utilizing SQL Developer for both administration and development workflows
  • Oracle Net Services and listener configuration, covering dedicated and shared basics

Creating Databases and Managing Instances

  • Database creation using DBCA and SQL commands
  • Startup/shutdown modes, service management, and introductory PDB concepts suitable for SE2
  • Initialization parameters and dynamic performance views (V$)

Best Practices in Storage Management

  • Handling tablespaces and datafiles, including local extent management, temp/undo segments
  • Managing segments, extents, blocks, and monitoring space usage
  • Controlling growth, relocating datafiles, and considering OMF

Security Framework and Auditing

  • Defining users, roles, system/object privileges, and adhering to least-privilege design principles
  • Enforcing password policies, profiles, and resource constraints
  • Implementing auditing concepts and practices appropriate for SE2

Developing Backup and Recovery Strategies with RMAN

  • Understanding backup types, retention policies, and recovery goals
  • Setting up RMAN, managing catalogs where applicable, and validating backups
  • Performing media recovery, point-in-time recovery, and handling failure scenarios

Monitoring Performance and Troubleshooting (SE2-Appropriate Methods)

  • Interpreting execution plans via EXPLAIN PLAN and AUTOTRACE
  • Analyzing SQL traces and understanding wait events
  • Proactive monitoring through the data dictionary and dynamic views

Migrating from 11g to 19c

  • Evaluating upgrade paths, prerequisites, and compatibility factors
  • Leveraging pre/auto-upgrade utilities and performing validation checks
  • Completing post-upgrade tasks, addressing deprecated features, and conducting testing

Summary and Future Directions

Requirements

  • Fundamental understanding of SQL
  • Experience with operating system administration (Linux or Windows)
  • Comprehension of essential networking concepts, including ports, services, and hostnames

Target Audience

  • System administrators
  • Technical consultants
  • Database administrators

Number of participants


Price per participant (excl. VAT)

Testimonials (1)

Upcoming Courses

Related Categories