Oracle Database Course Index — Dataplexa
Home › Learning Hub › Oracle Database
Oracle Database

Oracle Database
Course Index

40 Lessons · 4 Levels

Complete Oracle Database roadmap — SQL fundamentals, Oracle architecture, PL/SQL, procedures, triggers, performance tuning, RMAN and Oracle Cloud OCI.

Start Course → ← Back to Learning Hub
40Lessons
4Levels
1Project
FreeAccess
Level I Foundations Level Lessons 1–10
Lesson 01
Introduction to Databases
Lesson 02
SQL vs NoSQL Databases
Lesson 03
What is Oracle Database
Lesson 04
Oracle Editions & Use Cases
Lesson 05
Installing Oracle & SQL Developer
Lesson 06
Oracle Database Architecture
Lesson 07
Tablespaces & Data Files
Lesson 08
Tables, Rows & Columns
Lesson 09
Oracle Data Types
Lesson 10
Creating Tables in Oracle
Level II Core SQL & Data Handling Lessons 11–22
Lesson 11
Constraints & Keys
Lesson 12
Sequences & Identity Columns
Lesson 13
INSERT Data
Lesson 14
SELECT Queries
Lesson 15
WHERE Clause & Filtering
Lesson 16
ORDER BY & FETCH FIRST
Lesson 17
UPDATE Data
Lesson 18
DELETE Data
Lesson 19
Aggregate Functions
Lesson 20
GROUP BY
Lesson 21
HAVING Clause
Lesson 22
NULL Handling in Oracle
Level III Joins, Subqueries & PL/SQL Lessons 23–32
Lesson 23
Table Relationships
Lesson 24
INNER JOIN
Lesson 25
LEFT, RIGHT & FULL OUTER JOIN
Lesson 26
Subqueries
Lesson 27
Views
Lesson 28
Indexes in Oracle
Lesson 29
Introduction to PL/SQL
Lesson 30
PL/SQL Procedures & Functions
Lesson 31
Triggers
Lesson 32
Performance Optimization Basics
Level IV Enterprise & Administration Lessons 33–40
Lesson 33
Users, Roles & Privileges
Lesson 34
Transactions & Concurrency Control
Lesson 35
Backup & Recovery (RMAN)
Lesson 36
Oracle Security Best Practices
Lesson 37
Oracle Performance Tuning
Lesson 38
Oracle Data Pump (Export & Import)
Lesson 39
Oracle Database in Cloud (OCI)
Lesson 40
Mini Project
Ready to Start?
Oracle Database Course Index
Start Course → ← Back to Learning Hub