Project: Build a Student Tracker
Explore how to build a student tracker database by creating a table, inserting real student data, querying records, filtering grades, calculating averages, updating entries, and deleting records. This hands-on project helps you confidently manage and analyze data using fundamental SQL commands.
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. ...