Designed and developed an Oracle-based HR Analytics system using a multi-table dataset and 10+ advanced SQL queries, leveraging window functions and analytical techniques to uncover insights in sal…
Project Overview
This project demonstrates the use of SQL for analyzing HR datasets. It includes:
Creating a full HR database schema Inserting realistic employee,departments, attendance, and promotion data Running analytical SQL queries Using window functions like DENSE_RANK(), ROW_NUMBER(), and date functions Exploring insights such as pay gaps, absenteeism, tenure, and salary growth
All logic is implemented in: 📄 hr_analytics.sql
Additional advanced queries stored in: 📄 Sql_Project_Queries.txt