What is a view in a SQL database?

What is a view in a SQL database?

Approach: Define virtual table based on a query.

A virtual table based on the result-set of an SQL statement. It contains rows and columns just like a real table but does not store data physically.

Follow-up: What is a materialized view?

Key concepts: abstraction, security, read-only.