From the course: SQL: Data Reporting and Analysis
Join today to access over 24,400 courses taught by industry experts.
Save your queries using a VIEW - SQL Tutorial
From the course: SQL: Data Reporting and Analysis
Save your queries using a VIEW
- [Instructor] In this section, we're going to look at views. The word view has a really specific meaning in the world of databases. A view is a stored query. If you look at the breadcrumb bar, we are at the database level in our hierarchy. And if you come to the navigation on the left and we close the table's hierarchy, you can see we have functions, procedures, and views as well as tables. And I should say, in this chapter where we look at these three things as well as variables, what follows relates just to MySQL. Views, functions, procedures and variables are dealt with quite differently on the different types of SQL, but the principles are the same. So, for MySQL, we're going to expand the hierarchy for views, and you can see, we have seven views stored already for us. You can create and save your own view, but we're going to look at the stored views that SeQuiLa offers us. So, to run a view, you can click on it.…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
