Skip to content

apoorvds99/SQL_Student_Course_Management

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

SQL Student Course Management System

Overview

A SQL-based project designed to manage student course data and perform business-style queries to extract meaningful insights.

Objective

  • Manage student, course, and enrollment data
  • Perform analytical queries using SQL
  • Practice real-world database operations

Tools Used

  • SQL
  • MySQL

Key Operations

  • Joins between multiple tables
  • Aggregations and grouping
  • Subqueries and filtering
  • Business-style analytical queries

Key Insights

  • Student enrollment trends across courses
  • Course popularity based on registrations
  • Performance analysis using aggregated data

Files

  • SQL scripts for database creation
  • Query files for analysis
  • Excel file

Author

Apoorv Singh

About

A personal project simulating a university database system to manage students, courses, instructors, and grades using SQL.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors