Skip to content

barlox/project_sql_course

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

Project SQL Course

Build a SQL database for a university that manages students, courses, professors, and grades.

Technical Requirements

Build a database with the following tables: Students, Courses, Professors, Grades

Foreign key relationships between the tables

Create DB & Tables

Create a script that populates all of the database tables with sample data

Populating Tables

SQL query scripts for:

The average grade that is given by each professor

Average Grade

The top grades for each student

Top Grades

Sort students by the courses that they are enrolled in

Sort students

Create a summary report of courses and their average grades, sorted by the most challenging course (course with the lowest average grade) to the easiest course

Summary report

Finding which student and professor have the most courses in common

Common courses

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published