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