Welcome to a curated collection of real-world SQL exercises used to build and support the HR Workforce Dashboard 💼📊.
This repository showcases my applied SQL knowledge across multiple domains, including:
- 🧱 PL/SQL fundamentals
- 🧮 Conditional logic
- 🔁 Cursors
⚠️ Exception handling- 📦 Subprograms & procedures
| Filename | Description |
|---|---|
pl-sql-block.sql |
Core structure for anonymous PL/SQL blocks |
condition-is-manager.sql |
Conditional logic to check managerial role |
exception-replace-head-honcho.sql |
Handles exceptions while replacing top manager |
cursors-create-new-tables.sql |
Cursor to loop and create tables dynamically |
subprograms-get-manager.sql |
Procedure to return a manager by department |
get-age.sql |
Calculates employee age from birthdate |
✅ All scripts tested using Oracle SQL Developer
🎓 Designed to reinforce HR analytics workflows
Click below to view the full HR Workforce Dashboard 👉
These queries were used for:
- 🔹 Cleaning and transforming Oracle HR schema data
- 🔹 Building calculated fields for salary analysis
- 🔹 Powering interactive Power BI visuals
- 🔹 Demonstrating advanced control flow and error handling
| Project | Link |
|---|---|
| 📊 HR Workforce Dashboard | View Full Dashboard 📁 |
| 🧠 SQL Exercises Repo | You Are Here |
Showcasing SQL mastery and dashboard impact for real-world hiring and financial challenges.