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 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

|
60 : 00

Click the virtual machine below to start practicing