What is the Oracle Database 19c Administration Workshop?

A 5-day instructor-led course teaching how to install, configure, secure, and maintain Oracle 19c in both on‑prem and cloud environments.

How will this course help me install and configure Oracle databases?

Gain hands-on experience installing Oracle 19c, creating databases, configuring parameters, and deploying DBCS instances in OCI.

Does it teach user security and access management?

Yes—you’ll set up users, assign privileges, implement password policies, and configure auditing for compliance.

Will I learn backup and recovery?

Absolutely—use RMAN for full/incremental backups and recovery to handle data loss scenarios effectively.

Does this prepare me for Oracle certification?

Yes—this course supports preparation for the Oracle Database Administration I exam (1Z0‑082), a step toward OCP certification.

Oracle Database 19c: Administration Workshop

Price
$4,000.00 USD

Duration
5 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class 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).

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

Who Should Attend?

Developer Implementer Systems Administrator

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

What is the Oracle Database 19c Administration Workshop?
A 5-day instructor-led course teaching how to install, configure, secure, and maintain Oracle 19c in both on‑prem and cloud environments.
How will this course help me install and configure Oracle databases?
Gain hands-on experience installing Oracle 19c, creating databases, configuring parameters, and deploying DBCS instances in OCI.
Does it teach user security and access management?
Yes—you’ll set up users, assign privileges, implement password policies, and configure auditing for compliance.
Will I learn backup and recovery?
Absolutely—use RMAN for full/incremental backups and recovery to handle data loss scenarios effectively.
Does this prepare me for Oracle certification?
Yes—this course supports preparation for the Oracle Database Administration I exam (1Z0‑082), a step toward OCP certification.

Course Prerequisites

Familiarity with relational database design and concepts
Familiarity with Oracle SQL and Oracle PL/SQL

Agenda

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

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.