SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2

[@VITORB82]

After 5 centuries i finnaly understand what Cross Joins are. You deserve a Cookie!

[@sithaphal]

Then he need to subscribe to Mr.beast 😂

[@mr.rstatus5113]

Explain in single word dude

[@dasshrs]

So you do have 5 centuries experience in SQL Good for you

[@venkatpullalarevu9998]

Never understood SQL joins as much as I did with this video. Thoufiq, your teaching ability is beyond comparison. Great work.

[@kondibaabhange]

right ....super se uper💯❤💥💥💥💥

[@anchal_diary]

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!!!

[@avibhattacharya7805]

did you get placed?

[@sabyasachimukherjee4278]

Best explanations of JOINS in KZbin. Hands down!

[@techTFQ]

Thank you bro 🙏🏼

[@nikitarai3701]

Once you start watching his videos. There's no going back seriously. This guy is the OG!

[@adeebazia3436]

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 ♥️

[@techTFQ]

Super glad to know that Adeeba 🙏🏼☺️

[@vijayadivakar9887]

Great teaching thank you sir....I'm continuously fallowing your SQL videos..

[@techTFQ]

Your welcome 🙏🏼 I am glad you have liked my contents

[@kishorekumarrv776]

I'm also

[@monikadewani6181]

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

[@worldofnature8066]

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!

[@ehsanellahi5602]

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.

[@techTFQ]

I truly appreciate it , glad to know you liked it

[@faizanwar_]

How can you be so good at teaching? this is amazing...salute to people like you who provide such valuable contents for free

[@ashishagnihotri5566]

explanation = 100% efforts = 100% content quality = 100% our concept clear after watching this = 100% thanks = 100%

[@techTFQ]

Loved it bro.. thank you 🙏🏼

[@manavnarula6427]

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!

[@techTFQ]

Thank you so much ☺️

[@mujtabakhan4521]

hey bro any update on your business analyst journey? i too am preparing for it!

[@simranbanwait]

about 2 years back i ckeared my interview because of these two videos, no i'm preparing for another, thanks taufiq sir

[@julianasdiaryy6705]

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.

[@techTFQ]

Thank you Juliana! I am glad you liked the course and my contents :)

[@kiran8370]

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!!

[@hemalvarasada9192]

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.

[@151anirudhvyas8]

what happened ,how did u do??

[@hemalvarasada9192]

@@151anirudhvyas8 Cracked Bro

[@151anirudhvyas8]

@@hemalvarasada9192 great congrats bruh

[@sumaiyams27]

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.. !!!

[@zosyatrimbacher7491]

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.

[@crap45671]

I can't believe I'm paying college fees with profs that can't even teach this well...

[@techTFQ]

😁 I am glad this video helped

[@pratibhagarg8398]

Indian education system

[@asifajabeen4039]

Our education system is better than other countries..they don't even monitor students are listening to them or not ​@@pratibhagarg8398

[@daminichatta290]

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.

[@techTFQ]

Thank you so much Damini ☺️🙏🏼

[@sayonapurohit6223]

I am glad I found your video. I was struggling in joins so much- now feels like i am a pro

[@techTFQ]

glad it helped

[@shravyak8535]

Best tutorial on the concept of SQL joins.

[@ninaddombre4032]

Dude, I have bought a couple of Udemy courses for SQL... I find Your teaching method much more effective comparatively... Thanks a lot 😃

[@techTFQ]

thanks Ninad

[@hsnsumanth]

Do you have your videos in Udemy?

[@techTFQ]

Nope I don’t

[@ManaviVideos]

Excellent SQL Joins videos- Highly Recommended to watch it!

[@hammadyasir2174]

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.

[@PSK833]

thank you so much sir! I was also thinking like cross join is a useless thing, but today i realised its importance

[@Niyasudheeak]

It's the first time I've ever understood sql joins so well, جزاك الله خيرًا, "بارك الله فيك thoufeek

[@manuprakash1989]

true

[@adityatomar9820]

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

[@varshithreddy0022]

Keep posting different difficult concepts in SQL. No need to think of joins again after watching ur videos

[@techTFQ]

Thank you Varshith .. glad you liked it

[@shubhamyadav7071]

Thank you so much sir I have never commented on any KZbin 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

[@nikhilyadav820]

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.

[@vipintiwari327]

so well explanation sir ji...loved it

[@soy_leche]

Thoufiq, I really appreciate your videos. The explanations are great.

[@techTFQ]

Thank you Ryan 🙏🏼

[@johnwayne6151]

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!

[@sudarshanmhaisdhune1039]

Damn true bro. Self-join demo is outstandingggg! 💌

[@srivithya6172]

finally i found a clear explanation. thanks thoufig

[@girishbawaskar3775]

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 👏

[@Egyptiano200]

one of the greatest sql joins tutorial all over the web .... awsome

[@techTFQ]

Thank you 🙏🏼 I am glad you liked it

[@ArmaanSingh-e6p]

The best lecture on sql joins i've got so far!!

[@mastilife8175]

Self joins not understand😢, but i would give you 5 rating. The way of teaching is really good. 1st video was awesome for me. Thansks for your time.

[@dowlathbashag65]

Excellent Thoufig ... Great job. Your Explanation is awesome ...Thank you so much.

[@techTFQ]

I am glad to hear that Dowlath

[@atufashireen6238]

Toufiq sir, your teaching is great thanks a lot...I cant stop myself from not hitting the like button after the video.

[@P_satheesh99]

I recommend to watch these vidoes at first than watching at last. It will give clear information about joins, especially use case of self join ❤

[@techTFQ]

Thanks for sharing

[@pooojajjnsjs9582]

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!

[@shirinstar9133]

FINALLY, I UNDERSTOOD SELF JOINT !!!!!!!!!!!!!! THANKS A LOT !!!!!!!!!!!

[@pereirarupal]

Thank you. Best explained SELF JOIN . I have struggled with this for a long time. All of your videos are very well explained.

[@techTFQ]

I am glad to hear that 🙏🏼

[@pereirarupal]

@@techTFQ Please make a video on Populating Null Values in a Table And Updating the table during data cleaning. Thank You.

[@techTFQ]

Will consider this scenario during a future video

[@doctmohamedabdo]

Mashallah perfect. These 2 videos are brilliant with excellent explanation

[@zeeshanahmed2594]

I have never understood self join. Thank you very much Sir for the simplified explanation.

[@VITORB82]

You truly are a brilliant teacher. Thank you.

[@thegideon4820]

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.

[@crixcel8388]

I feel I am at the right place thoufiq , thanks for investing your valuable time for us

[@vannamvasudha7414]

The tremendous job bro...the jet speed of understanding directly landing into our brains..tq so much

[@kavitalakhani9845]

I understood the 1st part very well and now watching 2nd. Thank you very much for helping.

[@johnnysmith6876]

best joins explanation on KZbin. THANK YOU!

[@rajendrakakde2622]

Wait is over.. first JOIN video was awesome 👌

[@techTFQ]

I hope you will like this one too ☺️

[@Hedonistashu]

best video on joins tutorial...maza aagya sir ..pata hi ni chala kb video khatam ho gyi👌👌

[@ShubhamMishra-hg3rd]

guruji , really wonderful video, this concepts has been explained very well

[@techTFQ]

Thank you Shubham :)

[@prathamgupta7605]

The way you are progressing, by May 2022 I see you getting 1 lac subscribers.

[@techTFQ]

Thank you Pratham for the wishes and the support ☺️🙏🏼

[@m4u8443]

Thank you very much for the detailed teachings.....content is vey much clear and easy to understand ....

[@techTFQ]

Thank you .. happy to know that

[@pallavimondal2655]

You are my absolute favorite! You are my One-stop solution for SQL learning❤

[@pratibhapragya3552]

That's great explanation, I was always vague about joins until I watched this video. Thank you so much!

[@masterenglish7156]

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.

[@erigelavani4162]

Thanks bro for your videos🥰

[@srinivasg1331]

The way you explained is excellent. Very much understandable you lecture

[@satrinakelley-jordan6418]

Wow, this was an EXCELLENT explanation of Joins! Thanks for helping me better understand!

[@gauravlele3890]

Explanation with same example in simple language. Very helpful for understanding basics on joins. Thank you 😊

[@latayadav4642]

Thank you sir, I am preparing for my interview from your videos ❤❤ Your way of teaching is really good. May God bless you 🙏

[@sudarshanmhaisdhune1039]

Wow! mind-blowing explanation Taufiq. Self join demo is outstanding. You are genius man.....!

[@tousif161]

The best explanation for SQL JOINS.

[@theazeezyfamily5032]

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.

[@techTFQ]

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

[@brahmarao4826]

"Clear and concise video tutorial - a perfect guide for mastering [SQL]. Highly recommended!" Thanks a lot Thaufiq🙏

[@Pallavi_vibes]

I never understood self join but from this video its cleared.Thanks

[@melanieouellet5098]

Wonderful! Thank you so much! You have just cured my headache!

[@techTFQ]

I am glad to hear that ☺️

[@shabbirahmed-hc7ek]

iam starting my career into data analyze your vidoes is really help lot

[@harshavardhini2082]

Wow never understood self join until this vedio thank you❤

[@msenthilkumar1124]

you are rocking by way of explaniation, Even i had a lot of stuck in understanding join before watch this one.Great job Mr.

[@nazranabagwan1317]

The best playlist for SQL💯

[@sudarshankoirala2072]

Very clear and to the point explanations .. thanks a lot !

[@techTFQ]

Your welcome bro

[@anaskhan4841]

Best teacher for SQL.

[@techTFQ]

Thank you Anas 🙏🏼

[@Omkar_Shete]

value for time content... Amazing teaching skills.... Thank u so much sir.....

[@pankajroy.4]

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.

[@techTFQ]

Thank you Pankaj :) So glad this helped you

[@neelmohankrishna8532]

Thanks for bringing full clarity on joins with your amazing explanation. It would be great to have a lecture on Subqueries. Thank you.

[@techTFQ]

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

[@tejaswinithorat8301]

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

[@avinashgupta8627]

very good video to understand joins both parts 10 on 10 sir

[@vigneshnagaraj7137]

WOW . The join tricks is wonderful.

[@techTFQ]

Cool 😎

[@agrim8863]

Awesome Explanation Thoufiq as always thank you.

[@techTFQ]

Thank you Agrim 🙏🏼 Appreciate your feedback

[@rajesh.singha]

Awesome tutorial on SQL joins. Thanks a lot sir.

[@humasayyed213]

Thank You Brother... First person who taught the joins so clearly. Thanks a lot

[@venuvamsi5344]

Bro awesome love ur explanation, easy understanding. Thank u so much.

[@techTFQ]

Your welcome buddy, glad you liked it

[@tolulopeabolarin5597]

I can't appreciate you enough for making your videos so easy to understand, thank you Thoufiq.

[@techTFQ]

Your welcome Bro Glad you like them

[@snehalgajbhiye1454]

Thank you so much sir...its amazing to learn SQL from ur channel☺

[@priyankamaddipudi7921]

Hai.... Thank you so much for sharing your knowledge in the form of videos..... It's so helpful to beginners who don't know the basics of any programming language.... I am a huge fan of your explanation. I am regularly following your videos to improve my knowledge.... Thank you so much sir... It's a great work... No comparison to your work it's simply beyond......

[@techTFQ]

Thank you so much .. glad this helped

[@chethanapsgowda6332]

Really amazing....one of the most best platform in utube I ever seen

[@techTFQ]

Thank you bro

[@romalmahana6676]

Explained in very simple words, there is nothing that i didn't understand. Keep it up!!!

[@gauravjain969]

The best tutorial out of all the tutorials present there on KZbin.

[@nishigandhakhopade4777]

This the best You Toube series to learn sql.. Thank You for the efforts..!!!

[@SatyamKumar-lj5bi]

Awesome,Appreciate your effort ♥️

[@techTFQ]

Your welcome buddy

[@horsepower33]

You are the first person I ever had to watch on 0.75x speed. Your normal speaking speed is 1.25. Great videos btw.

[@michaelchiz8055]

I enjoyed the previous video and i'm now enjoying this one too.

[@ananthjinde9777]

This is best video on joins in the whole KZbin ... Nice work man

[@techTFQ]

Glad you think so bro ☺️