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