🎓 Student Enrollment Database

This SQL project designs and manages a student enrollment system, handling student records, course details, and enrollment history. It includes data insertion, updates, deletions, queries, and analytics to extract valuable insights from academic data.

📌 Project Workflow

1️⃣ Database & Tables Creation

• Students – Stores student details (ID, name, DOB, email, enrollment date).
• Courses – Stores course details (ID, name, department, credits).
• Enrollments – Tracks student-course enrollments, grades, and semesters.

2️⃣ Data Insertion

• Populated tables with sample student, course, and enrollment data.

3️⃣ Data Manipulation

• Updating Student Info – Modified email records.
• Deleting Records – Removed students based on conditions.

4️⃣ Data Retrieval & Analysis

• Student Queries

  • Retrieve student details, count, and enrollment dates.
  • List students with no enrollments.
  • Sort students by enrollment date.

• Course Queries

  • Fetch course details, total credits per department.
  • Find courses with no enrollments.
  • Get the most popular courses based on enrollments.

• Enrollment & Performance Queries

  • Join student and course tables to get detailed enrollment info.
  • Calculate GPA based on grading scale.
  • Find top-performing students and courses.
  • Analyze semester-wise enrollments.

🛠 Tools & Technologies Used

• Microsoft SQL Server
• SQL (DDL, DML, Joins, Aggregations, CTEs, Views)

📊 Key Insights

✅ Which students have the highest number of enrollments?
✅ What is the average GPA for each course?
✅ Which department offers the most credit hours?
✅ What are the most enrolled courses per semester?

This project efficiently manages academic records and provides actionable insights for student and course performance! 🚀