MySQL 8 Using JOINS and VIEWS to Simplify and Secure Data Access.

Using Views in MySQL 8 both simplifies access to data, especially where JOINS are used but also helps secure access to data as we do not need to expose the table to users only the view. We can have several MySQL views pointing to the same table with only the correct users having access to the views the require.

See how to create SELECT statements using JOINS and store the statement within a Database View. Using this View or others views we do not need access to the underlying table and future security and select statement are more simple

00:00 Introduction
01:19 Command line
02:07 Understand USE and Database context
03:09 SELECT DATABASE()
03:37 DESCRIBE tablename
04:24 SELECT CONCAT() to concatenate fields together
06:24 Implement JOIN to display Manager Name
10:27 CREATE VIEW

-~-~~-~~~-~~-~-
Please watch: "RHCSA 9 Working With Podman Containers"
-~-~~-~~~-~~-~-

[MrYerak]

I do this every day and still watching

[gauravkalpasi]

Thanks for such informative video sir.