Employee Management System (SQL)

A complete SQL project developed using Microsoft SQL Server to manage employee records, departments, and company-related information.

This project demonstrates SQL concepts from beginner to intermediate level with practical business scenarios.

---

Technologies Used

• Microsoft SQL Server (SSMS)
• SQL
• Visual Studio Code
• GitHub

---

Features

• Create Database
• Create Tables
• Insert Sample Data
• Employee Management
• Department Management
• SQL Query Practice
• Aggregate Functions
• Sorting
• Filtering
• Data Formatting

---

SQL Concepts Covered

• SELECT
• DISTINCT
• WHERE
• ORDER BY
• TOP
• CONCAT()
• UPPER()
• LOWER()
• LEN()
• TRIM()
• REPLACE()
• COALESCE()
• ISNULL()
• FORMAT()
• GROUP BY
• HAVING

---

Project Structure

Employee Management System
│
├── Database Backup
├── Documentation
├── README Images
├── SQL Scripts
│   ├── 01_Create_Database.sql
│   ├── 02_Create_Tables.sql
│   ├── 03_Insert_Data.sql
│   ├── 04_SELECT.sql
│   ├── 05_DISTINCT.sql
│   ├── 06_WHERE.sql
│   ├── 07_ORDER_BY.sql
│   ├── 08_TOP.sql
│   ├── 09_FUNCTIONS.sql
│   ├── 10_GROUP_BY.sql
│   └── 11_HAVING.sql
│
└── README.md

---

Database Tables

• Departments
• Employees
• Projects
• EmployeeProjects

---

How to Run

1. Open SQL Server Management Studio (SSMS).
2. Execute 01_Create_Database.sql.
3. Execute 02_Create_Tables.sql.
4. Execute 03_Insert_Data.sql.
5. Execute the remaining SQL scripts in sequence.
6. View the output in SSMS.

---

Project Screenshots

The project screenshots are available in the README Images folder.

---

Learning Outcomes

Through this project, I learned:

• Database Creation
• Table Design
• Data Insertion
• Data Retrieval
• Filtering Records
• Sorting Data
• Aggregate Functions
• SQL String Functions
• Data Formatting
• GROUP BY
• HAVING
• Writing Business-Oriented SQL Queries

---

Author

Pushkar Negi

Aspiring Data Engineer

Built using Microsoft SQL Server (SSMS), SQL, Visual Studio Code, and GitHub.