# 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
Click the virtual machine below to start practicing