SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2
HTML-код
- Опубликовано: 25 июл 2024
- 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...
My recommended SQL Course: 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: 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: 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 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 c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq
After 5 centuries i finnaly understand what Cross Joins are. You deserve a Cookie!
Then he need to subscribe to Mr.beast 😂
Never understood SQL joins as much as I did with this video. Thoufiq, your teaching ability is beyond comparison. Great work.
right ....super se uper💯❤💥💥💥💥
I can't believe I'm paying college fees with profs that can't even teach this well...
😁 I am glad this video helped
TOUFIK you did a fantastic job simplifying SQL joins! I used to find them confusing, but his explanations really made it clear. Great job and very understandable!
How can you be so good at teaching? this is amazing...salute to people like you who provide such valuable contents for free
I struggled with the self join especially when I had to write the condition. You made it crystal clear to me. Thank you so much
Best explanations of JOINS in RUclips. Hands down!
Thank you bro 🙏🏼
Excellent SQL Joins videos- Highly Recommended to watch it!
I am really thankful to you for all the SQL related videos on your channel. Since the day I have been watching your videos, I can see lot of improvement in my learning.
Once you start watching his videos. There's no going back seriously. This guy is the OG!
Great teaching thank you sir....I'm continuously fallowing your SQL videos..
Your welcome 🙏🏼
I am glad you have liked my contents
I'm also
You are a really good teacher. It is clear you spent a lot of time planning, writing, and editing these videos. Thank you!!
Your way of explaining the concepts is very clear and easily understandable. The other best thing is that you explain the use cases that other videos lack. Good work Thoufiq.
Thank you so much Damini ☺️🙏🏼
Keep posting different difficult concepts in SQL.
No need to think of joins again after watching ur videos
Thank you Varshith .. glad you liked it
The way you explain I will never confused between any join …. Perfect explanation I have never get from any tutorial.. simple explanation not confusion♥️ all the best 👏
Thank you so much for this. I have been able to comprehend JOINS easily because of your well-explained videos.
The best tutorial out of all the tutorials present there on RUclips.
The best lecture on sql joins i've got so far!!
Mate, I've viewed multiple videos explaining self-joins and yours is the one that pieced it together for me. Kudos to you - keep up the amazing content!
Damn true bro. Self-join demo is outstandingggg!
💌
I've watched multiple videos on joins before, but this is the last video I'm watching as from today onwards all my concepts on joins will be crystal clear.
Thankyou Thoufiq ♥️
Super glad to know that Adeeba 🙏🏼☺️
It's the first time I've ever understood sql joins so well, جزاك الله خيرًا, "بارك الله فيك thoufeek
true
That's great explanation, I was always vague about joins until I watched this video. Thank you so much!
The best explanation for SQL JOINS.
Was doing a Udemy course, learned join section there but wasn't cleared of all doubts. After watching your videos, cleared of all. Thank you!!
Great content, so clear and with great examples! Thank you very much!
thank you so much sir! I was also thinking like cross join is a useless thing, but today i realised its importance
"Clear and concise video tutorial - a perfect guide for mastering [SQL]. Highly recommended!" Thanks a lot Thaufiq🙏
You truly are a brilliant teacher. Thank you.
best video on joins tutorial...maza aagya sir ..pata hi ni chala kb video khatam ho gyi👌👌
very good video to understand joins both parts 10 on 10 sir
I have never understood self join. Thank you very much Sir for the simplified explanation.
Mashallah perfect. These 2 videos are brilliant with excellent explanation
Thank You Brother... First person who taught the joins so clearly.
Thanks a lot
One of the best sql join video ever i watched 💥
I've been training myself to get into a business analyst role and trust me without a doubt, your videos are just so relevant and important. Would love to connect over linkedin. Thanks!
Thank you so much ☺️
hey bro any update on your business analyst journey? i too am preparing for it!
Awesome presentation, among all the videos that I searched in entire RUclips this is the best video i found on joins. Anyways I decided to watch all your playlist to improve my database skills. Plz keep doing more videos dude.
Awesome tutorial on SQL joins. Thanks a lot sir.
I understood the 1st part very well and now watching 2nd. Thank you very much for helping.
bro you are really a magician ..like loved that video sm never understood like this before
you made this so easy to understand! thank you once again!!
I feel I am at the right place thoufiq , thanks for investing your valuable time for us
Wow! mind-blowing explanation Taufiq. Self join demo is outstanding. You are genius man.....!
I enjoyed the previous video and i'm now enjoying this one too.
Explanation with same example in simple language. Very helpful for understanding basics on joins.
Thank you 😊
BEST SQL VIDEOS EVER!!!! TRUST ME GUYS, THESE VIDEOS ARE JUST SOMETHING WHICH FEELS ILLEGAL TO BE FREE!!!!! LOTS OF LOVE SIR.....THANK YOU SO MUCH.........#aspiringDataEngineer
I never understood self join but from this video its cleared.Thanks
very good explaination part ...thank you so much
I rarely comment because I am so lazy but your teaching skills forced me to write something for you as an appreciation you are a great teacher . so simple and straight Thankyou so much. Preparing for Data Analyst Role wish me luck!!!
Made the concept very clear. Loved the way you explain everything
After watching a lot of videos on Joins, finally I have got a best, Simpler and outstanding one.. No doubt at all.. I am feeling very Happy today Alhamdulillah as I got the confidence on Joins concept. Thank You Thoufiq.. Jazakallahu khair.. !!!
you are rocking by way of explaniation, Even i had a lot of stuck in understanding join before watch this one.Great job Mr.
absolutely loved it !! thanks for sharing
The tremendous job bro...the jet speed of understanding directly landing into our brains..tq so much
Hi mate, thanks for the great video. Also to make sure, since both employee and manager table share two same columns(dept_id, manager_id), I would appreciate if you could show how it works on natural join if the query was to display employee names, and their managers.
No one can explain in such way that sql concept thanks sir sharing with us valuable content 😊
Thank you so much sir...its amazing to learn SQL from ur channel☺
thank you brother! i love it the way your explaining
Part 1 explanation was awesome.going for part two.❤️
AWSOME VIDEO
My goodness, this tutorial is priceless!
Thankyou for the efforts! Loved the Join Series surely sharing it on all my groups and communities, perfect for beginners and even people who want to revise!
Thank you Vipul ..
Glad you liked it and happy to know you would share it with others 🙏🏼☺️
Can't thank you enough! A great resource to learn, keep posting:)
Can you also teach how NULLs are treated in joins?
Thank you :)
as for NULLS in JOINS, will probably make another video about it since many have asked it
one of the best explanation so far this guy deserves a bow❤❤ love from ireland
Thoufiq, I really appreciate your videos. The explanations are great.
Thank you Ryan 🙏🏼
Thank you very much sir !, your SQL content is amazing
Thankkk u soo muchh . finally someone teaches it so perfectly
This the best You Toube series to learn sql.. Thank You for the efforts..!!!
Thanks for bringing full clarity on joins with your amazing explanation. It would be great to have a lecture on Subqueries. Thank you.
Thank you 🙏🏼 glad you liked it.
Subqueries video is coming in about an hour..
Just uploading it now ..
I hope you like that one too
Tofig, you are rocking it bro! Deep and clear explanation.
Thank you sir.
Glad you liked it buddy 🙏🏼
Wait is over.. first JOIN video was awesome 👌
I hope you will like this one too ☺️
What an explanation!! This helped me alot. Thankyou.
this is great stuff my dude. thank you
Thank You so much, very helpful , you know how to simplify things.
Toufiq sir, your teaching is great thanks a lot...I cant stop myself from not hitting the like button after the video.
Your trainings are awesome... Thanks lot... For the knowledge sharing...
Thanks for the second part Thoufiq. Its clear and i learned a lot from your online live sessions.Guys these are really helpfull for who are trying to learn SQL from scratch. I strongly recomended his second batch live sessions will start on 17th JAN 2020.Try to register before its free of cost.🥺👍🏻. THANK YOU.
Your welcome Manoj ..
I am glad you liked my live sessions too 🙏🏼🙏🏼
I can't appreciate you enough for making your videos so easy to understand, thank you Thoufiq.
Your welcome Bro
Glad you like them
Best Video Watched For SQL Joins 🤩🤩🤩
Hi Thoufiq,
Seriously You are the best , I completely understood the topic where did not get them from the college itself. Thank you so much.
That was awsome, ...simple outstanding explanation brother...Thanks aton...respect from Blr...INDIA.
You're an amazing teacher! I've taken courses on Coursera from big companies like IBM and Google, but your explanation of database joins is by far the best. The way you break down the different types of joins makes it so easy to understand. Thank you! Sending lots of love from Pakistan.
Thank you So Much For Explaining Each & Every Topic Of Join In Deep ❤️
iam starting my career into data analyze your vidoes is really help lot
Mind blowing bro the way you teach is awesome wish i could have find you sooner Thanku
I am glad I found your video. I was struggling in joins so much- now feels like i am a pro
glad it helped
Amazing Series!! Please keep continuing to post all the topics. Thank you Thoufiq!!
Thank you Gautam, I will
Thank you very much. Amazing explanation with examples. 😀👌
I very rarely make comment's on any videos but today, I felt like if, I wouldn't like or subscribe to you that you be injustice to this wonderful and very simplified explanation.
I truly appreciate it , glad to know you liked it
Thanks for making this kind of videos. You are just clearing all our doubts sir 🙏🏼🙏🏼
Your welcome Amit
Great to learn from u
Thank you maaan! Help me a lot. Wth love from Azerbaijan
value for time content... Amazing teaching skills.... Thank u so much sir.....
Very lucid explanation. Thank you!
The way you explained is excellent. Very much understandable you lecture
Excellent ,outstanding :) keep up the good work sir
perfect information delivery. Thank you very much
Explained in very simple words, there is nothing that i didn't understand. Keep it up!!!
Simple and straight forward
Simply great
thank you so much TFQ ji .excellent explanation