Creating a View

In this lesson we will learn about three different ways of creating views.

We'll cover the following

Creating a View

Views are virtual tables that are created as a result of a SELECT query. They offer a number of advantages such as showing only a subset of data that is meaningful to users or restricting the number of rows and columns shown for security reasons. A view containing columns from multiple tables can simplify queries by changing a multi-table query to a single-table query against a view. Views are stored in the database along with tables.

A view can be created from a single table, by joining two tables, or from another view.

Level up your interview prep. Join Educative to access 70+ hands-on prep courses.