Databases Intermediate

What is View?

A virtual table defined by a SQL query that provides a simplified or restricted view of data from one or more tables.

Views act as saved queries that can be referenced like tables. They simplify complex queries, restrict data access (showing only certain columns), and provide a stable interface even when underlying tables change.

Regular views execute the query each time they are accessed. Materialized views (PostgreSQL) store the result physically and must be refreshed, offering faster reads for complex aggregations at the cost of data freshness.

Learn More About This Topic

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

ORM (Object-Relational Mapping)

A technique that lets you interact with a database using object-oriented code instead of writing raw SQL queries.

ETL (Extract, Transform, Load)

A data pipeline process that extracts data from sources, transforms it into a suitable format, and loads it into a destination system.

Row-Level Security (RLS)

A database feature that restricts which rows a user can access in a table based on security policies.

A centralized repository optimized for analytical queries that integrates data from multiple operational sources.

A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.

A set of four properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.

View All Databases Terms →