Master the SQL SELECT statement part 09: VIEWS

This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers VIEWS. Views are part of the SQL data definition language. They allow us to permanently save a common table expression into the database catalog under a table. The view looks and acts just like a table, but it does not store any data; only providing a "view" of the underlying table data.

The video will demonstrate how to create and drop views, the advantage of using them and how to simplify complex query logic using them. We will also demonstrate that any common table expression can be saved as a view, and the data see by the view can even be updated provided the underlying table constraints remain intact.

The SQL code is available here: https://github.com/mafudge/learn-databases/tree/master/youtube

If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. https://youtu.be/CxCUrQ6knRo

This video is part of the textbook Applied Database Management https://applieddb.com

Here's the entire playlist: https://www.youtube.com/playlist?list=PLyRiRUsTyUXghCQTvsCeMjOCVjIIPsopR