This SQL project demonstrates the creation and management of an Employee Management System using a relational database. It includes database design, table creation, data insertion, and 20+ analytical SQL queries used for real-world data analysis.
- sqlprojectdocument.pdf
- SqlProject.sql
- Queries.sql
Two main tables: departments and employee.
- Table creation
- Data insertion
- Joins
- Aggregations
- Subqueries
- Window functions
- Filtering and grouping
This project is ideal for Data Analyst, SQL Developer, and fresher portfolios.
- Download the folder
- Import
.sqlfiles into MySQL - Run scripts step-by-step
- Modify queries for practice