Views

Summary

Saved, reusable SQL queries that behave like virtual tables — useful for simplifying complex joins or restricting what columns/rows certain users can see.

• 1Create a view that joins a few tables into a simplified, reusable query.
• 2Learn the difference between a regular view and a materialized view.
• 3Understand that views don't store data themselves — they run the underlying query each time.