Course Syllabus
Database Concepts & Architecture
Oracle Database Overview
Oracle Installation & Configuration
Oracle Tools (SQL*Plus, SQL Developer)
Oracle Instance & Database Structure
Introduction to SQL
Data Types in Oracle
DDL (CREATE, ALTER, DROP)
DML (INSERT, UPDATE, DELETE)
DQL (SELECT, WHERE, ORDER BY, GROUP BY, HAVING)
Joins, Subqueries, and Set Operators
Views, Indexes & Sequences
Introduction to PL/SQL
PL/SQL Block Structure
Variables, Constants & Data Types
Control Structures (IF, CASE, LOOP, WHILE, FOR)
Cursors (Implicit & Explicit)
Exception Handling
Procedures & Functions
Packages
Triggers
Constraints & Integrity
Advanced Joins & Analytical Functions
Partitioning & Materialized Views
Performance Tuning & Query Optimization
Execution Plans & Index Optimization
Oracle Database Storage Structures
User & Role Management
Tablespaces & Datafiles
Backup & Recovery (RMAN Basics)
Database Security
Export & Import (Data Pump)
Oracle Networking & Listener
Oracle Grid & RAC Basics
ASM (Automatic Storage Management)
Performance Tuning (AWR, ADDM)
Oracle Cloud Database Overview