📊 Student Performance SQL Analysis

A beginner-friendly SQL portfolio project that analyzes student performance data using MySQL. This project demonstrates essential SQL concepts through data cleaning, querying, aggregation, filtering, CRUD operations, and generating meaningful insights from a real-world dataset.

---

📌 Project Overview

This project explores a dataset containing student academic performance and demographic information. Using SQL, the data is cleaned, analyzed, and summarized to answer business-related questions and uncover trends in student performance.

This project was built to strengthen SQL fundamentals and showcase practical data analysis skills for a Data Analyst portfolio.

---

📂 Dataset

• Source: Student Performance Dataset (CSV) from KAGGLE
• Total Records: 1,000
• Database: MySQL

Dataset Columns

• Gender
• Race/Ethnicity
• Parental Level of Education
• Lunch
• Test Preparation Course
• Math Score
• Reading Score
• Writing Score

---

🛠 Tools Used

• MySQL Community Server
• MySQL Workbench
• Git
• GitHub

---

💡 SQL Concepts Demonstrated

Database & Table Management

• CREATE DATABASE
• CREATE TABLE
• ALTER TABLE

CRUD Operations

• INSERT
• UPDATE
• DELETE
• SELECT

Filtering & Searching

• WHERE
• BETWEEN
• IN
• LIKE
• AND
• OR
• NOT

Data Analysis

• DISTINCT
• GROUP BY
• ORDER BY
• HAVING

Aggregate Functions

• COUNT()
• AVG()
• MAX()
• MIN()

---

🧹 Data Cleaning

The dataset was cleaned before analysis by:

• Renaming the table
• Renaming columns for readability
• Standardizing parental education values
• Standardizing meal type values
• Improving consistency in categorical data

---

📈 Business Questions Answered

• How many male and female students are there?
• What are the average scores by gender?
• How many students completed the test preparation course?
• What is the distribution of meal types?
• What is the distribution of parental education levels?
• Which race/ethnicity group has the most students?
• Which students achieved full marks?
• Which students scored below passing marks?
• What are the highest and lowest scores in each subject?

---

📊 Key Insights

• Total Students: 1,000
• Female Students: 518
• Male Students: 482
• Most students did not complete the test preparation course.
• Male students achieved a higher average Math score.
• Female students performed better in Reading and Writing.
• Group C had the highest number of students.
• High School Graduate was the most common parental education level.
• Most students received the Standard meal.

---

📁 Project Structure

student-performance-sql-analysis/
│
├── Dataset/
│   └── StudentsPerformance.csv
│
├── SQL/
│   └── Student_Performance_Project.sql
│
├── Screenshots/
│   ├── 01_import.png
│   ├── 02_table_data.png
│   ├── 03_average_scores.png
│   ├── 04_groupby.png
│   ├── 05_data_cleaning.png
│   └── 06_summary.png
│
├── README.md
├── LICENSE
└── .gitignore

---

🚀 How to Run the Project

1. Open MySQL Workbench.
2. Create a new database.
3. Import the StudentsPerformance.csv dataset.
4. Open Student_Performance_Project.sql.
5. Execute the SQL queries.
6. Review the outputs and insights.

---

👩‍💻 Author

Eshrath Jahan

Aspiring Data Analyst passionate about SQL, Python, Power BI, data visualization, and machine learning.

• LinkedIn: https://www.linkedin.com/in/eshrath-jahan-463465336/

---

⭐ If you found this project helpful, feel free to star the repository!