Creating Database Views in MySQL

Introduction

In this project, you will learn how to create a database view based on the student table in the edusys database. The view will include the ID, name, and dept_name columns from the student table, providing a simplified and focused view of the student data.

👀 Preview

MySQL [edusys]> DESC student_view;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| ID         | int(11)     | NO   |     | NULL    |       |
| name       | varchar(20) | NO   |     | NULL    |       |
| dept_name  | varchar(20) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.002 sec)

🎯 Tasks

In this project, you will learn:

• How to start the MySQL server and log into the MySQL terminal
• How to import data from an SQL script into the MySQL database
• How to create a database view using the CREATE VIEW statement
• How to verify the structure of the created view using the DESC statement

🏆 Achievements

After completing this project, you will be able to:

• Understand the process of setting up a MySQL database environment
• Create custom database views to simplify data access and presentation
• Apply SQL statements to manage and manipulate database objects