Project
Payroll Management Database
Medium
73 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 months 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.
5 months ago
This project was a deep dive into the more advanced features of SQL, moving beyond simple queries into creating complex, server-side logic.
5 months ago
Learned procedures and functions, but explanations for the tasks were not clear from stage 3 and 4.
3.9
Learners who completed this project within the SQL for Backend Developers course rated it as follows: