Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

SQL Full Course Playlist 👇
• SQL Tutorial In Hindi
Like, Share & Subscribe Now :)
⭐ Subscribe for more SQL tutorials like this: bit.ly/3Fc7Gc6
👉 customer csv file: bit.ly/3KLPb2P
👉 payment csv file: bit.ly/41kIYjW
📢 GitHub link (all files): bit.ly/3Y7SRPr 📢
➖➖➖➖➖➖➖➖➖➖➖➖➖
Timestamps:
00:00 Intro
00:27 Content- Topics
00:41 What is JOINs In SQL?
01:27 JOIN Explanation with Example
03:30 JOIN Types
04:02 INNER JOIN
05:55 INNER JOIN Syntax
07:12 INNER JOIN Example
11:18 LEFT JOIN
12:47 LEFT JOIN Syntax
13:49 LEFT JOIN Example
15:09 RIGHT JOIN
16:19 RIGHT JOIN Syntax
16:43 RIGHT JOIN Example
17:20 FULL OUTER JOIN
18:21 FULL OUTER JOIN Syntax
18:49 FULL OUTER JOIN Example
19:46 Outro
➖➖➖➖➖➖➖➖➖➖➖➖➖
Target keywords: sql joins, sql joins with examples, join types in sql, inner join, left join, right join, full outer join, join examples, sql joins for beginners
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1
• What Is SQL ? | Databa...
Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2
• Data Types, Primary-Fo...
Create Table In SQL & Create Database | SQL Tutorial In Hindi 3
• Create Table In SQL & ...
INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4
• INSERT UPDATE, DELETE ...
SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5
• SELECT Statement & WHE...
How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6
• How To Import Excel Fi...
String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7
• String Functions in SQ...
Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8
• Aggregate Functions in...
Group By and Having Clause in SQL | SQL Tutorial in Hindi 9
• Group By and Having Cl...
TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10
• TimeStamp and Extract ...
Useful videos
How to Become Data Analyst in 2022 | Data Analyst Roadmap
• How to Become Data Ana...
Data Analyst skills, jobs and Roadmap
• Data Analyst- Skills, ...
Excel Tutorial for Beginners
• Excel for Beginners | ...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:
Instagram: / rishabhnmishra
LinkedIn: / rishabhnmishra
Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!

[@Sandipchaudhari-gz3ey]

this is the best explain i ever seen about sql. thanks for video

[@RishabhMishraOfficial]

Glad it was helpful! :)

[@praveenjoshi928]

I was struggling with joins in SQL, but after watching this video I've completely understood it. This is by far the best explanation of Joins on TH-cam. Thanks.🙏

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@pritamchougale]

I appreciate the effort you put into breaking down the complex concepts of joins and presenting them in a clear and easily digestible manner. Your explanations were detailed yet concise, making it much easier for me to grasp the nuances of inner joins, outer joins, left joins, and right joins. Thanks for this video man!

[@RishabhMishraOfficial]

Glad you liked it ✅️ n thanks for your encouragement 🚀

[@aman.x]

@pritamchougale looks like you pasted your comment directly from chat gpt😂😂

[@ritesh9584]

HI rishabh which Mike you used for vedio

[@vandanadevda7110]

Your way of explanation is too good it will be easy to understand specially for every beginner

[@YourGirlPratiksha]

The visualization of joins is too accurate in this video. It helped me a lot to understand the whole concept and fix it in my mind forever. Thanks!!

[@RishabhMishraOfficial]

Glad it helped! ✅️

[@nabinbist1220]

Hyyy

[@debopriyomukherjee3400]

The visualizations and the effort you made to make us understand is truly appreciable sir. Understood the whole things very easily.

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@adityaneve3482]

thank you sir. aapne jo smjaya hai. sab ekdam dimag mai gya hai. or koi video dekhne ki jaraurat nahi padi.

[@Userm2040]

Hi Rishabh ! Just watched the full video 2 times. Thank you for your kindness and genorosity. Thank you for mentioning bits and pieces , detailed. God bless you !

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@ShamimKhan.17]

Please make a video on Subqueries problem solving in SQL. there is not available a single video on this topic well precise and Structured as u covered JOINS follow the same steps and please upload it. my doubts are perfectly cleared by watching this video thank you ☺

[@omkarpharate9530]

Such an amazing explanation with Theory, Animation as well as practically query.
I have seen lots of videos to understand this topic but no one can have a better explanation like this.
Thanks a lot🙏

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@AyanKhan-nx3in]

W3 par padhne jaa rha tha lekin you tube pe aaya socha dekh lu. To ap aa gye or pehli baar itna deeply join smj aaya hai

[@sandeeprajput7697]

The way He demonstrate 🔥🔥
## 2024 LIKE 👉👉

[@codingwithzunaira6968]

Ya chez MN doond rhi thyi or khaii b smajh nhi arhi thyi thnku so much ❤

[@divyadarekar3939]

We do use mode of payment table in our DB so it became very much relatable and easy to understand..Thanks.❤

[@RishabhMishraOfficial]

Glad it helped ✅️

[@alisharampal2223]

You really earned a subscriber and Lots of respect today
Thank you so much.

[@user-sx3su4bv8r]

You do not know brother how much pressurize I was under, but really you r the hero of teaching, you always teach with basic ........ u do not know how happy i am....Thanks you so much..

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@makarsh29]

bhai , aapne bahut badiya s smajhaya hai sabhi vdos m , honestly never felt ki aur koi vdo dekhni pdegi.......
bhai meko syntax bahut badiya s samaz aat hai ...
but, jb practicle kro toh error bahut aate hai ..
koi sugesstion/opinion for beginners ???
to how to deal it ,fluently.......

[@mathematicsbyshraddha5050]

Thanks bhaiya apne bahot acche se explain kiya thanks a lot !!

[@jagrutipatil1020]

This was my last video for SQL joins....
Totally understand in one go only 🙏
Thanks sir🙂🙂

[@RishabhMishraOfficial]

Glad you liked ✅️

[@shaliniminj263]

hands down the best video I have come across for learning SQL joins

[@RishabhMishraOfficial]

Glad you liked ✅️

[@rahulchona6869]

Very nicely explained the join concept!!

[@muhasawa]

In 6:50 you stated that if column names in two tables aren't the same INNER JOIN wouldn't work. But that actually works. I have checked.

[@PurpleRainbow7]

Aap mere college me as a teacher lag jaao plzz 😩👍

[@anupamsingh_______________5378]

Aap kya krte ho
College m course

[@AkashSingh-vloger]

Tere college Wale afford nhi kr payege😂

[@vinodbenda1860]

Shi baat 😅😅​@@AkashSingh-vloger

[@akshaymorey8986]

😂😂

[@triptipal58]

Amazing explanation..I was struggling hard to understand the concept of sql joins but you made it very easy.. thanks a lot❤

[@mansishrivastava7259]

Best video on youtube about SQL joins ❤

[@rekhamalik3663]

One of the best videos on SQl i have found on TH-cam. Thank you for such a great explanation

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@anEngineerr]

Mishraji, nicely done. As a QA its always hard to start on JOINS concept, but you made it very easy for me. Thank you so much..!!

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@rithikahuja8203]

Best explanation about SQL ❤❤

[@himankshu]

09:00 In joins, the column values should be the same. If column names are different, that doesn't matters. What matters is the values we are matching should be the same.

[@RishabhMishraOfficial]

yes that's correct (y). values should match not column names- what i mentioned in the video was an example

[@ppriyansh2327]

tum bahut mast kaam karta hai Rishabh bhai
Apun ko tumko thank you bolne ka hai

[@Shomnath_Das]

Very Helpful for Interview 😊👍🏻❤

[@adityakumarchahal2852]

I can bet iss topic ko koi isse jyada easy poore youtube mein koi explain nhi kiya hoga🙂. Your efforts are really appreciable

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@hirdayram4437]

position depends on "payments p LEFT JOIN customers c" not on "c.customer_id = p.customer_id" , changing in "c.customer_id = p.customer_id" does not make any changes in output

[@kirtisrivastava6352]

very useful . Your way of explanation is the best .

[@sumitmaske1461]

Very nice explanation sirji 👌
Thank you 🙏

[@pramitkatiyar3785]

Very informative and useful

[@AnnaPaul-zw3jd]

Whenever I came to you, never gone empty hand 😄, Tons of thanks

[@RishabhMishraOfficial]

Glad you liked the content ✅️

[@musicyouneed.5.2]

i was trying to learn joins bt no one was explaining properly....and thank god i found you

[@RishabhMishraOfficial]

Glad it was helpful, all the best :)

[@Tejas-dk5kf]

nice video easy to understand , Thank you

[@kunalthorat9336]

Thank you boss ❤ bahut shandar explain Kiya apne ❤

[@nishantvats905]

I found it by mistake, but this is awesome content on SQL. Thank you Sir for a very good explanation.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️ keep learning n keep growing 🚀

[@hemantkakade4640]

Thank you for the video best explanation

[@user-lo8lg1be5q]

Excellent Teaching😊

[@ashishvaghela9563]

Best explanation ever....isse simple way me koi sikha hi nhi sakta

[@RishabhMishraOfficial]

Glad you liked ✅️

[@pawanpetkar5670]

Such an amazing explanation with Theory, Animation as well as practically query. Thanks Bhai

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@ayonghosh9154]

Jai Shree Ram, Thanks

[@abhisheksinha8120]

Hi, you explain very nice
What topic should I focus more for data analyst jobs in sql

[@kishansinh_zala]

Thank you!

[@harshgaur_it_2864]

You explained these UNION concept in the most simplest way. Keep creating such content.👼

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@radhasingh3549]

Thanks!

[@infosomnia]

Thank you bhai mahaan ho aap

[@alokraj1833]

sir kya koi condition false ho then hum koi msg print kr sakte hai SQL me?
means ex:- agar customerID ko humne Primary Key banaya hua hai or 1 he customerID hum repeat kare to msg display ho ki "You entered a dublicate customerID" ?

[@shivanisharma9870]

Helpful thank you..!!

[@alokdeshpandey]

bahut badhiya se samjhae ho bhai

[@mohdmuzammil9658]

Thnqq soo much sir aaj tak joins ka topic koi shi se samjha nhi paya but apne kitne simple way m har doubt clear Kiya well done 👍 sir

[@RishabhMishraOfficial]

Glad you liked ✅️

[@pammysingh6884]

Very good explanation bhai

[@anshuman.nagayach]

This is undoubtedly the best explanation of joins I have ever seen.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@rahulballal1084]

Very well explained sir and awesome presentation ....you made joins so simple & easy to understand

[@RishabhMishraOfficial]

Glad you liked ✅️

[@hitenarya4987]

Shukriya!!

[@satyamayachak2000]

Bhai joins itna easily smjha diya mza aagya bhai❤❤❤

[@umeshtiwari800]

Very good explanation

[@anupam4446]

column name doesn't need to be same. As you are writing `ON c.customer_id = p.customer_id`, is it not already specifying which columns to match?
6:50

[@satyamusic1382]

Thank You it was help full

[@SalmanKhan-wn8lp]

Thank you Rishab

[@gamingsiddhant1184]

THANKS
.

[@ahmedali3017]

Extremely appreciate

[@tusharjuyal9255]

Great teaching sir 😃

[@parthprajapati20]

Woww.. Appreciate
Such an amazing explanation with Theory, Animation as well as practically query.
I have seen lots of videos to understand this topic but no one can have a better explanation like this.
Thanks a lot man. 👍🥳🙏

[@AbhishekSharma-pz1go]

This is just awesome

[@user-fd8zp5nz6g]

How could you do this , amazing
Itna easy triqe se aapmne smjhaya
u r the best

[@khatrisinlondon2323]

Bhai bahot sahi tarike se samjhaya Joins ka concept with examples.....Thanks a lot...!!

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@ayushdixit4345]

Samjhi me aa gya ak hi baar me thank you sir 👍

[@RishabhMishraOfficial]

Glad you liked ✅️

[@biswajitshaw3192]

U r awesome sir, way of explanation is simply best I have seen yet.
Thank u so much and keep posting like this informative lessons

[@RishabhMishraOfficial]

Glad you liked ✅️

[@klavish7447]

Your teaching skills are amazing, thanks!

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@amreenmirza9778]

Hi..can i use the same concept of writing queries in oracle sql ?

[@akhilarks6196]

perfect!

[@monikanishad8750]

Best and Simplest way to explain the typical topic of Sql .Thnankyou so much .🤗

[@RishabhMishraOfficial]

Glad you liked ✅️

[@SuperAbhishek333]

Thanks Sir 😀

[@imranpga333]

very well explained

[@ArunPondyVlogsz]

You are great bro

[@mayurnikam6762]

aap bahut accha padhate ho sir.......

[@sayyadirfan5546]

i am unbale to upload the csv data file into table I am tried so many times but it shows process failed only. sir could you please help to how to upload the data file in table.

[@AniketManjrekar-w9u]

Best ever explanation

[@ShivaniSharma-em8kn]

Thanks sir ,🙏🙏🙏

[@RITIKRAHI-q4c]

Very helpful sir

[@ashutoshnayak6242]

Very good sir

[@Engineer_Trader_01]

I think this is the perfect way of teaching. Keep doing great work

[@RishabhMishraOfficial]

Glad it was helpful ✅️

[@harshadgarad3207]

Hi the video and concepts are awesome. only thing is customer id's are different in tables shown at 2:27 and tables created in workbench. So it confuses if somebody creates the tables just looking at the tables shown earlier in the video and hence the joins wouldn't work properly.

[@RishabhMishraOfficial]

Thanks for the info!

[@sandhyarajput1096]

Thank you sir❤

[@nikhil78980]

short and clear sir 😍😇

[@nabinbist1220]

BEST VIDEO OVER ALL TH-cam OF DBMS ...LOVE VAI.
Yaisai batana you wiI'll be rise one day..
Wau animation ,diagram of example ..love you yr

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Ayesha_01257]

Very well explained🤩

[@shreyatiwari8239]

great !

[@aparnaaras3531]

Best way of explanation Sir. Was very useful and easy to understand. Thank you Sir 😊

[@RishabhMishraOfficial]

Glad you liked ✅️

[@MuhammadAsif-sr6zb]

thank you bhai jan

[@sayanbiswas770]

Maza a gaya bhai dekh ke, 🙏🙏🙏🙏.
Animations were really helpful.

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@easterntoronto]

Thank you

[@user-kz8oz6mm1u]

AAJ MERA DOUBT CLEAR HUA YOU ARE THE BEST TEACHER ON TH-cam.

[@RishabhMishraOfficial]

Glad it's helpful ✅️

[@dipaliyerekar4108]

thank you 😊

[@Travelling_With_Kamalu]

Rishabh bhai.
i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join )
Thanku again
you are explanation osam ..........N/

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@kanchankandari1675]

Thank you sir