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.

Course Curriculum

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

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

February 15, 2027 - February 19, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

February 15, 2027 - April 12, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062

April 12, 2027 - April 16, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

April 12, 2027 - April 16, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062

June 21, 2027 - June 25, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

June 21, 2027 - June 25, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062

August 9, 2027 - August 13, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

August 9, 2027 - August 13, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062

October 4, 2027 - October 8, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

October 4, 2027 - October 8, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062

December 20, 2027 - December 24, 2027

Location: Kuala Lumpur
Modal: ILT
Availability: TBC
Exam:
RM 1062

December 20, 2027 - December 24, 2027

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1062
Trainocate exam and cert

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

Preferred mode of training
Checkboxes