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