Project
Payroll Management Database
Medium
90 completions
~ 7 hours
3.9Learn how to perform calculations and generate reports using a combination of MySQL control flow statements, functions, and procedures.
Provided by
JetBrains Academy
About
As organizations grow, managing payroll becomes more complex. With more employees to track and pay across departments and various regulations to comply with, errors and disputes can be costly. This project teaches how to manage a database system to track employee data, calculate pay, and generate reports.
Graduate project
This project covers the core topics of the SQL for Backend Developers course, making it sufficiently challenging to be a proud addition to your portfolio.
At least one graduate project is required to complete the course.
What you'll learn
Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:
Get the list of employees in departments.
Calculate the total pay using an IF-ELSEIF-ELSE function and procedure
Calculate the tax with CASE and other tools.
Put everything together and generate a payroll report
Reviews
3 weeks ago
Overall, it is a great project that should be polished a little. I practiced CTEs, user-defined functions, procedures, passing values from one CTE to another one, temporary tables, numerical data types, if statements. It was non-intuitive to use Float data type for monetary values (salary, tax etc ...
7 months ago
Good way to practice procedures and functions for data processing. You will have to make them work together.But instructions are not always clear and I had to look at the comments for a better understanding.
1 year ago
This project was an exceptional deep dive into sophisticated database engineering. It demonstrated strong skills in complex queries, programmatic data processing with stored functions and procedures, and data modeling for business logic.
3.9
Learners who completed this project within the SQL for Backend Developers course rated it as follows: