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