SQL Project Overview:

This project involves creating a database for managing student courses. The database will have tables for students, courses, enrollments, and instructors.

Basic Queries

Selecting all the students.

Selecting all the courses.

Selecting all enrollments with student names and course names.

Advanced Queries

Selecting students who enrolled in a specific course.

Selecting courses with more than 3 students.

Updating a student's email.

Calculating the average age of students.

Finding the course with the maximum enrollments.

Listing courses along with the number of students enrolled (use GROUP BY).

Join Queries

Selecting all students with their enrolled courses (using JOIN).

Listing all instructors and their courses.

Subqueries and Set Operations

Selecting students enrolled in more than one course.

Finding courses taught by a specific instructor.

Selecting the top 3 students with the most enrollments.

Using UNION to combine results of two different SELECT queries.

Aggregate Functions and Grouping

Calculating the total number of students.

Calculating the average, minimum, and maximum number of enrollments per course.

Additional Tasks

Creating aliases for complex column names.

Using CASE to categorize students based on their age.