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

[@Default_-ij5oc]

@@mr.rstatus5113 Unfiltered

[@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💯❤💥💥💥💥

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

[@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?

[@vishalmane3139]

@@avibhattacharya7805 No

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

[@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 🙏🏼☺️

[@faizanwar_]

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

[@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 ☺️🙏🏼

[@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

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

[@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! 💌

[@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

[@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 :)

[@ashishagnihotri5566]

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

[@techTFQ]

Loved it bro.. thank you 🙏🏼

[@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

[@harsh_speaks]

Could not understand Joins from my Professor and searched on KZbin 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.

[@MixPostBox]

After 10 years of my career, Now I understand the concepts behind Joins clearly. Thank you :)

[@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 👏

[@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

[@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.

[@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

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

[@AnkitMaan-z1e]

Bai waah.... ajtak aese joins nai dekha life may. Amazing

[@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

[@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

[@simranbanwait]

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

[@rajendrakakde2622]

Wait is over.. first JOIN video was awesome 👌

[@techTFQ]

I hope you will like this one too ☺️

[@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.

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

[@Ananth-12055]

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

[@techTFQ]

Glad you think so bro ☺️

[@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.

[@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

[@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

[@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

[@manojkumarrajaka5204]

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.

[@techTFQ]

Your welcome Manoj .. I am glad you liked my live sessions too 🙏🏼🙏🏼

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

[@PSK833]

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

[@brahmarao4826]

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

[@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

[@ManaviVideos]

Excellent SQL Joins videos- Highly Recommended to watch it!

[@ArmaanSingh-e6p]

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

[@sudarshanmhaisdhune1039]

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

[@atufashireen6238]

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

[@shravyak8535]

Best tutorial on the concept of SQL joins.

[@alishnittrichy1225]

Finally understood joins 😭 thanks a lot sir

[@chethanapsgowda6332]

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

[@techTFQ]

Thank you bro

[@Egyptiano200]

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

[@techTFQ]

Thank you 🙏🏼 I am glad you liked it

[@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

[@Niyasudheeak]

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

[@manuprakash1989]

true

[@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.

[@crixcel8388]

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

[@officesuperhero9611]

You are a really good teacher. It is clear you spent a lot of time planning, writing, and editing these videos. Thank you!!

[@soy_leche]

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

[@techTFQ]

Thank you Ryan 🙏🏼

[@vgaurav3011]

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!

[@techTFQ]

Thank you Vipul .. Glad you liked it and happy to know you would share it with others 🙏🏼☺️

[@harkiratkaur3467]

Can't thank you enough! A great resource to learn, keep posting:) Can you also teach how NULLs are treated in joins?

[@techTFQ]

Thank you :) as for NULLS in JOINS, will probably make another video about it since many have asked 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

[@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.

[@ashutoshsingh5568]

Brilliant explanation for JOINs. You're now my SQL Guru. Thanks for the teachings. One request to make some videos on Dynamic SQL as well. Once again, thanks a ton sir.

[@techTFQ]

Thank you Ashutosh :) and noted on the request

[@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

[@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 ☺️🙏🏼

[@pallavimondal2655]

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

[@qurdedu4032]

Tofig, you are rocking it bro! Deep and clear explanation. Thank you sir.

[@techTFQ]

Glad you liked it buddy 🙏🏼

[@latayadav4642]

Thank you sir, I am preparing for my interview from your videos ❤❤ Your way of teaching is really good. May God bless 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.

[@zeeshanahmed2594]

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

[@humasayyed213]

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

[@vannamvasudha7414]

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

[@prem486]

Your teaching style is truly exceptional and great one indeed. Keep going!

[@techTFQ]

Thank you very much!

[@anaskhan4841]

Best teacher for SQL.

[@techTFQ]

Thank you Anas 🙏🏼

[@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.

[@aap1803]

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

[@techTFQ]

I am glad to hear that Bro 🙏🏼☺️

[@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

[@pratibhapragya3552]

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

[@Hedonistashu]

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

[@FittWithNit]

I don't know how to say thanks to you for making mysql so simple and easy to learn 🥺.

[@techTFQ]

Awesome bro . I am happy to hear that

[@gautamchinku8645]

Amazing Series!! Please keep continuing to post all the topics. Thank you Thoufiq!!

[@techTFQ]

Thank you Gautam, I will

[@kavitalakhani9845]

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

[@harshalbabar278]

Superb explanation as usual! I have become a regular watcher of your channel and I have watched almost all of your videos. Please make a series on tableau. Wolud love to learn from you 👍💯

[@techTFQ]

Thank you Harshal .. I am really glad to hear that ☺️ Tableau is something I am planning in the coming months

[@dowlathbashag65]

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

[@techTFQ]

I am glad to hear that Dowlath

[@shirinstar9133]

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

[@gauravjain969]

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

[@romalmahana6676]

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

[@chitralekhagopalakrishnan3612]

Keep doing such videos which will help students like us! Great work!

[@nazranabagwan1317]

The best playlist for SQL💯

[@ramprasadsomaraju3889]

one of the best explanation so far this guy deserves a bow❤❤ love from ireland

[@VITORB82]

You truly are a brilliant teacher. Thank you.

[@vipintiwari327]

so well explanation sir ji...loved it

[@johnnysmith6876]

best joins explanation on KZbin. THANK YOU!

[@satrinakelley-jordan6418]

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

[@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

[@doctmohamedabdo]

Mashallah perfect. These 2 videos are brilliant with excellent explanation

[@gauravlele3890]

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

[@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

[@harshavardhini2082]

Wow never understood self join until this vedio thank you❤

[@johnpg3055]

Thank you Thoufiq.. Best explanation as always.. Waiting for other advanced sql concepts.

[@techTFQ]

Thanks John, what advanced concepts would you be interested in

[@johnpg3055]

@@techTFQ Thanks a lot for replying. Concepts like functions(pivot, etc.), stored procedures, triggers, views, etc.

[@techTFQ]

Noted John .. will cover them

[@araja3755]

He deserves much more views and support.

[@techTFQ]

Thank you bro

[@Pallavi_vibes]

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

[@SaiKiran-pu7ce]

One of the best sql join video ever i watched 💥