Oracle Database Administrator

Learn to operate self-managed Oracle Database: multitenant architecture, instance memory, Oracle Net, users and roles, ASM and tablespaces, RMAN recovery, Data Guard, read-only standby operations, RAC, patching, performance diagnosis, and daily maintenance. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

180 interactive lessons across 6 units · 36+ hours · advanced level

What you will learn

Build practical skills in Oracle Database, Oracle DBA, RMAN, Data Guard, RAC, Operations, High Availability through browser-based coding exercises, guided feedback, unit quizzes, a debugging challenge, and a final project.

Course access

Unit 1, including its first 30 lessons and unit quiz, is free. The remaining 5 units require a CodeLearning365 Pro subscription.

View Pro access options

Oracle Database Administrator curriculum

The curriculum progresses from foundations to applied practice and mastery. Representative topics from every unit are listed below.

Unit 1: Foundations

30 lessons covering topics such as Oracle Instance and Memory Architecture, CDB and PDB Architecture, Initialization Parameters and SPFILE, Oracle Net Listener and Services, Users, Schemas, and Authentication.

Oracle Instance and Memory Architecture
CDB and PDB Architecture
Initialization Parameters and SPFILE
Oracle Net Listener and Services
Users, Schemas, and Authentication

Unit 2: Core Concepts

30 lessons covering topics such as Oracle DBA Incident Capstone, Power Up 032: Oracle Instance and Memory Architecture, Power Up 033: CDB and PDB Architecture, Power Up 034: Initialization Parameters and SPFILE, Power Up 035: Oracle Net Listener and Services.

Oracle DBA Incident Capstone
Power Up 032: Oracle Instance and Memory Architecture
Power Up 033: CDB and PDB Architecture
Power Up 034: Initialization Parameters and SPFILE
Power Up 035: Oracle Net Listener and Services

Unit 3: Building Skills

30 lessons covering topics such as Power Up 061: Oracle Scheduler and Maintenance Windows, Power Up 062: Oracle DBA Incident Capstone, Power Up 063: Oracle Instance and Memory Architecture, Power Up 064: CDB and PDB Architecture, Power Up 065: Initialization Parameters and SPFILE.

Power Up 061: Oracle Scheduler and Maintenance Windows
Power Up 062: Oracle DBA Incident Capstone
Power Up 063: Oracle Instance and Memory Architecture
Power Up 064: CDB and PDB Architecture
Power Up 065: Initialization Parameters and SPFILE

Unit 4: Applied Practice

30 lessons covering topics such as Power Up 091: Routine DBA Health Checks, Power Up 092: Oracle Scheduler and Maintenance Windows, Power Up 093: Oracle DBA Incident Capstone, Power Up 094: Oracle Instance and Memory Architecture, Power Up 095: CDB and PDB Architecture.

Power Up 091: Routine DBA Health Checks
Power Up 092: Oracle Scheduler and Maintenance Windows
Power Up 093: Oracle DBA Incident Capstone
Power Up 094: Oracle Instance and Memory Architecture
Power Up 095: CDB and PDB Architecture

Unit 5: Projects

30 lessons covering topics such as Power Up 121: Database Upgrade Readiness, Power Up 122: Routine DBA Health Checks, Power Up 123: Oracle Scheduler and Maintenance Windows, Power Up 124: Oracle DBA Incident Capstone, Power Up 125: Oracle Instance and Memory Architecture.

Power Up 121: Database Upgrade Readiness
Power Up 122: Routine DBA Health Checks
Power Up 123: Oracle Scheduler and Maintenance Windows
Power Up 124: Oracle DBA Incident Capstone
Power Up 125: Oracle Instance and Memory Architecture

Unit 6: Mastery

30 lessons covering topics such as Power Up 151: Patching with Release Updates, Power Up 152: Database Upgrade Readiness, Power Up 153: Routine DBA Health Checks, Power Up 154: Oracle Scheduler and Maintenance Windows, Power Up 155: Oracle DBA Incident Capstone.

Power Up 151: Patching with Release Updates
Power Up 152: Database Upgrade Readiness
Power Up 153: Routine DBA Health Checks
Power Up 154: Oracle Scheduler and Maintenance Windows
Power Up 155: Oracle DBA Incident Capstone

Continue learning with a related course

PostgreSQL Database Administrator coding course — Learn to operate self-managed PostgreSQL: architecture, configuration, roles, query planning, vacuum, backups and point-in-time recovery, streaming replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
MySQL DBA coding course — Learn to operate self-managed MySQL with InnoDB: architecture, configuration, users and roles, query plans, buffer pool and redo maintenance, backups and point-in-time recovery, GTID replication, read replicas, high availability, and incident routines. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.
JavaScript Fundamentals coding course — Build a confident JavaScript foundation with variables, functions, collections, and asynchronous code. Follow the ideas in small steps: first understand the concept, then practice it in the browser, and finally connect it to a realistic coding problem. Each lesson builds on the previous one so the track becomes a skill you can explain and use, not just a list of terms.

Compare all coding tracks