Complete Oracle Database Administration course (19C,21C)

Name: Complete Oracle Database Administration course (19C,21C)
Rating: 4.4 (3577 reviews)

Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade

Bestseller

Created byOleksiy Gusarov

Last updated 2/2026

English

German [Auto],English [Auto],

What you'll learn

Oracle Database Administration
Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
How to install Oracle Database Software on the server without GUI
How to access Oracle Database via sqlplus, sqlcl and SQL Developer
Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
Oracle Net Services
Administering User Access, Privileges & Roles, Resource Limitation
Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
Transparent Data Encryption (TDE)
Creating and Managing Tablespaces
Managing UNDO Data
Practicing different Backup and Recovery scenarious via RMAN
Moving Data: Data Pump, SQL Loader
Data Guard configuration
Applying the latest Database Patch
Database Upgrade from 19c to 21c

Course content

22 sections • 118 lectures • 9h 48m total length

Introduction2:32

Oracle Database Server Architecture. Basics.8:25
Physical files of the Database review4:44
Explore Oracle architecture and the physical database files, including control, data, and online redo logs, plus initialization, password, and backup files and ASM storage.
Possible Oracle Server Configurations5:32
Explore common Oracle server configurations, including single and multiple instance databases, and Oracle real application clusters, where multiple instances on shared storage across nodes boost throughput and scalability.

Important Message0:27
Create and configure Virtual machine in VirtualBox Manager7:36
Download and Install Oracle Linux on VM7:23
In this Lecture we will install Oracle Linux on your VM server:
Extract the content of the Oracle Linux Installation.zip file and follow step by step instructions to complete the below tasks:
- How to download Oracle Linux boot image?
- How to boot your VM from Oracle Linux boot image?
- How to complete Oracle Linux Installation?
SOFTWARE SILENT INSTALLATION17:26
License Warning0:13

Memory Structures17:59
Explore Oracle memory structures, including SGA, library cache, and data dictionary cache, that store data and execution plans; examine database buffer cache, redo log buffer, and PGA for performance.
Memory Management6:01
Learn Oracle memory management options, including automatic memory management, automatic shared memory management, and manual mode. Configure memory targets, SGA and PGA, and monitor with show parameter and v$memory_target_advice.
Background processes11:56
Discover how an Oracle instance uses memory structures and background processes, including db writer, checkpoint, log writer, archiving, and system monitor, to ensure fast commits, data integrity, and recovery.
Multitenant Architecture5:31
Explore Oracle multitenancy, using a container database with a root container and seed, enabling multiple pluggable databases with shared undo and maintenance at the CDB level.

Creating PDBs from SEED6:07
Cloning PDBs7:21
Refreshable Clone6:00
Learn how to create and manage refreshable clone pluggable databases, enabling automated or manual refreshes with recent redo for cloud migrations and minimal downtime.
Unplugging and Plugging PDBs8:31
Unplug and plug pluggable databases (PDBs) into and from a container database (CDB) using XML metadata, with no-copy, copy, and move options.
Unplug/Plug PDB using an archive file2:46
Dropping PDBs3:00

Creating Users6:10
Create and manage common and local database users by assigning authentication methods, passwords, quotas, default and temporary tablespaces, and profiles in a multitenant Oracle environment.
Privileges & Roles12:40
Discover how Oracle manages privileges and roles, from system and object privileges with admin options, to common and local roles in multi-tenant environments, including password protected role concepts.
Show Privileges3:37
Revoke privilege, Drop roles and users1:09
Revoke table privileges from a role or user, drop roles and users in Oracle, and use cascade to remove a user’s schema objects or drop without cascade if none exist.
Authentication5:59
Explore Oracle database authentication options: password, operating system, password-file, AWS authentication, and strong SSL or directory authentication, and see how OS groups grant admin privileges and enable secure access.
Limit Resources11:50
Learn to design and enforce database resource limits with profiles, restricting CPU, memory, and disk I/O, connect and idle times, and concurrent sessions to protect the server.

Requirements

Basic Linux Knowledge
understand what is a process in linux
Basic SQL Knowledge

Description

After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.

You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real-world production scenario (in 99% there is no GUI on production servers). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don't forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.

According to the U.S. BUREAU OF LABOR STATISTICS employment of database administrators is projected to grow 15 percent from 2019 to 2029, much faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies across the economy. After the pandemic the demand doubles.

The long-term support Oracle Database 19c version was chosen for this course to teach you the database administration skills. It provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications.

At the end of the course, we will learn different ways to Upgrade from the 19c to 21c version. Upgrades are crucial to satisfy business high growing demands for the new features released in the new product versions. All operation manuals provided for the 19c version still work on 21c.

Who this course is for:

Students looking for a job in IT industry
IT specialists willing to improve their database knowledge
Retraining for DBA who worked with other Database Management Systems
Oracle Database Beginners willing to advance

Complete Oracle Database Administration course (19C,21C)

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 3min

Oracle Database Architecture ( part 1 )3 lectures • 19min

Oracle Database Installation5 lectures • 33min

Oracle Database Architecture ( part 2 )4 lectures • 41min

Accessing an Oracle Database4 lectures • 16min

Manage Database Instance5 lectures • 34min

Creating PDBs6 lectures • 34min

Oracle Net Services2 lectures • 18min

Users6 lectures • 41min

TDE1 lecture • 13min

Requirements

Description

Who this course is for: