Updating Student GPA in MySQL Database

Introduction

In this project, you will learn how to update a student's GPA (Grade Point Average) in a database using the UPDATE statement in SQL.

👀 Preview

MySQL [edusys]> SELECT * FROM student WHERE name = "Snow";
+-------+------+-----------+----------+
| ID    | name | dept_name | tot_cred |
+-------+------+-----------+----------+
| 70557 | Snow | Physics   |       61 |
+-------+------+-----------+----------+
1 row in set (0.000 sec)

🎯 Tasks

In this project, you will learn:

• How to start the MySQL server and log into the MySQL terminal
• How to import a database script into the MySQL database
• How to use the UPDATE statement to modify data in a table
• How to verify the updated data in the database

🏆 Achievements

After completing this project, you will be able to:

• Understand the basic SQL UPDATE statement and how to use it to modify data in a database
• Gain experience in working with MySQL, including starting the server, logging in, and executing SQL scripts
• Develop skills in database management and data manipulation