This is the SQL JOINS Tutorial for complete beginners. In this video we shall cover INNER Join, LEFT Join and RIGHT Join. I’ll be posting the second part of this video next week where we shall cover FULL OUTER Join, SELF Join, CROSS Join and NATURAL Join.
Before we talk about different types of Joins in SQL, we shall first understand what are JOINS and why do we need them and then finally write some SQL queries to understand how to use them. We shall practice writing SQL queries using inner, left and right joins in this video.
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
02:36 What are JOINS in SQL
05:30 Inner Joins in SQL
13:55 Left Join in SQL
19:59 Right Join in SQL
My recommended SQL Course: [ Ссылка ]
Join my Discord Server: [ Ссылка ]
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: [ Ссылка ]
Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: [ Ссылка ]
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 [ Ссылка ]
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
