Program

Oracle Database Administration

Build the core technical knowledge and hands-on skills required to become an Oracle Database Administrator.

The Oracle Database Administration training program is designed for professionals who want to learn how to install, configure, manage, secure, back up, and recover Oracle databases through hands-on practice. Throughout the program, participants will work with Oracle Linux, Oracle Database 19c, database architecture, user administration, RMAN, and Flashback technologies in a real lab environment, gaining the practical skills needed to perform confidently as an Oracle Database Administrator (DBA). 🚀

Apply
Start date

August 2026

Duration

2 months

Group size

6-10

Schedule

on Tuesdays and Thursdays at 19:30 - 21:30

Admission requirements
Age

18 years and older

Language skills

Knowledge of English at least Intermediate level

Requirement

Availability of a personal laptop or computer

Expectation

Be prepared for intensive training and willingness to constantly research additional materials

Upon the course completion you will::

Be able to install and configure an Oracle Database 19c environment.

Be able to administer Oracle servers running on Oracle Linux.

Be able to effectively manage database storage and memory architecture.

Gain the practical skills required to pursue a professional career as an Oracle Database Administrator (DBA) and work with Oracle Infrastructure.

Program

Oracle Database Administration
1

Number of modules

Oracle Database Architecture

  • Memory Architecture
  • Background Processes
  • Storage Architecture

Oracle Enterprise Linux Installation and Configuration 

  • Linux Operating System Configuration ( Kernel Parameters; RPM Package Management; User and Group Administration)

Oracle 19c RDBMS Software Installation

  • Oracle Listener Configuration (NETCA)
  • LSNRCTL Utility (Starting and Stopping the Listener)
  • Oracle Database Creation and Configuration (DBCA)

Oracle Database Startup and Shutdown Methods

  • Database Startup Modes: STARTUP NOMOUNT, MOUNT, and OPEN
  • Database Shutdown Methods: (Shutdown Normal; Shutdown Immediate ; Shutdown Transactional;Shutdown Abort)

Oracle Database Physical Files Management 

  • Parameter File Management (SPFILE and PFILE)
  • Password File Management
  • Control File Administration
  • Online Redo Log and Archive Log Management (Adding and Removing Redo Log Groups; Adding and Removing Redo Log Members)

Introduction to Oracle Database Administration 

  • Tablespaces and Datafiles
  • Creating New Tablespaces (Bigfile and Smallfile Tablespaces)
  • Adding Datafiles to Tablespaces
  • Dropping Tablespaces
  • Alert and Trace File Management

Basic Database User Administration

  • Creating Database Users
  • Changing User Passwords
  • Assigning Roles to Users
  • Granting Privileges to Users
  • Revoking User Privileges

Flashback Technologies and UNDO Management 

  • Flashback Query
  • Flashback Versions Query
  • Flashback Table
  • Flashback Drop
  • Flashback Transaction
  • Flashback Database
  • Flashback Data Archive (Oracle Total Recall)

RMAN Fundamentals: Backup and Recovery Scenarios

  • Backupset Backups
  • Image Copy Backups
  • Crosscheck Operations
  • Data Corruption Detection and Management
  • Database Recovery from Backup: ( Datafile Recovery; Tablespace Recovery; Database Recovery)(datafile,tablespace,database)

Oracle Read Consistency and Locking Mechanisms