Week 2: Querying & Filtering Data

• Sorting with ORDER BY
• Column aliases and expressions
• DISTINCT keyword
• Logical operators and precedence

Week 3: Single Row Functions

• Character, Number, Date, and Conversion Functions
• NVL, NVL2, NULLIF, COALESCE
• Nested functions

Practice: Format salary, hire dates, and names using functions

Week 4: Group Functions

• COUNT, SUM, AVG, MIN, MAX
• GROUP BY and HAVING clauses
• GROUPING sets and rollup/cube (advanced)

Week 5: Joins & Subqueries

• INNER, OUTER, SELF, and CROSS JOINs
• Using table aliases and join conditions
• Subqueries: single-row, multi-row, correlated

Practice: Join employees, departments, and locations

Week 6: DDL & DML Statements

• CREATE, ALTER, DROP (tables, columns)
• INSERT, UPDATE, DELETE
• TRUNCATE, RENAME

Week 7: Constraints & Sequences

• NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
• Create and use SEQUENCES
• Default values and identity columns

Practice: Create tables with realistic business constraints

Week 8: Set Operators & Advanced Subqueries

• UNION, UNION ALL, INTERSECT, MINUS
• EXISTS, ANY, ALL
• WITH clause (subquery factoring)

Week 9: Views, Synonyms & Indexes

• Create and manage VIEWS
• Use simple and complex views
• Understand SYNONYMS and INDEXES

Practice: Create a view joining multiple HR tables

Week 10: Transactions & TCL

• COMMIT, ROLLBACK, SAVEPOINT
• ACID properties
• Basic error handling with DML

Week 11: User Management Basics (SQL Focus)

• Create user, grant/revoke privileges (basic)
• Object vs system privileges

Practice: Grant SELECT/INSERT privileges to another user

Week 12: Capstone Project & Certification Prep

• Design a mini HRMS or Library schema
• Populate data using SQL scripts
• Write 15–20 complex queries (joins, groups, subqueries, views)

Certification

Oracle Database SQL – 1Z0-071 (covers all major SQL concepts; no prior certification required)