Introduction & Basics
Overview of Oracle database architecture
Oracle Instance vs Database concepts
Tablespaces, datafiles, control files, redo logs

SQL Fundamentals
DDL, DML, DQL operations
Constraints: Primary key, unique, foreign key, check
Joins, subqueries, set operators

PL/SQL Programming
PL/SQL blocks, variables, datatypes
Procedures, functions, packages
Triggers, cursors, exceptions
Collections and records

Database Management
User management, privileges, roles
Backup & recovery (RMAN basics)
Performance tuning, indexing, execution plans

Advanced Topics
Materialized views
Partitioning
Oracle Data Pump (import/export)
Oracle ASM concepts
Database security policies