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: https://www.youtube.com/watch?v=0OQJDd3QqQM&t=1720s My recommended SQL Course: https://learnsql.com/?ref=thoufiqmohammed Join my Discord Server: https://discord.gg/8aRSbygbdu 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/305d73cb-2381-4499-9088-54e82a4de7b8/ 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/185a13de-31a5-475a-abc3-b64926c054dc/ 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: 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