ImmersiveAmbientModecolor: #ead6c4 (color 1)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: 7fe86cf40e9676925047743383d5fa5a15368e72a3be566e520e93fb302c86142cdf6c9de72f59bc0e3d858a04074ca1
Proxy : eu-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1715915243133 - unknown on Apple WebKit
Mystery text : ME9RSkRkM1FxUU0gaSAgbG92ICB1IGV1LXByb3h5LnBva2V0dWJlLmZ1bg==
143 : true
857,911 Views ā¢ Jan 6, 2022 ā¢ Click to toggle off description
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: learnsql.com/?ref=thoufiqmohammed
Join my Discord Server: 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: www.lighthall.co/class/305d73cb-2381-4499-9088-54eā¦
Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: www.lighthall.co/class/185a13de-31a5-475a-abc3-b64ā¦
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 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,
Thouf
Views : 857,911
Genre: Education
Date of upload: Jan 6, 2022 ^^
Rating : 4.94 (299/19,539 LTDR)
RYD date created : 2022-04-09T16:01:48.985908Z
See in json
YouTube Comments - 1,144 Comments
Top Comments of this video!! :3
Teachers like you are so important to boost our confidence. Thanks a ton for making these videos, which are only helping us in flourishing our career. Loads of blessings
119 |
The last 10 mins of your video truly clarified issues I had with joining "multiple" tables--beyond the simple two we so many times in tutorials and online course. Thanks so much for taking the time to reinforce these concepts!
9 |
Hi Thoufiq, I am only halfway through and I just have to tell you that you were born to be a teacher. Truly. Even though Iāve now taken so many classes on LearnSQL (per your video recommending that resource, which I really appreciate), so that this is material I know, this is such a great explanation of these concepts. I think what I appreciate most about you is that you include everything I need to hear and nothing I do not need to hear. You donāt waste your time or the viewerās time with extraneous information. That is a very big deal on YouTube, where I come for information. I like to use my time well and you clearly keep this in mind when you put your videos together. This is my busy time now in my current job and so I wonāt be around as much, but Iām so happy to again see that your channel has grown now to over 30K subscribers. I think that the combination of your skills, experience and knowledge combined with your humble spirit will serve and are serving you well. I wish you all the best for 2022 and many thanks for all of your assistance with SQL. šš»š
129 |
the mvp of this video was the last join with 4 tables. exactly what i wanted to learn. the internet was filled with simple joins which never did justice to the concept of joins . industries will have 4-6 joins in a query and now i can visualize things way better. most helpful sql video seen all year. we must start small with learning but we must also learn complex stuff till it becomes useful in computer field
3 |
You have done an amazing job of breaking these joins down, step by step, and making it simple to understand the differences. Thank you for such a thorough explanation. My professor could learn a thing or two from you.
15 |
I watched your SQL basis, intermediate, advanced and interview question videos. You are giving your best to all those categories. Thanks you so much for your efforts bro. Really appreciate your help. š
5 |
Wow, I just have to say that your videos are some of the best I've ever seen! this sql joins video was absolutely fantastic - your explanations were clear and concise, and I was able to follow along with ease. I've watched a lot of videos on this topic before, but none of them have been as helpful as yours. Thank you so much for taking the time to create such high-quality content - it's truly appreciated!
28 |
This is how the content is delivered, how the teaching is done!
After going through a hell lot of tutorials on Joins, I can confidently say this is the explanation we beginners require!
Though One request I'd like to make. Could you please put the code of the tables you used in the tutorial. This will save our time, and we can focus more on practicing writing the queries itself.
Thanks a lot :)
91 |
I have not understood SQL JOINS more clearly than the way you taught me. Thank you! I appreciate what you do.
15 |
Trust my word. You are the only one so far who really made SQL JOIN easy .
1 |
The joins are much clearer now! Thank you for literally saving my life!!
1 |
Thank You very much sir!
Your SQL basic, intermediate and advanced all the series are really very helpful and it's totally understandable
You explain all the topics very well
As an aspiring data analyst I can say this tutorials āØš are helping me to achieve my goal
3 |
I went through so many videos to learn joins and finally I landed here. Thank you so much for this. Your exceptional way of teaching can make learning easy.
12 |
have been using sql for years now and watched tons of sql videos, nothing came close to this explanation. After years of using sql, I was still confused with joins, but this video did it.. Thanks for this man, keep it up.
|
This guy was born to do this. Your simple method of explanation and clear demonstration is apt. Am catching the vibes, enjoying the groove. Lets go there...
2 |
Glad I found this channel . You are doing a really great job man. Teaching is a skill which not everyone out there who is teaching have , but this man thoufiq , is a master at this.
8 |
Hi Thoufiq, browsing your videos could't agree more with others you are born a teacher, clear instructions I think your humbleness and the manner you teach is helpful to me and others. We are with you.
7 |
Thoufiq bhai I was not able to understand joins concept from one year, but after watching this video i got cleared my all queries, wonderful teaching really appreciated.
|
I can strongly say that no one can teach this content in such short duration .Thank you for the valuable content
4 |
@makemymarket1772
2 months ago
Left join = inner join + additional records in left table = best explanation I ever heard. Thanks!
63 |