roadmap.md

This document provides an overview of the modules covered in this learning portfolio.

---

Module 01: SELECT Basics

• Introduction to simple queries
• Selecting columns, literals, and expressions
• Filtering rows with WHERE
• Ordering results

Module 02: Filtering & Functions

• Using LIKE, BETWEEN, IN, NULL checks
• String functions: UPPER, LOWER, INITCAP, LENGTH, SUBSTR
• Date functions: SYSDATE, ADD_MONTHS, MONTHS_BETWEEN, TRUNC
• Numeric functions: ROUND, FLOOR, CEIL

Module 03: Joins & Relationships

• INNER, LEFT, RIGHT, FULL OUTER joins
• Multi-table joins and aliases
• Self-joins for hierarchical data
• Joining training logs, payroll, budgets with employees

Module 04: Aggregation & GROUP BY

• Aggregation functions: COUNT, SUM, AVG, MAX, MIN
• Grouping data with GROUP BY
• Filtering grouped data with HAVING
• Department-wise and employee-wise summaries

---

Future Modules (Planned)

• Analytic Functions & Windowing
• Subqueries & Nested Queries
• PL/SQL Programming Basics
• Performance Tuning & Indexing
• Advanced Reporting & Dashboarding

---

Notes

This learning path is designed to progress from beginner to intermediate Oracle SQL skills systematically.