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 😂

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

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

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

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

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

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

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

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

[@sasidharkuchibhotla2806]

Hi, I have a doubt which might sound silly - In Self Join if if we write on child.member_id = parent.parent_id then the query result would be same or it would change?

[@sabyasachimukherjee4278]

Best explanations of JOINS in KZbin. Hands down!

[@techTFQ]

Thank you bro 🙏🏼

[@faizanwar_]

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

[@srinivaspabbathi5026]

Thank you very much for great content .Can you please make videos on data engineering topics

[@techTFQ]

Thank you 🙏🏼 May I know what DE concepts you looking for?

[@shannmuka5354]

@@techTFQ Hello just completed the 2videos on joins and they are the best on youtube. Thanks for the videos. Even I have the same thought of asking the DE topics. You can start from the beginner to intermediate/advanced level concepts. Thanks again.

[@venkateshgolla8005]

Thanks a lot, please make video on sub query also.

[@techTFQ]

Your welcome and sure will do

[@soy_leche]

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

[@techTFQ]

Thank you Ryan 🙏🏼

[@snehalgajbhiye1454]

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

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

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

[@AsadAli-wi1xs]

Amazing Content Sir please make the vedio of subqueries of sql...

[@techTFQ]

thank you and sure will make it soon

[@Ajaykumar-xr4rk]

It's very useful content 👍👍 Can u make videos for etl , data warehouse like those..

[@techTFQ]

Thank you I ETL and DW, let me plan it for the future

[@Anonymous_it_is]

Awesome Content Sir. Thanks for sharing your knowledge Please consider making a tutorial on Date time manipulation in SQL. Thank you!

[@techTFQ]

Thank you Rohit and sure will do

[@passportbro904]

Full Outer Join: This is like having a toy box that contains all the cars and all the action figures, even if they don’t match. If a car is also an action figure, it gets a special sticker. Cross Join: This is like pairing each car with each action figure in the toy box, regardless of whether they match or not. It’s like having a playdate for every single toy with every other toy. Self Join: This is like sorting the same type of toys based on a certain characteristic, like color or size. For example, it’s like arranging all the red cars together, or all the big action figures together. Natural Join: This is like having a toy box where cars and action figures are matched based on a common characteristic, like the same color or size. Only the toys that have the same characteristic are paired together. Remember, each join is like a different way of organizing your toy box. Choose the one that helps you find your toys the best!

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

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

[@vishalkarur5366]

This video was awesome as always. Can you please make video on how to create portfolio website . Im going to comment this in very video until that😅 Thanks for the awesome explanation

[@techTFQ]

Your welcome Vishal .. Haha , I’ll plan portfolio.. just want to make some projects before portfolio.. N before projects, I need to finish some more sql concepts which I’ve already planned .. But definitely portfolio, will do it

[@vishalkarur5366]

@@techTFQ sure Thanku so much. ❤️❤️

[@gururajgadag9329]

Does these queries also work in Oracle?

[@techTFQ]

Yes it should..

[@attaullahkhan2504]

Sir plz explain sub-query in details... plzzz.

[@techTFQ]

Sure I’ll plan a video on it soon

[@varshithreddy5104]

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

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

[@gateeasycse]

Inner join is proper subset of outer join??

[@techTFQ]

Yes you can say that

[@SatyamKumar-lj5bi]

Are you going conduct live session on 17th as per planned !!

[@techTFQ]

Yes Satyam , I will

[@nikitarai3701]

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

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

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

[@srivithya6172]

finally i found a clear explanation. thanks thoufig

[@dowlathbashag65]

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

[@techTFQ]

I am glad to hear that Dowlath

[@Aparna.Ratheesh]

CROSS JOIN or Cartesian JOIN - is used on a list of clothing apparel with different sizes and colors - for example Table: Apparel ItemID ItemName 1 T-Shirt 2 Jeans 3 Dress Table: Sizes SizeID SizeName 1 Small 2 Medium 3 Large Table: Colors ColorID ColorName 1 Red 2 Blue 3 Green To get all possible combinations of sizes and colors for each apparel item, you can use a CROSS JOIN

[@venuvamsi5344]

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

[@techTFQ]

Your welcome buddy, glad you liked it

[@vamsipriyanka5053]

Hi Thoufiq... Now only I registered for second batch SQL. I Missed the classes. U have recorded sessions

[@techTFQ]

Thank you Priyanka but sorry there are no recordings

[@ajay5028]

Very nice sir....keep it up...sir please make video on Linux interview questions like this video....God bless you

[@techTFQ]

Thank you buddy , Linux, not really my thing but let me see in the future

[@ManaviVideos]

Excellent SQL Joins videos- Highly Recommended to watch it!

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

[@faisalkhan6154]

Hi I like your teaching style .do you give online classes? I would like to leaen DA after reaserching many options.let me know pls .

[@techTFQ]

Thank you 🙏🏼 I don’t provide personal tutoring but I do conduct live classes on Lighthall.co You will find some announcements about these classes in my KZbin community posts

[@SatyamKumar-lj5bi]

Awesome,Appreciate your effort ♥️

[@techTFQ]

Your welcome buddy

[@poojamahesh8594]

Really really useful vedios.. 🙏🙏 Please Keep posting vedios..it really helps lot..

[@techTFQ]

Thank you Pooja and will do 🙏🏼

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

[@vannamvasudha7414]

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

[@shivakumarj4080]

Hello Bro, I have one question. recently in one of my interview i got asked one question. i.e Fetch the list of managers where more than 2 employees are reporting to him. here you have taken parent and child table as example. so, How we have to get the name of parent who have more than 2 children?

[@fathimafarahna2633]

Simply awesome as always. Appreciate your efforts. Truly your contents are helping so many make learning anc understanding easy. God bless you🤗

[@techTFQ]

Thank you 😍

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

[@shravyak8535]

Best tutorial on the concept of SQL joins.

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

[@sahilgogna3393]

Thanks Thoufiq. Your videos are really making me better with sql. Can you please suggest any way by which I can practice these joins. Concepts are very clear but dealing with real business problems can be tricky. Is there any way to practice them?

[@techTFQ]

Your welcome Sahil .. I am glad you have liked my contents.. As for practice, I am not really aware of any free platforms but there is LearnSQL which I have mentioned in the video description which has some courses to Practice joins.. perhaps you can check it out

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

[@RakeshBitling]

can you please come up with diagram also...for better understanding

[@techTFQ]

may consider in the future for certain concepts only

[@ug_it_english]

basically concepts cleared!!! Thankyou Basically :)

[@techTFQ]

glad it helped

[@poojamahesh8594]

sir, natural join is not working in Microsoft SQL server, it throwing symtax error..what should I use alternatively.. SELECT * FROM Student NATURAL JOIN Marks; giving error sir..

[@techTFQ]

Natural join is not supported in MSSQL ..

[@poojamahesh8594]

@@techTFQ any other command for the same sir??

[@techTFQ]

No alternative to natural join in mssql. You don’t really need to use natural join.. As I mentioned in the video, it’s not recommended to use natural join.. It’s always better that we provide the join conditions using inner join rather than asking sql to choose the join condition

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

[@mahimatolani813]

Hello sir you are the best when it comes to explaining anything. But can you clear my doubt that at 8:16 when we are doing full join after matching join condition is it always the same that it will first do right join and then left join ??

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

[@rajendrakakde2622]

Wait is over.. first JOIN video was awesome 👌

[@techTFQ]

I hope you will like this one too ☺️

[@agrim8863]

Awesome Explanation Thoufiq as always thank you.

[@techTFQ]

Thank you Agrim 🙏🏼 Appreciate your feedback

[@sudarshanmhaisdhune1039]

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

[@anjalipandey3730]

Thank you for amazing content. It is very helpful.

[@techTFQ]

You're very welcome!

[@sandyN5555]

Hi you videos are very clear and understanding, I'm beginner for this topic, could you please explain how you write column name as "e.emp_name " and department d. please explain on this.

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

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

[@shikhavarma4049]

Amazing 👍You bring so much value and my go-to channel on YT for learning

[@techTFQ]

Thank you Shikha ☺️ I am glad to read this

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

[@atufashireen6238]

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

[@venkyvirat4623]

Make videos on PLSQL also bro

[@techTFQ]

Will do but in the future bro

[@mugeshs1083]

Part 1 & Part 2 Summary -------------------------------------------- inner join --------------------- select e.emp_name, d.emp_name from employee e, join department d on d.dept_id = e.dept_id; left join (inner join + missed out records from left table) ------------------------------------------------------------ select e.emp_name, d.emp_name from employee e, left join department d on d.dept_id = e.dept_id; right join (inner join + missed out records from right table) ----------------------------------------------------------------- select e.emp_name, d.emp_name from employee e, right join department d on d.dept_id = e.dept_id; full join (left join + right join + innner join) ------------------------------------------------ select e.emp_name, d.emp_name from employee e, full join department d on d.dept_id = e.dept_id; cross join (matched with all records) --------------------------------- selct e.emp_name, d.emp_name, c.company_name, c.location from employee e, join department d on d.dept_id = e.dept_id, cross join company c; natural join (Not recommended - since sql create matching condition) ------------------------------------------------------------------- select e.emp_name, d.emp_name from employee e, natural join department d on d.dept_id = e.dept_id; self join (joined with same table) --------------------------------------- select child.name as child_name, child.age as child_age, parent.name as parent_name, parent.age as parent_age from family child left join family parent on child.parent_id = parent.member_id

[@butitshard]

ADDITIONAL DATASET create table company (company_ID varchar (10), company_name varchar (50), location varchar (20) ) insert into company values ('C001', 'techTFQ Solutions', 'Kuala Lumpur') create table family (member_ID varchar (10), name varchar (50), age int, parent_ID varchar (10) ) insert into family values ('F1', 'David', 4, 'F5'), ('F2', 'Carol', 10, 'F5'), ('F3', 'Micheal', 12, 'F5'), ('F4', 'Johnson', 36, ' '), ('F5', 'Maryam', 40, 'F6'), ('F6', 'Stewart', 70, ' '), ('F7', 'Rohan', 6, 'F4'), ('F8', 'Asha', 8, 'F4')

[@gjayanth905]

sir where can i practice this type of querys and joins (websites or any datasets )

[@techTFQ]

Just posted a video where I mentioned about a platform to practice sql queries, perhaps you can check that out

[@deepashreezamindar6954]

Thank you so much Thoufiq for the wonderful classes. Window functions class were really helpful. Request if you could make an elaborated class on nest and unnest function.

[@techTFQ]

Your welcome 🙏🏼 And I’ll consider your suggestion

[@Cric_hungama]

Really, your content is very useful.

[@techTFQ]

Thank you buddy

[@brahmarao4826]

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

[@vijaynagarajuk]

In cross join example query is to fetch all the employees and Department but output showed only 4 records, how to get remain records ? I think need to left join in above line instead of inner join. Is it correct? Pl clarify

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

[@satrinakelley-jordan6418]

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

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

[@vaibhavtapdiya7077]

Hi @techTFQ, In NATURAL JOIN you told that SQL will itself decide the join condition based on column. But my question is, what if those table have 2 or more than 2 common columns which have same name. so, will NATURAL join consider all those same columns to join or will it consider only 1 column among them to join tables?

[@GracefulTalesPluto]

Toufiq, I always get one doubt which when I am asked to do a join, I don't know which join to use first? I understood what diff joins we have and how they work but in practise which ones to use in different situations confuses me

[@florincopaci6821]

Hello can you please recommend a good sql book based specially on usual stuff -queries,hierarhical queries, window functions ?i know that nothing compare with practical work because only when you practice you will faced errors and learn from them but i m interested in a good sql book from your point of view. Thank you

[@techTFQ]

I’ll need to check and get back bro

[@florincopaci6821]

@@techTFQ No prob.Thank you

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

[@shaikusman536]

That was awsome, ...simple outstanding explanation brother...Thanks aton...respect from Blr...INDIA.

[@remuslupinhp]

Great work, dude! well explained. Only thing is child is singular and children is plural so there is no 'childrens' if a parent has more than one child you can say he has 3 children...sorry for being a grammar nazi but you spoke it thrice so I thought you are teaching me so much, I should give back something...

[@qurdedu4032]

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

[@techTFQ]

Glad you liked it buddy 🙏🏼

[@360cutzofficial]

Can we use from employee e, department d in the from Clause

[@PSK833]

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

[@AmitKumar-df2yl]

Thanks for making this kind of videos. You are just clearing all our doubts sir 🙏🏼🙏🏼

[@techTFQ]

Your welcome Amit

[@varunkumarrs5516]

Hi @techTFQ I'm currently facing an issue with full join select employee.emp_name, department.dept_name from employee full join department on employee.dept_id = department.dept_id; while doing "full join I'm facing error as it says "unknown coloum emplyoee.emp_name in field list"" but when i just remove full join and add join to same code i'll get correct output for inner join.

[@erigelavani4162]

Thanks bro for your videos🥰

[@marcw.5492]

Thanks for your help ! Im wondering how we can "EXPORT" results to .CSV file instead of copying and pasting. Also can you Join multiple tables (3,4,...) ? Regards

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

[@Leoabnv]

Hi Thoufiq, Your videos are really informative and useful. Can you please do a video showing how to use case when and all the different kinds of uses? Thanks!

[@techTFQ]

Thank you Abhinav .. Sorry I dint get your question, can you please elaborate

[@Leoabnv]

@@techTFQ wanted to understand how to use 'case when' statements in MySQL. It would be great if you could do a short video on it 🙂

[@techTFQ]

Oh CASE statement.. I will be covering this in my live sql training session which starts today.. perhaps you can join it.. Will talk about CASE statement I think after the 3rd session

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

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

[@sampadsaha1449]

Hi, really nice explanation. Thank you. I have one doubt regarding cross join. What if there was multiple records in company table ? without ON clause which company will match against which employee? how it will be decided in that case