Creating and Updating Database Views

Introduction

In this project, you will learn how to create a student view in a MySQL database and update the data in the view.

👀 Preview

MySQL [edusys]> SELECT * FROM student WHERE ID = '70557';
+-------+---------+------+
| id    | name    | cred |
+-------+---------+------+
| 70557 | History |    0 |
+-------+---------+------+
1 row in set (0.001 sec)

🎯 Tasks

In this project, you will learn:

• How to create a view based on an existing table
• How to update the data in a view

🏆 Achievements

After completing this project, you will be able to:

• Understand the concept of a database view and how to create one
• Modify the data in a view using SQL update statements
• Apply these skills to manage and maintain data in a database