The Human Resources SQL Case Study is a hands-on project designed to challenge our SQL skills and deepen our understanding of database management. In this project, we'll explore a database schema consisting of three tables: departments, employees, and projects. Each table contains relevant columns to capture employee details, department information, and project details.
To successfully answer all the questions you should have been exposed to the following areas of SQL:
- Window Functions like rank, lag
- Pattern Matching
- Joins
- Date time functions
- CTEs
๐ฏ Project Objective: The main objective of this case study is to apply various SQL concepts and techniques to answer insightful questions about Human Resources. Some of the key objectives include:
-
Find the longest ongoing project for each department.
-
Find all employees who are not managers.
-
Find all employees who have been hired after the start of a project in their department.
-
Rank employees within each department based on their hire date (earliest hire gets the highest rank).
-
Find the duration between the hire date of each employee and the hire date of the next employee hired in the same department.