📍 Module 1: Introduction to Oracle & RDBMS

• Overview of Oracle Database Architecture

• Oracle Client Tools: SQL*Plus, SQL Developer

• Oracle Editions (XE, SE, EE)

• Connecting to Oracle Database

• Schema, Tablespace, and Object Basics

📍 Module 2: SQL in Oracle

• Data Types, Constraints, and Table Creation

• DDL, DML, and TCL Commands

• SELECT Queries with WHERE, ORDER BY, GROUP BY

• Aggregate Functions: COUNT, SUM, AVG, MAX, MIN

• Joins: INNER, OUTER, CROSS, SELF

• Subqueries & Nested Queries

• Set Operators: UNION, INTERSECT, MINUS

📍 Module 3: Advanced SQL & Optimization

• Indexes, Views, Sequences

• Synonyms and Materialized Views

• Analytical Functions (RANK, DENSE_RANK, NTILE, LAG/LEAD)

• Performance Tuning Basics

• SQL Hints and Execution Plans

• SQL Best Practices

📍 Module 4: PL/SQL Programming

• Introduction to PL/SQL

• Anonymous Blocks and Structured Programming

• Variables, Constants, and Data Types

• Conditional Statements and Loops

• Cursors: Implicit and Explicit

• Exception Handling

📍 Module 5: Stored Procedures and Functions

• Creating and Executing Procedures

• IN, OUT, IN OUT Parameters

• User-Defined Functions

• Packages: Specification and Body

• Triggers: Row-Level and Statement-Level

• Dynamic SQL in PL/SQL

📍 Module 6: Oracle Application Development

• Using Oracle SQL Developer for Development

• Designing Relational Database Models

• Normalization & ER Diagrams

• CRUD Operations via Stored Logic

• Backend Integration with Web Apps (Overview)

📍 Module 7: Oracle Security and User Management

• Users, Roles, and Privileges

• GRANT and REVOKE

• Profiles and Password Policies

• Auditing and Database Security Basics

📍 Module 8: Real-Time Projects

• HR Management System (PL/SQL Project)

• Inventory Management (Schema Design + SQL Logic)

• Sales Reporting Application using Oracle Functions

• Banking Transaction System Simulation

• Oracle Package-Based Business Module