Project: Build a Student Tracker
Explore how to build a functional student tracker database by creating tables, inserting data, querying records, filtering grades, calculating averages, and managing updates and deletions. This lesson guides you through hands-on SQL practice to confidently organize and analyze student information.
You’ve created, inserted, updated, and designed tables. Now it’s time to build a real database app—a student grade tracker.
Goal
You’ll aim to:
Create a real table.
Insert real data.
Query and update it with confidence.
What will you do?
In this project, you’ll:
Create a student table.
Add students’ data.
View and explore the records.
Filter and analyze student grades.
Update a student’s record. ...