Skip to content
SQL Education
Overview
Expand
Overview
1 Topic
SQL Tables
Part 1 — Introduction: Education Data Foundations
Understanding Education Administration Tables
Student-Level vs. Course-Level vs. Section-Level vs. Program-Level vs. Payment-Level Data
How Academic, Enrollment, Attendance, Advising, and Tuition Systems Store Data
Key Education Fields
The Flow of Education Data
How Education Data Connects Across Tables
Capstone
Expand
Capstone
1 Topic
Part -1 Capstone Project
Part 2 – Intermediate: Education SQL Queries
Retrieving Student, Course, Section, Instructor, and Enrollment Data Using SELECT
Filtering Academic and Administrative Records with WHERE Conditions
Joining Students, Programs, Departments, Courses, Sections, Terms, and Instructors
Analyzing Enrollments, Class Rosters, Course Offerings, and Teaching Assignments
Aggregating Academic and Administrative Metrics Using GROUP BY and HAVING
Identifying Active Students, Full Sections, Multi-Course Enrollments, and Instructor Teaching Loads
Capstone
Collapse
Capstone
1 Topic
Part -2 Capstone Project
Part 3 – Advanced: Education Analytics & Reporting
Student Performance Analysis Using Grades and Final Outcomes
Attendance and Student Engagement Analysis
Tuition, Payment, and Outstanding Balance Reporting
Advising and Student Support Activity Analysis
Program and Department Performance Reporting
1 of 2
Previous Lesson
Capstone
SQL Education
Capstone
Lesson Content
0% Complete
0/1 Steps
Part -2 Capstone Project
Previous Lesson
Back to Course
Cancel Preloader
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Are you human? Please solve:
