# HR SQL Analytics
MySQL practice project applying SQL to HR and payroll data. Part 1 of a
4-phase analytics portfolio (SQL → Python → Power BI → Tableau).
## Progress
## PHASE 1: SQL FUNDAMENTALS
| Exercise | Topic | Status |
|---|---|---|
| 1.1 | <Basic Select & Filtering> | ✅ Complete |
| 1.2 | <Inner Join & Left Join> | ✅ Complete |
| 1.3 | | ✅ Complete |
| 1.4 | <Combining Select, Join, and Aggregation> | ✅ Complete|
## PHASE 2: ADVANCED SQL | 2.1 | <Window Functions & Ranking> | ⏳ Next |
| 2.2 | <Common Table Expressions (CTEs)> | ⏳ Next |
| 2.3 | <Data Cleansing & Validation Queries> | ⏳ Next |
| 2.4 | <Capstone - HR Dashboard Query Suite> | ⏳ Next |
## Environment
- MySQL 8.0.46
- MySQL Workbench
## Sample Data Folder Name: Database Samples:
- employeesa_sample.csv
- departments_sample.csv
- payroll_sample.csv
All data in this repository is synthetic and created for learning purposes.
It does not represent any real organization or employee.
SQL Fundamentals/– SQL solutions, one file per exerciseSQL Fundamentals/<Output_Samples>/– query result CSVs, one per exercise<Database Samples>/– sample database/CSV data used across the exercises