SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2

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.

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:
   • SQL JOINS Tutorial for beginners | Pr...  

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

Join my Discord Server:   / discord  

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
Registration Link: https://www.lighthall.co/class/305d73...

Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: https://www.lighthall.co/class/185a13...

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:
1) Go to https://www.lighthall.co/
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 - 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