Views (Virtual Tables) in SQL
In this tutorial, you will learn what views are, the different
types available, and the pros and cons of using them.
Database Administrator and Database Users will face two challenges: writing
complex SQL queries and securing database access. Sometimes SQL queries
become more complicated due to the use of multiple joins, subqueries,
and$GROUP BY$in a single query. To simplify such queries, you can use
some proxy over the original table. Also, Sometimes from the security side,
the database administrator wants to restrict direct access to the database. For
example, if a table contains various columns but the user only needs 3
columns of data in such case DBA will create a virtual table of 3 columns.
For both purposes, you can use the view. Views can act as a proxy or virtual
table. Views reduce the complexity of SQL queries and provide secure access
to underlying tables.
In this tutorial, you are going to cover the following topics:
What is View?
Types of Views
Simple View
Complex View
Inline View
Materialized View
Difference Between View and Materialized View
