The first 1,000 people to use this link will get a 1 month free trial of Skillshare: https://skl.sh/techtfq02221

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: https://stratascratch.com/?via=techTFQ

My recommended SQL Course: https://learnsql.com/?ref=thoufiqmoha...

[All the scripts and SQL queries used in this video is shared in my Discord server.]
Join my Discord Server:   / discord  


FTC disclaimer: This video was sponsored by Skillshare.


🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:
   • SQL Tutorial - Basic concepts  

✅ SQL Tutorial - Intermediate concepts:
   • SQL Tutorial - Intermediate concepts  

✅ SQL Tutorial - Advance concepts:
   • SQL Tutorial - Advance concepts  

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries  

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Que...  

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries  

✅ Data Analytics Career guidance:
   • Data Analytics career and more  

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training  

✅ Python Tutorial:
   • Python Tutorial  

THANK YOU,
Thoufiq