Get the best performance for your most demanding analytical and operational workloads.
Oracle Database Administration training gives you the core knowledge you need to become a successful Oracle DBA. Learn how to install, troubleshoot, manage, secure, and optimize your Oracle Database.
This Oracle Database Administration course is perfect for administrators who want to learn about the architecture of an Oracle Database instance and database. You will also learn how to create users and administer database security, as well as backup and recovery techniques.

Overview
Learn how to effectively manage and administer your Oracle Database.
This OD-19c-AW: Oracle Database 19c: Administration Workshop course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database.
In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Skills Covered
- Describe Oracle Database architecture
- Describe Oracle Database Cloud Service (DBCS) architecture and features
- Create and manage DBCS database deployments
- Configure the database to support your applications
- Manage database security and implement auditing
- Implement basic backup and recovery procedures
- Move data between databases and files
- Employ basic monitoring procedures and manage performance
Prerequisites
- Should have an understanding of relational database concepts and good operating system knowledge.
- Should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL.
Target Audience
This Oracle Database 19c Administration course is for anyone who needs to administer, monitor and support an Oracle database.

Module 1: Introduction to Oracle Database
- Course Overview – Oracle Database 19c: Administration Workshop
- Database Server Architecture
Module 2: Accessing an Oracle Database
- Accessing an Oracle Database
- Demo: Usage of general Oracle Database tools to Interact with Database
Module 3: Creating an Oracle Database by Using DBCA
- Creating a Database Using DBCA
Module 4: Creating an Oracle Database by Using a SQL Command
- Creating Database using SQL Command
Module 5: Starting Up and Shutting Down a Database Instance
- Starting Up and Shutting Down a Database Instance
- Opening and Closing PDBs
Module 6: Managing Database Instances
- Managing the Database
Module 7: Oracle Net Service: Overview
- Configuring and Administering Oracle Net Service
Module 8: Configuring Naming Methods
- Oracle Net Components
- Naming Method
Module 9: Configuring and Administering the Listener
- Configuring and Administering the Listener
Module 10: Configuring a Shared Server Architecture
- Configuring a Shared Server Architecture
Module 11: Configuring Oracle Connection Manager for Multiplexing and Access Control
- Connection Manager
- Demo: Installing Oracle Instant Client
- Demo Configuring the cman.ora File
- Demo: Configuring the Database for Oracle Connection Manager
- Demo: Configuring Clients for Oracle Connection Manager
- Demo Configuring the Oracle Database Server for Session Multiplexing
Module 12: Creating PDBs from Seed
- Creating PDBs from Seed
- Provisioning New Pluggable Databases-(Continued)
Module 13: Using Other Techniques to Create PDBs
- Using Other Techniques to Create PDBs
- Method of Creating and Migrating PDBs
- Demo: Cloning Remote PDBs in Hot Mode (Part 01)
- Demo: Cloning Remote PDBs in Hot Mode (Part 02)
- Demo: Relocating PDBs
Module 14: Managing PDBs
- Managing PDBs
Module 15: Database Storage Overview
- Database Storage Overview
- Purpose of the Default Tablespaces
- Storage of Data in Blocks
- Advantage of Deferred Segment Creation
Module 16: Creating and Managing Tablespaces
- Creating and Managing Tablespaces
- Viewing Tablespace Information
Module 17: Improving Space Usage
- Space Management Features
- Creating Global Temporary Tables
Module 18: Managing Undo Data
- Managing the Undo
- Enabling Temporary Undo
Module 19: Creating and Managing User Accounts
- Creating and Managing User Accounts
- Creating Common Users in the CDB and PDBs
- Assigning Quotas
Module 20: Configuring Privilege and Roles Authorization
- Configuring Privilege and Roles Authorization
Module 21: Configuring User Resource Limits
- Configuring User Resource Limits
- Demo: Using SQL*Developer to Create Local Users (Part 01)
- Demo: Using SQL*Developer to Create Local Users (Part 02)
Module 22: Implementing Oracle Database Auditing
- Implementing Oracle Database Auditing
- Configuring Auditing
- Viewing Audit Policy Information
Module 23: Introduction Loading and Transporting Data
- Introduction Loading and Transporting Data
Module 24: Loading Data
- Loading Data
Module 25: Transporting Data
- Transporting Data
- Using the RMAN Convert Command
Module 26: Using External Tables to Load and Transport Data
- Using External Tables to load Transport Data
- External Table Demo
Module 27: Automated Maintenance Tasks: Overview
- Automated Maintenance Tasks: Overview
- Automated Maintenance Tasks: Components
Module 28: Automated Maintenance Tasks: Managing Tasks and Windows
- Configuring Automated Maintenance Tasks
Module 29: Database Monitoring and Performance Tuning Overview
- Database Monitoring and Tuning Performance Overview
Module 30: Monitoring Database Performance
- Understanding What Database Performance is Monitored
Module 31: Analyzing SQL and Optimizing Access Paths
- Analyzing SQL and Optimizing Access Paths
- Adaptive Execution Plans
Dates & Locations
February 15, 2027 - February 19, 2027
February 15, 2027 - April 12, 2027
April 12, 2027 - April 16, 2027
April 12, 2027 - April 16, 2027
June 21, 2027 - June 25, 2027
June 21, 2027 - June 25, 2027
August 9, 2027 - August 13, 2027
August 9, 2027 - August 13, 2027
October 4, 2027 - October 8, 2027
October 4, 2027 - October 8, 2027
December 20, 2027 - December 24, 2027
December 20, 2027 - December 24, 2027

Exam & Certification
Oracle Database Administration 2019 Certified Professional.
Preparing for the Oracle Database Administration Certified Professional credential helps candidates gain the skills and knowledge to install, patch and upgrade Oracle Database and Oracle Grid Infrastructure for a standalone server, create and manage a backup and recovery strategy using Recovery Manager (RMAN), use RMAN for Database duplication and transportation, diagnose failures using RMAN, and manage all aspects of Multitenant container databases, pluggable databases and application containers including creation, cloning, security, transportation and backup and recovery.
By earning the Oracle Database Administrator Certified Professional credential, you will be demonstrating your possession of the full skill set required to perform day to day administration of the Oracle Database.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631























