Program

Oracle Database Administration

Gain the core technical knowledge and practical 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

Access to a personal laptop or desktop computer (Windows operating system recommended; macOS is not supported).

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
10

Number of modules

  • Memory Architecture
  • Background Processes
  • Storage Architecture

  • Linux Operating System Configuration ( Kernel Parameters; RPM Package Management; User and Group Administration)
  • Oracle Listener Configuration (NETCA)
  • LSNRCTL Utility (Starting and Stopping the Listener)
  • Oracle Database Creation and Configuration (DBCA)
  • Database Startup Modes: STARTUP NOMOUNT, MOUNT, and OPEN
  • Database Shutdown Methods: (Shutdown Normal; Shutdown Immediate ; Shutdown Transactional;Shutdown Abort)
  • 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)
  • Tablespaces and Datafiles
  • Creating New Tablespaces (Bigfile and Smallfile Tablespaces)
  • Adding Datafiles to Tablespaces
  • Dropping Tablespaces
  • Alert and Trace File Management
  • Creating Database Users
  • Changing User Passwords
  • Assigning Roles to Users
  • Granting Privileges to Users
  • Revoking User Privileges
  • Flashback Query
  • Flashback Versions Query
  • Flashback Table
  • Flashback Drop
  • Flashback Transaction
  • Flashback Database
  • Flashback Data Archive (Oracle Total Recall)
  • 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)