Creating and Updating Database Views

Beginner

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

SQLMySQL

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

Teacher

labby

Labby

Labby is the LabEx teacher.