SQL Views Tutorial | VIEWS in SQL Complete Tutorial
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=thoufiqmohammed
[All the scripts and SQL queries used in this video is shared in my Discord server.]
Join my Discord Server: https://discord.gg/8aRSbygbdu
FTC disclaimer: This video was sponsored by Skillshare.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео SQL Views Tutorial | VIEWS in SQL Complete Tutorial канала techTFQ
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=thoufiqmohammed
[All the scripts and SQL queries used in this video is shared in my Discord server.]
Join my Discord Server: https://discord.gg/8aRSbygbdu
FTC disclaimer: This video was sponsored by Skillshare.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео SQL Views Tutorial | VIEWS in SQL Complete Tutorial канала techTFQ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![WHILE loop and FOR loop in Python | LOOP statements in Python | Python Tutorial for Beginners #4](https://i.ytimg.com/vi/2gFqUWO-AWM/default.jpg)
![What is a FUNCTION in Python | Python Functions | Python Tutorial for Beginners #6](https://i.ytimg.com/vi/UzOnFDmoJ9w/default.jpg)
![Dictionary in Python (for beginners) | Python Dictionaries | Python Tutorial #10](https://i.ytimg.com/vi/35dXEQJkFE8/default.jpg)
![What is Data Science (for beginners) | Data Science for Beginners | Data Science Life Cycle](https://i.ytimg.com/vi/0wjPsKDrYt8/default.jpg)
![IPL Winning Streak - SQL Interview Query 22 | SQL Problem Level "HARD"](https://i.ytimg.com/vi/xY2622VV7jM/default.jpg)
![Count Employees - SQL Interview Query 13 | SQL Problem Level "EASY"](https://i.ytimg.com/vi/78DNY36XxQw/default.jpg)
![Employee Attendance - SQL Interview Query 18 | SQL Problem Level "MEDIUM"](https://i.ytimg.com/vi/Oz8uzN_7MuM/default.jpg)
![Super Interesting SQL Problem | Practice SQL Queries](https://i.ytimg.com/vi/4Z67GTTWuzc/default.jpg)
![Python Bootcamp for Beginners | Python Course | Live Training](https://i.ytimg.com/vi/PLN28d0PoFU/default.jpg)
![SQL Project | SQL Case Study to SOLVE and PRACTICE SQL Queries | 20+ SQL Problems](https://i.ytimg.com/vi/AZ29DXaJ1Ts/default.jpg)
![Merge Products - SQL Interview Query 9 | SQL Problem Level "EASY"](https://i.ytimg.com/vi/o5W-iAK21ws/default.jpg)
![STEP by STEP guide to Learn Python | How to learn PYTHON](https://i.ytimg.com/vi/PuBadaR8qC4/default.jpg)
![Data Analyst Interview Problem - SQL Interview Query 25 | SQL Problem Level "EASY"](https://i.ytimg.com/vi/vyTMJhHyEtg/default.jpg)
![SQL Interview Problem asked by Product Based Company | Solving SQL Interview Query](https://i.ytimg.com/vi/90iK6gGvG_g/default.jpg)
![Split Hierarchy - SQL Interview Query 12 | SQL Problem Level "HARD"](https://i.ytimg.com/vi/KrUIQAcFptY/default.jpg)
![Job Interview Tips | Follow these steps to clear JOB INTERVIEWS | How to clear Job Interviews?](https://i.ytimg.com/vi/tY4POdOldQM/default.jpg)
![How to Read and Write Files in Python | File Handling Tutorial in Python](https://i.ytimg.com/vi/Jsnw6HLASZA/default.jpg)
![Solving an INTERMEDIATE SQL Interview Query - 29 | #30DaySQLQueryChallenge](https://i.ytimg.com/vi/cdTzo1eZZ50/default.jpg)
![Solving SQL Interview Query | Find Tree Node type using SQL](https://i.ytimg.com/vi/zZKb8FQRShs/default.jpg)
![Solving SQL Interview Problem with MULTIPLE solutions | Practice SQL Queries](https://i.ytimg.com/vi/J_da4WKsrjE/default.jpg)
![SQL Data Analytics Project (PART 3) | Data Analyst Portfolio Project](https://i.ytimg.com/vi/GxmrInUIMAE/default.jpg)