Oracle Database Administration 21c: Beginner to Advanced DBA

Learn to become an Oracle Database Administrator (DBA) in 8 hours and get a well paid job as a Junior DBA.

Created byENTOPDBA Academy

Last updated 9/2026

English

What you'll learn

Install and configure Oracle Database 21c in a practical lab environment
Understand Oracle Database architecture, memory structures, processes, and storage
Create and manage tablespaces, datafiles, users, roles, and privileges
Use SQL, DDL, and DML commands to work with Oracle databases
Configure Oracle networking and troubleshoot client connectivity
Perform Oracle RMAN full and incremental backups
Restore and recover Oracle databases after common failures
Monitor Oracle databases using OEM, AWR, ADDM, and Linux tools
Identify common Oracle database performance problems
Develop practical skills required for entry-level Oracle DBA support
Use Data Pump EXPDP and IMPDP for database export and import

Course content

14 sections • 25 lectures • 8h 9m total length

SECTION 1 — Welcome to Oracle Database Administration 21c3:26
Welcome to the Oracle Database Administration 21c course. In this lesson, we introduce the course structure, hands-on lab approach, Oracle DBA responsibilities, and what you will learn throughout the course.
What is Oracle Database16:21
Learn the fundamentals of databases and understand why organizations use database systems. We introduce tables, data, database management systems, and the role of Oracle Database.

Create an Oracle DBA Virtual Machine13:44
Create the virtual machine that will be used as your Oracle DBA practice server. We prepare the environment that will be used for installing and managing Oracle Database 21c.
Configure VM Network Settings11:27
Learn how to configure networking for your Oracle DBA virtual machine. We review IP addresses, network configuration, connectivity, and the basic settings required for Oracle Database installation.

Install Oracle Database 21c and Create a Database56:46
Install Oracle Database 21c and create your first Oracle database. Follow the installation and configuration process step by step in a practical lab environment.
Connect SQL Developer to Oracle Database 21c10:08
Learn how to connect Oracle SQL Developer to your Oracle Database 21c environment. We configure the connection and verify access to the database and HR schema.

Oracle SQL Basics for DBAs14:57
Learn the SQL fundamentals every Oracle DBA should understand. Practice SELECT statements, filtering, sorting, and retrieving information from Oracle tables.
Oracle DDL Commands23:33
Learn Data Definition Language commands used to create and modify database objects. Practice commands such as CREATE, ALTER, DROP
Oracle DML Commands16:33
Learn Data Manipulation Language commands used to work with table data. Practice INSERT, UPDATE, DELETE, and SELECT with practical examples.

Why Oracle Database Backups Are Important3:07
Understand why backups are one of the most important responsibilities of an Oracle DBA. Learn common failure scenarios and how a proper backup strategy protects database data.
Oracle RMAN Incremental Backup18:19
Learn how to perform Oracle RMAN incremental backups. Understand the difference between backup levels and practice creating backups that can be used for database recovery.
Oracle RMAN Full Database Backup18:00
Learn how to perform a full Oracle database backup using RMAN. Understand the backup process, backup locations, and how to verify that the backup completed successfully.
Restore an Oracle Database Using RMAN27:40
Perform a practical Oracle database restore using RMAN. Learn how DBAs recover database files and restore database functionality after a failure.
Point in time Recovery PITR36:36

Requirements

Basic computer knowledge
Basic Linux knowledge is helpful but not required
No previous Oracle DBA experience is required
A willingness to practice in a lab environment

Description

Learn Oracle Database Administration 21c step by step and build the practical skills needed to become a confident Oracle DBA.

If you want to become an Oracle Database Administrator (Oracle DBA), this course is designed for you!

This course follows a step-by-step, hands-on approach, combining easy-to-understand concepts with practical demonstrations and real DBA scenarios.

You will start with the fundamentals and gradually progress into Oracle Database architecture, installation, SQL, storage management, security, networking, backup and recovery, monitoring, performance tuning, and SQL query optimization.

Step-by-Step Learning Methodology

Learn database fundamentals and Oracle DBA concepts
Understand Oracle Database architecture, processes, and memory structures
Install and configure Oracle Database 21c
Work with SQL, DDL, and DML commands
Manage tablespaces, datafiles, and database storage
Manage users, roles, privileges, and database security
Configure Oracle networking, listeners, and connectivity
Understand Oracle alert logs and database monitoring
Perform RMAN full and incremental backups
Restore and recover databases after failures
Monitor databases using OEM, AWR, ADDM, and Linux tools
Troubleshoot Oracle database performance problems
Learn SQL Query Optimization and Execution Plans
Understand indexes, statistics, and the Oracle Optimizer
Practice real-world DBA troubleshooting scenarios
Use Data Pump EXPDP and IMPDP for database export and import

Whether you are a beginner, IT professional, SQL developer, junior DBA, or someone looking to move into Oracle database administration, this course will give you a strong practical foundation.

Let's start your Oracle DBA journey and learn Oracle Database 21c step by step!

Who this course is for:

Beginners who want to become Oracle DBAs
IT professionals moving into Oracle database administration
SQL developers who want to understand Oracle DBA concepts
Junior Oracle DBAs
Database support engineers
System administrators who want to learn Oracle
Students preparing for practical Oracle DBA work

Oracle Database Administration 21c: Beginner to Advanced DBA

What you'll learn

Explore related topics

Course content

Oracle DBA Fundamentals2 lectures • 20min

SECTION 2 — Build Your Oracle DBA Lab2 lectures • 25min

SECTION 3 — Oracle Database Installation2 lectures • 1hr 7min

SECTION 4 — Oracle SQL Fundamentals3 lectures • 55min

SECTION 5 — Oracle Database Architecture1 lecture • 10min

SECTION 6 — Storage Management1 lecture • 34min

SECTION 7 — Oracle Networking1 lecture • 24min

SECTION 8 — Users and Security1 lecture • 23min

SECTION 9 — Monitoring and Troubleshooting1 lecture • 38min

SECTION 10 — Oracle Backup and Recovery5 lectures • 1hr 44min

Requirements

Description

Who this course is for: