Views
Hands-on tutorial
01 / THE CONCEPT
Understand the idea
In this lesson, explore views. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.
02 / SQL EXAMPLE
◉ example.sqlSQL
CREATE VIEW top_students AS SELECT name,score FROM students WHERE score>=85;Try in SQL Lab ↗03 / KNOWLEDGE CHECK
Check your understanding
Which statement best describes views?