What is a database view and why do we use it?

A view is a virtual table created by querying data from one or more tables. It does not store

data itself but presents it in a specific format.

Use cases:

• Simplify complex queries: A view can encapsulate complex queries for easier

reuse.

• Data security: Views can restrict access to certain columns or rows for users without

giving them full table access.