Could not understand Joins from my Professor and searched on TH-cam and randomly got this video. Trust me, its (Part 1 and Part 2) the best ever video made on this topic. Now, I understood completely. Thank you, instructor, for making this topic crystal clear. Would surely support you once I start earning.
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!!!
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!
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 ♥️
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!
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.
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.
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!
I have just signed up on the Learn SQL using your affiliate link, it has been great, but when it comes to Join it gets confusing, so coming to watch your tutorial here makes everything understandable now. I just wanted to say thank you so much for your teaching and we look forward to more videos from 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
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 👏
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.
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'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.
I thought there was something very wrong with me doing an SQL course on DataCamp and not understanding joins at all until I watched your videos and realised you just need someone who knows how to teach. I will be recommending your videos to everyone learning SQL.
Thank you so much sir I have never commented on any TH-cam channel. I just want to say you teaching skill is really good and I really understood what joins is all about thank you so much sir
Fantastic video! This is the most understandable and comprehensive explanation of SQL I've come across. The examples and step-by-step instructions made learning so much easier. Thank you for making such a great resource!
03:45 Covering full outer join, self join, cross join, and natural join in SQL 07:30 Left join fetches all records from the left table and matching records from the right table. 11:15 The different types of joins in SQL are inner join, left join, right join, and cross join. 15:00 Cross join matches every record from one table with every record from another table without a join condition. 18:45 Cross join is useful when you need to fetch records from a table that cannot be joined with any other table. 22:30 Natural join and inner join have certain differences 26:15 Self join is used to match records in the same table 29:58 Self join is a useful technique for joining a table to itself. Crafted by Merlin AI.
Just awesome...👌 I recently learn SQL but I had many confusion about joins.... Every thing is Crystal clear now Thank you sir !♥️ Keep uploading such tutorial.
Tomorrow is my SQL interview round and trust me my confidence level is so high that I am like "Doesn't matter what they are going to ask I am gonna explain everything in the same manner you did." I am sure I am gonna get that job. Bro you are amazing teacher. My father always says that when you start impacting other people lives you are doing something worthwhile. and you are impacting mine as well as millions. Great work.
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!
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.
you know whats the bet about you? its just not your explaning things but also the way you created the data to cover each and every topic. thanks taufeeq. May you always be blessed.
Thank you so much bro.. I am so glad you noticed it. I spend a lot of time coming up with these tables and data which can cover the things I want to cover.. happy to know you recognize it🙏🏼 And so glad you like my contents
Hey Thoufiq, thank you so much for the both videos on Join they are so much helpful and i really understood the concept now after watching both the videos. Thanks
I am so impressed with your teaching skills. You teach so well. I would like to watch more videos on complex database views and stored procedures.Thanks
After 5 centuries i finnaly understand what Cross Joins are. You deserve a Cookie!
Then he need to subscribe to Mr.beast 😂
Explain in single word dude
So you do have 5 centuries experience in SQL
Good for you
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💯❤💥💥💥💥
Once you start watching his videos. There's no going back seriously. This guy is the OG!
Best explanations of JOINS in TH-cam. Hands down!
Thank you bro 🙏🏼
Could not understand Joins from my Professor and searched on TH-cam and randomly got this video.
Trust me, its (Part 1 and Part 2) the best ever video made on this topic. Now, I understood completely.
Thank you, instructor, for making this topic crystal clear.
Would surely support you once I start earning.
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!!!
did you get placed?
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!
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 🙏🏼☺️
How can you be so good at teaching? this is amazing...salute to people like you who provide such valuable contents for free
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
After 10 years of my career, Now I understand the concepts behind Joins clearly. Thank you :)
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
explanation = 100%
efforts = 100%
content quality = 100%
our concept clear after watching this = 100%
thanks = 100%
Loved it bro.. thank you 🙏🏼
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!
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 ☺️🙏🏼
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
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!
💌
about 2 years back i ckeared my interview because of these two videos, no i'm preparing for another, thanks taufiq sir
I have just signed up on the Learn SQL using your affiliate link, it has been great, but when it comes to Join it gets confusing, so coming to watch your tutorial here makes everything understandable now. I just wanted to say thank you so much for your teaching and we look forward to more videos from you.
Thank you Juliana!
I am glad you liked the course and my contents :)
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
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!!
The best lecture on sql joins i've got so far!!
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 👏
I am glad I found your video. I was struggling in joins so much- now feels like i am a pro
glad it helped
Toufiq sir, your teaching is great thanks a lot...I cant stop myself from not hitting the like button after the video.
thank you so much sir! I was also thinking like cross join is a useless thing, but today i realised its importance
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.
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.. !!!
It's the first time I've ever understood sql joins so well, جزاك الله خيرًا, "بارك الله فيك thoufeek
true
Best tutorial on the concept of SQL joins.
I can't believe I'm paying college fees with profs that can't even teach this well...
😁 I am glad this video helped
Indian education system
Our education system is better than other countries..they don't even monitor students are listening to them or not @@pratibhagarg8398
Excellent SQL Joins videos- Highly Recommended to watch it!
one of the greatest sql joins tutorial all over the web .... awsome
Thank you 🙏🏼
I am glad you liked it
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.
I thought there was something very wrong with me doing an SQL course on DataCamp and not understanding joins at all until I watched your videos and realised you just need someone who knows how to teach. I will be recommending your videos to everyone learning SQL.
Thank you so much sir I have never commented on any TH-cam channel.
I just want to say you teaching skill is really good and I really understood what joins is all about thank you so much sir
Wow! mind-blowing explanation Taufiq. Self join demo is outstanding. You are genius man.....!
Wait is over.. first JOIN video was awesome 👌
I hope you will like this one too ☺️
Thank you. Best explained SELF JOIN . I have struggled with this for a long time. All of your videos are very well explained.
I am glad to hear that 🙏🏼
@@techTFQ Please make a video on Populating Null Values in a Table And Updating the table during data cleaning. Thank You.
Will consider this scenario during a future video
The tremendous job bro...the jet speed of understanding directly landing into our brains..tq so much
Best teacher for SQL.
Thank you Anas 🙏🏼
I have never understood self join. Thank you very much Sir for the simplified explanation.
Fantastic video! This is the most understandable and comprehensive explanation of SQL I've come across. The examples and step-by-step instructions made learning so much easier. Thank you for making such a great resource!
"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.
Thoufiq, I really appreciate your videos. The explanations are great.
Thank you Ryan 🙏🏼
best joins explanation on TH-cam. THANK YOU!
finally i found a clear explanation. thanks thoufig
I understood the 1st part very well and now watching 2nd. Thank you very much for helping.
Dude, I have bought a couple of Udemy courses for SQL... I find Your teaching method much more effective comparatively... Thanks a lot 😃
thanks Ninad
Do you have your videos in Udemy?
Nope I don’t
03:45 Covering full outer join, self join, cross join, and natural join in SQL
07:30 Left join fetches all records from the left table and matching records from the right table.
11:15 The different types of joins in SQL are inner join, left join, right join, and cross join.
15:00 Cross join matches every record from one table with every record from another table without a join condition.
18:45 Cross join is useful when you need to fetch records from a table that cannot be joined with any other table.
22:30 Natural join and inner join have certain differences
26:15 Self join is used to match records in the same table
29:58 Self join is a useful technique for joining a table to itself.
Crafted by Merlin AI.
I feel I am at the right place thoufiq , thanks for investing your valuable time for us
FINALLY, I UNDERSTOOD SELF JOINT !!!!!!!!!!!!!! THANKS A LOT !!!!!!!!!!!
Explained in very simple words, there is nothing that i didn't understand. Keep it up!!!
I can't appreciate you enough for making your videos so easy to understand, thank you Thoufiq.
Your welcome Bro
Glad you like them
That's great explanation, I was always vague about joins until I watched this video. Thank you so much!
You are a really good teacher. It is clear you spent a lot of time planning, writing, and editing these videos. Thank you!!
The best playlist for SQL💯
This is best video on joins in the whole TH-cam ... Nice work man
Glad you think so bro ☺️
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
Just awesome...👌
I recently learn SQL but I had many confusion about joins....
Every thing is Crystal clear now
Thank you sir !♥️
Keep uploading such tutorial.
Thank you Pankaj :)
So glad this helped you
best video on joins tutorial...maza aagya sir ..pata hi ni chala kb video khatam ho gyi👌👌
Thank you very much for the detailed teachings.....content is vey much clear and easy to understand ....
Thank you .. happy to know that
Tomorrow is my SQL interview round and trust me my confidence level is so high that I am like "Doesn't matter what they are going to ask I am gonna explain everything in the same manner you did." I am sure I am gonna get that job.
Bro you are amazing teacher.
My father always says that when you start impacting other people lives you are doing something worthwhile. and you are impacting mine as well as millions. Great work.
what happened ,how did u do??
@@151anirudhvyas8 Cracked Bro
@@hemalvarasada9192 great congrats bruh
The best explanation for SQL JOINS.
Really amazing....one of the most best platform in utube I ever seen
Thank you bro
You are my absolute favorite! You are my One-stop solution for SQL learning❤
Excellent Thoufig ... Great job. Your Explanation is awesome ...Thank you so much.
I am glad to hear that Dowlath
I never understood self join but from this video its cleared.Thanks
you are rocking by way of explaniation, Even i had a lot of stuck in understanding join before watch this one.Great job Mr.
Thank You Brother... First person who taught the joins so clearly.
Thanks a lot
Explanation with same example in simple language. Very helpful for understanding basics on joins.
Thank you 😊
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.
The best tutorial out of all the tutorials present there on TH-cam.
Wow never understood self join until this vedio thank you❤
Wow, this was an EXCELLENT explanation of Joins! Thanks for helping me better understand!
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 🙏🏼☺️
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 🙏🏼🙏🏼
Tofig, you are rocking it bro! Deep and clear explanation.
Thank you sir.
Glad you liked it buddy 🙏🏼
You are the first person I ever had to watch on 0.75x speed. Your normal speaking speed is 1.25. Great videos btw.
Mashallah perfect. These 2 videos are brilliant with excellent explanation
Keep doing such videos which will help students like us! Great work!
you know whats the bet about you? its just not your explaning things but also the way you created the data to cover each and every topic. thanks taufeeq. May you always be blessed.
Thank you so much bro..
I am so glad you noticed it.
I spend a lot of time coming up with these tables and data which can cover the things I want to cover.. happy to know you recognize it🙏🏼
And so glad you like my contents
Thank you so much sir...its amazing to learn SQL from ur channel☺
Wonderful! Thank you so much! You have just cured my headache!
I am glad to hear that ☺️
Thank you sir, I am preparing for my interview from your videos ❤❤
Your way of teaching is really good. May God bless you 🙏
Hey Thoufiq, thank you so much for the both videos on Join they are so much helpful and i really understood the concept now after watching both the videos. Thanks
I am glad to hear that Bro 🙏🏼☺️
That was awsome, ...simple outstanding explanation brother...Thanks aton...respect from Blr...INDIA.
This the best You Toube series to learn sql.. Thank You for the efforts..!!!
The way you are progressing, by May 2022 I see you getting 1 lac subscribers.
Thank you Pratham for the wishes and the support ☺️🙏🏼
Thank you so much for this. I have been able to comprehend JOINS easily because of your well-explained videos.
He deserves much more views and support.
Thank you bro
I am so impressed with your teaching skills. You teach so well. I would like to watch more videos on complex database views and stored procedures.Thanks
Your teaching style is truly exceptional and great one indeed. Keep going!
Thank you very much!
WOW . The join tricks is wonderful.
Cool 😎
guruji , really wonderful video, this concepts has been explained very well
Thank you Shubham :)
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
The way you explained is excellent. Very much understandable you lecture
Very clear and to the point explanations .. thanks a lot !
Your welcome bro