Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11
HTML-код
- Опубликовано: 27 июл 2024
- 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!
this is the best explain i ever seen about sql. thanks for video
Glad it was helpful! :)
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
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 RUclips. Thanks.🙏
Glad it helped! ✅️
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!!
Glad it helped! ✅️
Hyyy
I think on YT nobody explained JOINS topic like the way you have explained. Gonna see all other SQL videos from your channel
Thanks for this tutorial😇
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!
Glad you liked it ✅️ n thanks for your encouragement 🚀
@pritamchougale looks like you pasted your comment directly from chat gpt😂😂
HI rishabh which Mike you used for vedio
Your way of explanation is too good it will be easy to understand specially for every beginner
thank you sir. aapne jo smjaya hai. sab ekdam dimag mai gya hai. or koi video dekhne ki jaraurat nahi padi.
The visualizations and the effort you made to make us understand is truly appreciable sir. Understood the whole things very easily.
Glad it was helpful ✅️
I can bet iss topic ko koi isse jyada easy poore youtube mein koi explain nhi kiya hoga🙂. Your efforts are really appreciable
Glad you liked it ✅️
This was my last video for SQL joins....
Totally understand in one go only 🙏
Thanks sir🙂🙂
Glad you liked ✅️
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 !
Glad it was helpful ✅️
hands down the best video I have come across for learning SQL joins
Glad you liked ✅️
Ya chez MN doond rhi thyi or khaii b smajh nhi arhi thyi thnku so much ❤
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..
Glad it was helpful ✅️
Very nicely explained the join concept!!
You really earned a subscriber and Lots of respect today
Thank you so much.
Best explanation ever....isse simple way me koi sikha hi nhi sakta
Glad you liked ✅️
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🙏
Glad you liked it ✅️
Thanks bhaiya apne bahot acche se explain kiya thanks a lot !!
tum bahut mast kaam karta hai Rishabh bhai
Apun ko tumko thank you bolne ka hai
Whenever I came to you, never gone empty hand 😄, Tons of thanks
Glad you liked the content ✅️
Samjhi me aa gya ak hi baar me thank you sir 👍
Glad you liked ✅️
Best video on youtube about SQL joins ❤
One of the best videos on SQl i have found on RUclips. Thank you for such a great explanation
Glad it was helpful! ✅️
This is undoubtedly the best explanation of joins I have ever seen.
Glad you liked ✅️
i was trying to learn joins bt no one was explaining properly....and thank god i found you
Glad it was helpful, all the best :)
AAJ MERA DOUBT CLEAR HUA YOU ARE THE BEST TEACHER ON RUclips.
Glad it's helpful ✅️
Amazing explanation..I was struggling hard to understand the concept of sql joins but you made it very easy.. thanks a lot❤
We do use mode of payment table in our DB so it became very much relatable and easy to understand..Thanks.❤
Glad it helped ✅️
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
Glad you liked ✅️
The way He demonstrate 🔥🔥
## 2024 LIKE 👉👉
Very well explained. Thanks!!
Glad it was helpful! ✅️
Aap mere college me as a teacher lag jaao plzz 😩👍
Aap kya krte ho
College m course
Tere college Wale afford nhi kr payege😂
Shi baat 😅😅@@AkashSingh-vloger
😂😂
Well explained. I was struggling to understand as I am a beginner but now its clear.
Glad it's helpful ✅️
Good❤❤
Best explanation about SQL ❤❤
Very Helpful for Interview 😊👍🏻❤
Very informative and useful
Very nice explanation sirji 👌
Thank you 🙏
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..!!
Glad you liked it ✅️
Great effort 👍
nice video easy to understand , Thank you
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 ☺
very useful . Your way of explanation is the best .
I found it by mistake, but this is awesome content on SQL. Thank you Sir for a very good explanation.
Glad it was helpful! ✅️ keep learning n keep growing 🚀
Excellent Teaching😊
Sir your teach method is very good I seen this video first time and really i understand in first time
Glad it was helpful ✅️
Thank you for the video best explanation
This is the best explain i ever seen about sql @Rishabh Sir. Love you
Glad you liked ✅️
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.
Thanks bro Amazing explanation 💗
Glad you liked it ✅️
Such an amazing explanation with Theory, Animation as well as practically query. Thanks Bhai
Glad it was helpful ✅️
you have a calming personality, Sir. Good work.
Glad you liked ✅️
Helpful thank you..!!
Thank you boss ❤ bahut shandar explain Kiya apne ❤
You explained these UNION concept in the most simplest way. Keep creating such content.👼
Glad it was helpful ✅️
Bhai bahot sahi tarike se samjhaya Joins ka concept with examples.....Thanks a lot...!!
Glad you liked it ✅️
Thank you!
simplify explained with easy language so good
Glad it was helpful ✅️
bahut badhiya se samjhae ho bhai
Jai Shree Ram, Thanks
Best and Simplest way to explain the typical topic of Sql .Thnankyou so much .🤗
Glad you liked ✅️
Very good explanation bhai
Maza a gaya bhai dekh ke, 🙏🙏🙏🙏.
Animations were really helpful.
Glad you liked it ✨️
Very well explained sir and awesome presentation ....you made joins so simple & easy to understand
Glad you liked ✅️
Thank you bhai mahaan ho aap
BEST VIDEO OVER ALL RUclips OF DBMS ...LOVE VAI.
Yaisai batana you wiI'll be rise one day..
Wau animation ,diagram of example ..love you yr
Glad you liked ✅️
bhai mujhe kisi bhi channel pe samajh ni aya..but u made it..thanks a lot
Glad it was helpful ✅️
thank you sir.. One of the best video for understand joins....
Glad you liked ✅️
I think this is the perfect way of teaching. Keep doing great work
Glad it was helpful ✅️
Bhai joins itna easily smjha diya mza aagya bhai❤❤❤
Your teaching skills are amazing, thanks!
Glad you liked it ✅️
Well explained. Anyone can understand in this layman's language. Thank You so much :)
Happy to help ✅️
thank you so much for all the videos. This is very helpful. greatly appreciated.
Glad it was helpful! ✅️
Kya explain kiya. Hai sir with animation example .....,👌👌👌👌👌👌
Glad you liked ✅️
Great video really. Thanks a ton.
Glad it was helpful! ✅️
Thanks for this wonderful explanation :)
Glad you liked
Thank You it was help full
Well explained. Bundle of thanks
Glad you liked it ✅️
Thanks for sharing this video. Way of explaining is very simple and understanding. Thanks again
Glad it was helpful! ✅️
Thanks!
Thanks. very easy to understand
Glad it was helpful! ✅️
The best explanation ever
Glad it's helpful ✅️
Excellent and very easy to understand❤
Glad it was helpful! ✅️
Very good explanation
Really appreciate the Info given.
Glad it was helpful! ✅️
thank you for such an easy explaination.
Glad it was helpful! ✅️
Thank you so much for making such a wonderful video🙏.
Glad you liked ✅️
Your videos are really helpful..
Glad you liked ✅️
Rishabh bhai.
i am fully understand this concept ( inner join ,Left join ,Right join ,Full Outer join )
Thanku again
you are explanation osam ..........N/
Glad you liked it ✅️
Very well explained sir appreciate..mishra ji
Glad you liked ✅️
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
Glad you liked ✅️
easy to understand thank you !!!!
Glad it helped! ✅️
Suupperbb class sir❤, amazing video👌
Glad you liked ✅️
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.
yes that's correct (y). values should match not column names- what i mentioned in the video was an example
Thank you for this amazing explanation!!
Glad it was helpful! ✅️
I was able to tackle first round of interview after this session..thank u .. ❤
Keep it up 🚀
One of the best explanations I have ever seen, thank you, sir.
Glad it was helpful! ✅️
Great video man!
Glad you liked it! ✅️
Honestly speaking I never came across such a great explanation. Keep up your great work sir 😊
Glad it's helpful ✅️
thank you for best explanation
Glad you liked ✅️