View

Medium — good to knowDatabase

ELI5 — The Vibe Check

A view is a saved query that looks and acts like a table. You write a complex SELECT once, save it as a view, and then just SELECT from the view like it is a real table. No data is duplicated — it is just a named shortcut.

Real Talk

A view is a virtual table defined by a stored SELECT statement. It does not store data itself (unless it is a materialized view). Views simplify complex queries, enforce column-level security, and provide a stable interface even when the underlying table structure changes.

Show Me The Code

CREATE VIEW active_users AS
  SELECT id, name, email
  FROM users
  WHERE active = true;

-- Now use it like a table:
SELECT * FROM active_users;

When You'll Hear This

"Create a view to encapsulate the complex join so other queries can use it simply." / "Views are great for access control — expose only what users need to see."

Related Terms

Normalization

Normalization is the process of organizing your database to reduce data duplication.

intermediateDatabase

SELECT

SELECT is how you ask a database to give you data. It is the 'Read' in CRUD.

beginnerDatabase

Stored Procedure

A stored procedure is a named program you write in SQL (and sometimes a procedural language) that lives inside the database.

advancedDatabase

Table

A database table is exactly like a spreadsheet tab. It has columns across the top (name, email, age) and rows going down (one per person).

beginnerDatabase

Back to Browse Random Term