Oracle Database 19c: Administration Workshop

Skip to Scheduled Dates

Course Overview

Oracle powers the backbone of global business—94% of the Fortune 100 rely on Oracle Database to keep their most critical systems running. And with Oracle 19c as the long-term support release, professionals who know how to manage it are in high demand.

The Oracle Database 19c: Administration Workshop is a dynamic 5-day, hands-on training that gives you real-world skills to confidently run Oracle 19c in any environment. You'll install and configure databases, manage users and security, perform reliable backup and recovery with RMAN, move data between systems, monitor performance, and gain experience with Oracle Database Cloud Service (DBCS) on Oracle Cloud Infrastructure (OCI).

Who Should Attend

Developer Implementer Systems Administrator

Course Objectives

    This course gives you the foundational skills and hands-on practice needed to administer Oracle Database 19c with confidence across traditional and cloud environments. You’ll be able to:

    • Understand Oracle Database and DBCS architecture
    • Install, configure, and deploy Oracle 19c environments
    • Manage users, security settings, and auditing policies
    • Perform backup and recovery operations using RMAN
    • Monitor performance and move data across systems efficiently

Course Outline

Database Architecture

  • Explore memory, process structures, logical storage, schema objects, and instance architecture

Cloud Database Services

  • Overview of Oracle Cloud Infrastructure (OCI)
  • Provision and manage DBCS instances

Installation and Configuration

  • Install software using OUI
  • Configure initialization parameters
  • Create and configure databases

Security and Auditing

  • Manage users, roles, and privileges
  • Implement profiles and password policies
  • Configure auditing settings and review logs

Backup and Recovery

  • Understand backup strategies
  • Use RMAN for full and incremental backups
  • Perform database recovery

Data Movement Techniques

  • Use Data Pump for import/export
  • Move data with SQL*Loader
  • Implement transportable tablespaces

Performance Monitoring

  • Monitor with AWR and Enterprise Manager
  • Identify performance issues
  • Tune SQL and manage memory

Supporting Applications

  • Manage schema objects
  • Support application performance needs
  • Maintain high availability

< Back to Course Search

Class Dates & Times

Class times are listed Central time

This is a 5-day class

Class dates not listed.
Please contact us for available dates and times.