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

[@makemymarket1772]

Left join = inner join + additional records in left table = best explanation I ever heard. Thanks!

[@SurajYadav-bc5id]

Indeed.

[@Somya_bhardwaj01]

or you can say left join=left table + matching values in both table.

[@Steven-jf4cs]

@@Somya_bhardwaj01 The original description enforces the 'inner' join concept and builds up from a basic understanding.

[@rajatmw1999]

Truly! I was stunned when I saw this. Its genius simple.

[@SmoothWingman]

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

[@visceralcinema]

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!

[@slaym5900]

Trust my word. You are the only one so far who really made SQL JOIN easy .

[@urvindarkaur0278]

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

[@techTFQ]

Thank you for your kind words Urvindar.. So glad this helped

[@kamalikamukherji6482]

You are awesome ur hardwork is amazing

[@jersonpogi]

I have not understood SQL JOINS more clearly than the way you taught me. Thank you! I appreciate what you do.

[@diliplaz4415]

Repeat this episode 2 to 5 times that would help you the concept and use your query window hand on write his code , I assure you definitely got it. I found techTFQ is one of the best teachers as far I do experience! Thank you.

[@alpeshutube]

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.

[@LowandSlowwithPriya]

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.

[@techTFQ]

Thank you so much 🙏🏼 Glad you liked it

[@Motivation_Station_Neo]

I agree, he’s teachings are so easy to understand

[@tracy.i6649]

I have been doing sql for years but never quite understood joins as i now understand after watching this video for just a few minutes. Thank you!

[@dbest282]

Tracy come and teach me😢😂

[@RagulM-m7n]

I highly recommend checking out this page for comprehensive tutorials on SQL join queries, as they provide clear explanations and practical examples that have greatly enhanced my understanding of database operations. and kindly help us with some database and give some questions in that.. It will attract more number of students who see this video.anyways thansss

[@Lee-mt9nr]

Which page ?

[@embisonjones4996]

My American teacher has a way of making the lessons on “Joins” sound so complicated. Thank you for simplifying it sir. For the first time I’ve actually understood it.

[@laurak5196]

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 KZbin, 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. 🙏🏻😊

[@techTFQ]

It's always a pleasure to read your feedback Laura. I am so glad to receive your wishes. And I imagined when I was making this video that it might relate to you. I am glad it did and I am glad you found this useful. Thank you so very much for being a constant supporter of my channel and I truly wish you achieve all your goals for this new year :)

[@altafbaig6485]

@@techTFQ do u take online live SQL classes?

[@aeroabrar_31]

@@techTFQ This is what a beginner always needs. Thanks man, you got a new subscriber !

[@bhaveshnair5801]

The unique thing about this join video is that it helps to understand when to use which join. Certainly boosting my confidence for counter questions on join in an interview.

[@techTFQ]

Glad you liked it

[@premkunvarparmar2419]

No one taught me which table is left and right..you do this just.. Thank you sir... Thank you very much... Just this things can me confused me. Today I got clear this.. Thank you very much...

[@techTFQ]

Glad this helped bro ☺️

[@YOitsRAD]

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.

[@techTFQ]

Thank you Rad .. I am glad to hear that

[@catcreamlive4462]

I have to agree 100% I have been trying to learn sql and python and felt lost and confused, anyone teaches it's hard to understand or they talk down to you. So happy I found your content.

[@pam9367]

Your are the great teacher.. I have 3 yrs experience in sql.. Now I got more clear in joins thank you bro 😊

[@techTFQ]

Thank you Lionel .. glad this helped

[@junedsaleh8415]

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!

[@suganthym1438]

Agree

[@ruchikakkar3499]

Great explanation. 8 years experienced here, wanted to revise sql joins for a small project. This video really helped.

[@techTFQ]

Thank you Ruchi.. Glad to know that even an experienced professional like you is benefiting from this content 🙏🏼

[@KenAgim]

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

[@janetjohnson9774]

Hello Thoufiq, i started my journey as a data analyst 3 weeks ago, i stumbled across your video on the explanation of the roadmap for been a data analyst, the skills to develop, to enable someone have at least basic knowledge especially on SQL. This has guided me through the journey so far, although it all seem lumped up at the moment, bu i am taking it one at a time, since its a new skill for me but your videos has made it easy for me to learn. Thank you.

[@techTFQ]

Thank you so much Janet .. super glad to know my videos have helped and I wish you all the best in your learning journey

[@princeshetye7205]

Janet may I know what all skills you need to learn for data analyst profile as a start-up or entry level in this particular domain?? pls reply if possible

[@sspinjari]

Hi Sir, Earlier I was struggling to get fetch data from 3 three tables, now after watching your 2 two videos several times now I am confident enough to solve any query of SQL... no. of tables doesn't matter. Bunch of thanks for everything Sir. Now I am targeting windows functions, I never thought I will write such queries but Sir, the way you teach is just amazing 😍😍

[@techTFQ]

Thank you so very much for leaving this feedback bro.. means a lot to receive such amazing feedback 🙏🏼

[@balugovind]

I had the same problem man. So easy to understand.

[@anupgupta5781]

It is so unique explanation why someother person did not notice that which is left is left table and right side is right table that is awesome concept

[@techTFQ]

Thank you Anup :)

[@anupgupta5781]

@@techTFQ ❤️

[@elif_zdl]

The joins are much clearer now! Thank you for literally saving my life!!

[@sagarvaryani7]

Was confused with JOIN, saw many videos but couldn't understand, You explained beautifully Thank you.

[@techTFQ]

Awesome.. I am glad to read this ..

[@slappy703]

BEST EXPLANATION EVER. May ALLAH Bless You Sir❤🙌

[@anilgopie]

I did SQL a few years ago in school, Joins was something that I could never understand. Mainly cuz the instructor wasn't very good. Your explanation is very good. Will go thru it a couple times again to make notes so I fully understand and also do examples. But very helpful! :)

[@Abeikirt]

Yea take notes to get clearer picture

[@iampowr]

WOWOOWOWOWOWOOW I REALLY LIKE HOW DID YOU EXPLANED LEFT JOIN AND RIGHT JOIN I LOOOOVE IT

[@techTFQ]

Thank you buddy Glad you liked it

[@codewithbishal895]

Where was this legend when i fast started learning SQL, i would have been an GOOGLE data analyst by now

[@akashgautam1909]

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

[@techTFQ]

Thank you very much Akash .. glad you liked it .. the scripts are already shared in my discord

[@suranjanasaikia8200]

totally agree....this video was a life saviour. Thank you Toufik

[@payalkashyap11]

You have explained so smoothly n it's actually very easy to understand

[@mdnabeelt7801]

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.

[@sivasankarpalpandian2647]

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

[@Tejesh1212]

The best video i have ever seen in my 3years of IT experience

[@niceboy-mv6sm]

you reached so far your lectures are watched by jaypee university student in DBMS lab and i am writting this comment from Lab thank you great efforts

[@techTFQ]

Great to hear that. All the best

[@ninminion]

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.

[@illusion7223]

This is a very clear and simple explanation.I almost gave up and thats when I chanced to see this video. I cant believe that I finally learnt Joins! Thanks a ton

[@manojkumarmanu6907]

I can strongly say that no one can teach this content in such short duration .Thank you for the valuable content

[@techTFQ]

Thank you Manoj 🙏🏼🙏🏼

[@lanreuzamere4994]

Officially the BEST explanation on SQL JOINS online! WHERE Thoufiq = "awesome";

[@amandixit3555]

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.

[@techTFQ]

Thanks a lot Aman. Feels great to read such feedback :) Much appreciated!

[@madhupriyanka5943]

I always have this sort of feeling that joins are kind of confusing. I really appreciate this video helped a lot and boosted my confidence I can now easily run the query. Thanks a ton...!

[@enefiokjames205]

Many thanks for this detailed explanation of Joins. I can’t wait for the other part of the video. Notifications has been set.

[@techTFQ]

Thank you James 🙏🏼

[@prabhakarbadikela]

I seen multiple videos on SQL joins and This is the best video to understanding joins completely really excellent explanation.

[@sakshamchaturvedi]

EPIC EXPLANATION. The level of clarity that I have on JOINS now is insane. Thanks!

[@techTFQ]

Great to hear!

[@abhinay20]

After watching many videos in youtube this is the Great video for explaining things easier & simply superb

[@techTFQ]

Thank you so much 🙂

[@mohammedshahil4898]

Wow. Really enjoyed this. Joins was one topic which i was feeling hard to understand in depth. Thanks to this amazing video. I have got a clear idea now. Looking forward to the next one👍🏻✌️

[@techTFQ]

Awesome bro 😍 glad you liked it

[@MrChero76]

You are sooo right. I hated joins till I came across this video by luck. I missed out on a lot of opportunities because I did not have a good understanding on joins till now.

[@writerconnect1596]

I usually have a problem with Indian tutors due to accent but yours sir is good, well done well explained !

[@rajendrakakde2622]

Many thanks sir, I was looking for this one since a long time

[@techTFQ]

Glad I could help

[@Motivational_Glimpses]

OMG..! You are a Marvel..You are a James Bond of SQL..You are beyond my words...You are from another world. 😊 Sir ji, No doubts remained, all clear.....Thank you so much...for this great work.😊

[@techTFQ]

Thank you brother ☺️ It means a lot .. I am so happy the video helped you 🙏🏼

[@yaseenzuhaib4992]

Hi Thoufiq, you broke down the concept beautifully into mini-concepts and explained it really well. Thank you!

[@techTFQ]

Glad you liked it

[@samuelbekoe2354]

Best youtube class ever, love how you took your time to explain.

[@laxminarayan4237]

Excellent teaching Your work 👏👏👏

[@techTFQ]

Thank you! 😃

[@lavanyavempati6689]

Hello sir, you are simply amazing .thank you for your videos. I don’t know anything about sql after seeing your videos I lost my fear and I am able to write queries. Thanks for all your efforts. Please educate us . We are blessed to have you like this teacher. Your explanation is very simple and easy understanding 😊😊

[@kashmirshadows8150]

Among First Viewers , Thank you Thoufiq for the efforts

[@techTFQ]

Thank you bro for watching

[@swapnavallepu2417]

Outstanding explanation

[@ItsAKWorld-jy7hb]

99099

[@kashmirshadows8150]

Commenting after one year as I watched it full now 😅 Love it after 31.12 Cleared a huge confusion

[@Abhishek_videos1980]

Hi can you share the dataset which you have explained in the video

[@SowjanyaKolla]

I was thought of joins concept is too hard to for me. i was confused that how to choose common column and join with multiple tables. Truly, Your explanation just like wow🙏🙌.. I never saw this much of pin to pin explanation 😍.Thank You for helping the students like us. Thank you soo Much Bro🥰

[@arghasen8236]

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

[@ParthSingh-n4w]

with how much simplicity you explained the ending question, is just WOW

[@chinnapalaiah7907]

very good clear explanation, can you please share the scripts for creating the tables and inserting the data for the explained tables, if we follow the same tables and same data it will be better, Thank you....

[@techTFQ]

Thank you 🙏🏼 I had shared the scripts in my discord server, perhaps you can join my discord server to get those scripts. Link to join my discord can be found in video description

[@sanjugamer5185]

since past 7 days I am searching for these type of videos. Thank you sir

[@gowtham7819]

Good Explanation . Thank you

[@techTFQ]

Glad it was helpful!

[@satrinakelley-jordan6418]

EXCELLENT explanation of JOINS! Thanks for helping me better understand...hands down the best video ever!

[@RaviKumar-pn8uw]

I'm waiting for the video...1st like mine🤝👍sir

[@techTFQ]

Awesome. Thank you buddy

[@AnishKulkarni-eh3ut]

No one can teach joins better than you. thank you so so much for doing this. This is helpingso many new learners like me. I a going to go through the whole course work

[@shivsharma9153]

Amazing quality man..u have taken my SQL to next level that too for free❤❤❤❤

[@techTFQ]

Awesome Shiv , glad you liked it

[@laurak5196]

I just want to add that the point you made at the end about the left join being applicable to all the prior joins up to that point was new information to me and also very helpful. I always learn something from your videos and I so appreciate your time and your method of instruction. Thanks again, sir!

[@techTFQ]

Fantastic Laura. I am glad these details are helping you. Your dedication towards learning and that too from so many different resources is amazing and an inspiration. All the best to you :)

[@laurak5196]

@@techTFQ I’m hoping the interviewers will agree lol! Thanks again, Thoufiq, and thanks as always for your encouragement 🙏🏻😀

[@laurak5196]

@@techTFQ I’m a little in love with SQL, if I’m honest lol. It makes me sad that I can’t spend as much time with it now. But I do get just a bit of brush up time in every day, to keep my skills fresh!

[@techTFQ]

Haha SQL is amazing ☺️.. Why can’t you find time for SQL now .. busy with art work is it?

[@laurak5196]

@@techTFQ no it is my busy time in my day job, but maybe after busy season, will be time for a new career 🙏🏻

[@fathimafarahna2633]

Awesome..appreciate your efforts to create such precise and clear contents👏

[@techTFQ]

Thank you 😍

[@inamdarmohasin992]

Agreed✨

[@samuelfrimpong4184]

I know you've heard this for the umpteenth time but allow me to reiterate that you're the best! Thank you

[@yojanbrandon7753]

YOU ARE THE BEST

[@techTFQ]

Thank you buddy 🙏🏼

[@I_am_smooth_as_butter]

@@techTFQ it's really good ❤️

[@abhisheknaik909]

I am a complete beginner in SQL , JOIN was a tricky topic to understand, but u made it very simple to understand, thank you Thoufiq , you are awesome 🥰🥰🥰

[@techTFQ]

Glad to hear that Abhishek ☺️

[@vgaurav3011]

Amazing explanation, the best part is the practical query execution and tips given while executing them. Really loved it! Thanks 😄

[@techTFQ]

Thank you Vipul .. I appreciate this feedback and that you noticed the details ☺️🙏🏼

[@katamgariravanamma1474]

@@techTFQ ...!.

[@rahmankhan4994]

Thank you sir, I have watched so many tutorias from your channel and i only have one thing to say that your content is best for learning sql, thanks a lot.

[@subhrajitsaha2713]

Good content 👌

[@techTFQ]

Thank you Saha 🙏🏼

[@rekhas668]

Omg..Finally me too ve understand the join concepts..thank u so much ... such a worthy video... even a kid can understand...

[@techTFQ]

So glad the video helped ☺️🙏🏼

[@sachindixit6170]

If there are two tables for example employees & Department and you are getting your desired output using left join. If I exchange the table position and used the right join then output will be the same. Then what is the use of left or right join? For example:-- Select e.emp_name, d.dept_name From employees e Left Join department d On e.dept_id = d.dept_id ; Same output with query below. Select e.emp_name, d.dept_name From department d Right Join employees e On e.dept_id = d.dept_id ; Please answer it was asked in interview

[@laurak5196]

@Muhammad Zahid I’d like to know which query is more efficient for the system to run. One with join or with a subquery or does it vary from case to case? Or is there a general rule about this. Would be curious if @TechTFQ has time to answer us. I love this channel! 😀 I would also like to know the answer to Sachin’s question, from the interviewer’s perspective at least.

[@techTFQ]

The reason why we need both LEFT and RIGHT join is because in certain scenarios, you may have to write some query where one specific table might be on the left hence you will need left join and then some other table may be on the right side for which you would need right join. Now this explanation may not convince you hence consider the below example: In my video, the last query I wrote was to fetch ALL emp, dept, manager and project details.. Imagine, instead of this, if the requirement was to fetch ALL emp, dept, ALL managers and project then for such cases we would need to use both left and right join together. Sample query below: -- Fetch details of ALL emp and ALL manager, their department and the projects they work on. select e.emp_name, d.dept_name, m.manager_name, p.project_name from employee e left join department d on d.dept_id = e.dept_id right join manager m on m.manager_id = e.manager_id left join projects p on p.team_member_id = e.emp_id;

[@techTFQ]

Subqueries and Joins are 2 different things.. we should not mix them. Joins can be used everywhere even inside a subquery. I tried to explain the reason why we need both left and right join in above comment. Hope that clarifies Zahid..

[@techTFQ]

I tried to answer it in above comment Laura. Hope it clarifies :) As for more efficient query, it depends on many other factors. The way how you form your query plays a big role in performance too.

[@laurak5196]

@@techTFQ thank you, that makes it very clear! 🙏🏻🙏🏻🙏🏻

[@fazilrahmanz9797]

The best i have ever seen u made me realize that these topics are so easy and anyone at a basic level can master it !!

[@ginormica2282]

This is video is quite helpful. You have given answers to a lot many questions that i had. Thanks a lot 😊 Also could you please tell how to create the team_member_id column which has two FOREIGN KEY references in the same column? Thanks in advance 😊

[@minimumeffort1997]

Dude...Great video. I don't think anyone else has a better video on this topic.

[@Darkdevil2000]

no one is best teacher other than you....thanks sir 😍😍 .keep posting such important lectures related to SQL

[@ATFAtlis]

I had so much trouble understanding joints, the way you have broken this down was very helpful, thank you.

[@eyesmind9312]

this is the best video on joins I have ever come across on YT

[@manikantapuvvada2052]

Oh my God!! I have seen so many videos regarding Joins never i understand the concep even in my native language also I didn't understand. Finally I understood Joins session only after seeing your video. The way you teach was really awesome. Thanks a lot for this amazing video bro 🤗❤️❤️

[@techTFQ]

Glad it was helpful!

[@_kaythebutterfly7828]

I'm soooo happy I came across this video!! I'm a fresher and still struggle with JOINS and this was the most helpful video I've watched in MONTHS!! You made it easy to understand. THANK YOU Thoufiq!!!

[@techTFQ]

Super glad to know this helped ☺️

[@aspa18]

I saw the whole video and you explained everything perfectly . Thank you so much ! Really appreciated! I spent so much time studying and still I have the feeling I am not getting anything right . I was really sad today. Thank you for explaining so clearly and detailed ! 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼

[@priyaraman6818]

I am a beginner learner. Overall JOINS are very well explained. Thanks

[@user-ft9tp4ss2d]

Thanks a ton sir. I could really understand very well. Honestly couldn't get diverted few seconds also from this video. God bless you.

[@techTFQ]

Glad to hear that Surya :)

[@1440MAP]

This was the best explanation of INNER, LEFT, and RIGHT joins I've ever seen. Thank you!

[@techTFQ]

Thank you very much 😊

[@SoniaD-fj1nr]

after too many videos now am sure that completely understood and am clear about joins after watching your video thank you sso much.

[@joginapallyvivek398]

Your explanation is very Crystal Clear, God bless you and continue the same spirit

[@toocool9089]

This is mind blowing info, ah ha moments all the way through. He simplified joins to the next level. Thank you!!

[@MohitSharma_93]

Came here after recommendation by many people on LinkendIn. No regret at all. Hands down, for the first time, I have got so much clarity about joins. Thanks a lot Thoufiq. You are the man

[@nishmithagkotyan2872]

You are the only one who made JOIN easy. Thank you

[@yashiktaneja673]

Crazy stuff. The last 10 minutes are a treat to watch ❤✨

[@kiddosknowledgewizbyakshit9954]

Unique video...I hv tried many videos on utube to learn join, but never find the kind of valuable video... thanks a lot...

[@harisuper7039]

No words.... What a magnificent teaching... Super super +++

[@techTFQ]

Thank you Hari 🙏🏼 Glad you liked it

[@rakshitasadanshive8324]

Kindly provide queries so that we can practice along and have better understanding, only watching videos may not help us that much. But your explanations are wonderful! Thanks.

[@utkarshdixit3502]

This is the best video on joins I have ever seen, thank you for creating this.

[@techTFQ]

Glad you liked it

[@abdullinkshare9818]

after watching so many videos on youtube on sql joins, Your video is perfect + simple + great and simple explanation without jumping the topic. many thanks Thoufiq :)

[@yashhardi535]

Hi Toufiq join are super clear now , thanks your video was to the point and you cleared everthing from basics to results in easiest way possible. Cheers !!

[@sjvr1628]

Sharing knowledge freely is also a great sign of good people like you, Thanks again for doing these videos and spending your valuable time on helping us learn.

[@techTFQ]

Thank you for your kind words 🙏🏼

[@abhishekv8093]

Super explanation. You are the Master

[@nandithag2008]

Great Explanation....thank you sir✨

[@swatigaurav61]

my all cocepts got cleared , Thank you so much sir , You are a born teacher

[@techTFQ]

So glad to hear that Swati