Oracle SQL Syllabus - Intermediate
Module 1: SQL & RDBMS Refresher
Introduction to SQL and Databases
DBMS vs RDBMS
SQL Standards and Sub-languages
SQL*Plus and Developer Tools
Module 2: Table Design & DDL Operations
Creating, Altering, Dropping Tables
Data Types and NULL Handling
TRUNCATE vs DELETE
Creating table from another table
Module 3: Data Manipulation Language
NSERT (single/multiple rows, subqueries)
UPDATE and DELETE
Copying data and structure between tables
Module 4: Transactions & Access Control
COMMIT, ROLLBACK, SAVEPOINT
GRANT and REVOKE
Object and System Privileges
Module 5: Constraints & Keys
NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY
CHECK, DEFAULT, Composite and Alternate Keys
Adding/modifying constraints
Module 6: Filtering & Clauses in SELECT
WHERE, BETWEEN, LIKE, IN
ORDER BY, GROUP BY, HAVING
Column and Table Aliases
Module 7: Built-in Functions
String, Date, Math, Conversion Functions
Aggregate Functions: COUNT, SUM, AVG, MAX, MIN
DUAL Table
Module 8: Joins in SQL
NNER JOIN, OUTER JOIN (LEFT/RIGHT/FULL), SELF JOIN
CROSS JOIN
Module 9: Subqueries & Set Operators
Single-row and Multi-row Subqueries
Correlated Subqueries and Nested Queries
UNION, UNION ALL, INTERSECT, MINUS
Pseudo-columns: ROWID, ROWNUM
Module 10: SQL Performance & BI Integration
🔹 Indexing Basics
Purpose and types (Single, Composite, Unique)
When and why to use indexes
🔹 Query Optimization
Writing efficient queries
WHERE vs HAVING, IN vs EXISTS
Introduction to EXPLAIN PLAN
🔹 SQL for BI & Reporting
SQL in BI tools (Power BI/Tableau)
Aggregated and reporting-focused queries