Course Overview

What this Oracle Database course covers, how to use it, prerequisites.

A structured, hands-on course on Oracle Database, SQL, and PL/SQL. It runs from first principles to expert-level architecture, administration, performance tuning, high availability (RAC, Data Guard), security, multitenant, and the newest Oracle Database 23ai / 26ai and cloud features.

Course Overview

Students, developers, PL/SQL programmers, data analysts, aspiring and practicing DBAs

Basic computer literacy. No prior database experience required.

~150–180 hours (self-paced), 12–14 weeks Oracle Database 23ai Free (or 26ai Free), SQL Developer / SQL Developer extension for VS Code, SQLcl, SQL*Plus Free cloud option

Oracle Cloud Free Tier: two Always Free Autonomous Databases Sample schemas

HR, OE, SH, CO (Customer Orders) from Oracle's db-sample-schemas GitHub repo, plus the course SHOP schema Practice online

Oracle Live SQL (freesql.com), Oracle Dev Gym Course Sample Schema: SHOP

SQL Basics      →  Intermediate SQL  →  PL/SQL          →  Advanced Data
(Modules 1–8)      (Modules 9–19)       (Modules 20–30)    (Modules 31–34)
                                                               ↓
HA & Cloud      ←  Performance       ←  Administration (DBA)
(Modules 57–66)    (Modules 47–56)      (Modules 35–46)

customers   (customer_id PK, first_name, last_name, email, city, country, created_at)
categories  (category_id PK, category_name, parent_category_id FK → categories)
products    (product_id PK, product_name, category_id FK, unit_price, stock, is_active)
employees   (employee_id PK, full_name, manager_id FK → employees, hire_date, salary, dept_id)
orders      (order_id PK, customer_id FK, employee_id FK, order_date, status, ship_city)
order_items (order_id FK, product_id FK, quantity, unit_price, discount)  PK(order_id, product_id)