Delete Course Schedule View Data

Beginner

In this project, you will learn how to create a view based on the `teaches` table and delete the related data from the view.

SQLMySQL

Introduction

In this project, you will learn how to create a view based on the teaches table and delete the related data from the view.

👀 Preview

MySQL [edusys]> SELECT * FROM teaches_view;
+-------+----------+----------+------+
| id    | courseId | semester | year |
+-------+----------+----------+------+
| 76766 | BIO-101  | Summer   | 2017 |
| 10101 | CS-101   | Fall     | 2017 |
| 83821 | CS-190   | Spring   | 2017 |
| 83821 | CS-190   | Spring   | 2017 |
| 10101 | CS-347   | Fall     | 2017 |
| 98345 | EE-181   | Spring   | 2017 |
| 22222 | PHY-101  | Fall     | 2017 |
+-------+----------+----------+------+
7 rows in set (0.000 sec)

🎯 Tasks

In this project, you will learn:

  • How to create a view with specific fields from the teaches table
  • How to delete data from the created view based on a certain condition

🏆 Achievements

After completing this project, you will be able to:

  • Understand the concept of a view and how to create one
  • Manipulate data in a view by deleting records that match a specific condition
  • Apply these skills to manage data in a database more efficiently

Teacher

labby

Labby

Labby is the LabEx teacher.