Now updated for Oracle 19c / 21c / 23ai

Learn Oracle Database Administration & SQL — Free, Step by Step

Hands-on tutorials, real examples and interview prep covering everything from installing your first database to RMAN backup & recovery, Data Pump, Flashback and beyond.

Where to start

Pick your learning path

Oracle DBA

Database creation, tablespaces, control files, undo, backup & recovery, RMAN.

Browse topics →
Oracle SQL

SELECT, joins, functions, DDL/DML, views, sequences, partitions and more.

Browse topics →
MySQL Tutorial

Install, configure and query MySQL step by step with examples.

Browse topics →
Interview Prep

100+ Oracle DBA, Backup & Recovery and Unix interview questions.

Browse questions →
Recently added

What's new on the site

Oracle 19c / 21c / 23ai notes

New callouts on every legacy topic flag what changed in current Oracle releases — multitenant defaults, deprecated init parameters, and new RMAN/Data Pump options.

Autonomous & Cloud DBA basics

A new primer on how traditional DBA tasks map to Oracle Autonomous Database and OCI-managed environments.

Modern security defaults

Updated guidance reflecting current password/profile defaults and TDE basics, replacing outdated 11g-era security notes.

Full curriculum

Oracle Database Administration Contents

Career prep

Oracle DBA Interview Questions

60

Core Oracle DBA technical questions

View questions
42

Backup & Recovery interview questions

View questions
20

Unix for Oracle DBA questions

View questions

Need the Oracle software?

Direct links to download Oracle 11g / 12c and newer releases for Linux, Windows and more.

Get Download Links