This is the SQL JOINS Tutorial for complete beginners. This is the second part of the series. In this video we shall cover FULL OUTER Join, CROSS Join, NATURAL Join and SELF Join. In the first part of this video series, I had covered INNER Join, LEFT join and RIGHT Join.
If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
I start this video by discussing about FULL OUTER Join. But in order to understand FULL OUTER Join, we need to first look at the difference in output from INNER, LEFT and RIGHT JOIN. So we go through the difference in these 3 joins first and then I explain the concept of FULL OUTER Join.
We then cover CROSS join and I explain a scenario where you may need to use CROSS join.
We then talk about NATURAL join. I'll tell you the difference between NATURAL join and INNER join and also tell you why you should not be using NATURAL Join.
Finally, we cover one of the most important JOINS in SQL which is the SELF JOIN. I explain SELF join by taking a real world example.
Every concept is explained by writing SQL queries so hopefully this video along with the first part of this video, should help you to completely understand JOINS in SQL.
Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries.
Timeline:
00:00 Intro
00:54 FULL OUTER JOIN in SQL
10:20 CROSS JOIN in SQL
16:44 NATURAL JOIN in SQL
21:51 SELF JOIN in SQL
Watch the first part of this SQL JOINS Tutorial Series:
Join my FREE live SQL training session:
Batch 1 - Started on 03-Jan-2022 (08:00 pm Malaysian Time / 05:30 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Note: Both batch 1 and batch 2 will cover the exact same topics. Just the date and time are different based on the convenience of everyone.
How to Join the sessions:
2) Click the subject "Data Science"
3) Find my session and click on it. The sessions will automatically start 4 mins prior to the scheduled time.
Please do subscribe and like this video if you found it useful.
🔴 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