The first 1,000 people to use this link will get a 1 month free trial of Skillshare: [ Ссылка ]
This is the SQL VIEWS Tutorial video, where I explain VIEWS in SQL in detail. We cover everything you need to know about SQL VIEWS and how to effectively use SQL Views.
The video starts by explaining what a View is and how different it is from a table. We then look at how to create a View and also explain in detail the purpose of using a view in sql. We talk about the advantages of views in sql and why we use views in SQL.
We then see how to create a view using CREATE OR REPLACE command and how different it is from just the CREATE VIEW command. I mention in detail all the rules you need to know when using CREATE OR REPLACE command.
We also see how to modify a View using the ALTER command.
I also mention some tips and tricks about Views that can be essential to clear interview questions related to Views.
At the end of the video we look at updatable views i.e. the views which can be updated or inserted or deleted. We look at the different rules we need to follow in order to create a view which can be updated.
Finally we talk about the WITH CHECK OPTION clause when creating a view. We understand why we use WITH CHECK OPTION clause and how is it useful in certain cases.
The only VIEW concept not covered in this video is about the Materialized View. I will be making a separate video about Materialized View very soon.
Hopefully this video should give you complete understanding about VIEWS and how to effectively use VIEWS in SQL.
If you liked this video and would like to learn more about SQL then make sure to Subscribe to my channel.
Practice SQL Queries here: [ Ссылка ]
My recommended SQL Course: [ Ссылка ]
[All the scripts and SQL queries used in this video is shared in my Discord server.]
Join my Discord Server: [ Ссылка ]
FTC disclaimer: This video was sponsored by Skillshare.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
[ Ссылка ]
✅ SQL Tutorial - Intermediate concepts:
[ Ссылка ]
✅ SQL Tutorial - Advance concepts:
[ Ссылка ]
✅ Practice Solving Basic SQL Queries:
[ Ссылка ]
✅ Practice Solving Intermediate SQL Queries:
[ Ссылка ]
✅ Practice Solving Complex SQL Queries:
[ Ссылка ]--
✅ Data Analytics Career guidance:
[ Ссылка ]
✅ SQL Course, SQL Training Platform Recommendations:
[ Ссылка ]
✅ Python Tutorial:
[ Ссылка ]
THANK YOU,
Thoufiq
