SQL Joins Tutorial For Beginners | Inner, Left, Right, Full Join | SQL Joins With Examples | Edureka

🔥 Edureka MYSQL DBA Certification Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): www.edureka.co...
This Edureka video on SQL Joins will discuss the various types of Joins used in SQL Server with examples.
The following topics will be covered in this video:
0:54 Introduction to SQL
1:40 What are Joins?
2:11 Types of Joins
14:58 FAQs about Joins
Subscribe to our channel to get video updates. Hit the subscribe button above: goo.gl/6ohpTV
Join Edureka’s Meetup community and never miss any event - KZbin Live, Webinars, Workshops etc. bit.ly/2EfTXS1
#edureka #edurekasql #sqljoins
--------------------------------------------------------------------------------------------------------
Instagram: / edureka_learning
Facebook: / edurekain
Twitter: / edurekain
LinkedIn: / edureka
SlideShare: www.slideshare...
-------------------------------------------------------------------------------------------------------
How does it work?
1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!
- - - - - - - - - - - - -
About the Course
MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.
- - - - - - - - - - - - -
Who should go for this course?
This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - -
Project
In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :-
• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.
- - - - - - - - - - - - -
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.
For more information, Please write back to us at [e-mail] or call us at IND: 9606058406 / US: 18338555775 (toll free).

[@edurekaIN]

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: bit.ly/2B5EwLJ

[@aashitanoah7464]

I'm so thankful to be born in an era where resources like these are available for free :)

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@KR7SH1455]

thanks for this video ❤💘

[@amanbhargavaofficial]

Best KZbin Channel😍😍😍

[@edurekaIN]

Thank you so much for the review ,we appreciate your efforts : ) We are glad that you have enjoyed your learning experience with us .Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@Momo-qr3rd]

Thank you very much, Edukera is one of the best youtube chanels

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@jaiswalniket]

I am so grateful to this resource. Well Explained.

[@edurekaIN]

Thank you 😊 Glad it was helpful!!

[@mohammedtariq6110]

This video is so Heplful. Thnak you! edureka

[@edurekaIN]

You're Welcome 😊 Glad it was helpful!! Keep learning with us..

[@rayapatikadapa7323]

I will definitely buy course in edureka superb explaining

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@tejashwinihampannavar8398]

Thanku Mam🙂

[@edurekaIN]

You are welcome . Glad it was helpful!

[@amanbhargavaofficial]

Thank you very much😊😊😊😊

[@edurekaIN]

Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)

[@amanbhargavaofficial]

Great👍👏😊😊😊😊😊👍👍👍👍

[@edurekaIN]

Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@shwetapatil1362]

Thankyou for this video..very clear and undetanding information!

[@edurekaIN]

You're welcome 😊 Glad it was helpful!! Keep learning with us..

[@sadasivaraovennam4869]

Excellent Sahiti. Explained so well.

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@sharathlingam3444]

The best explanation I personally found on the web. Thank you!!!

[@edurekaIN]

You are welcome 😊 Glad it was helpful!

[@PropaneIsLife]

Great job, thank you!

[@edurekaIN]

You are 😊 Glad it helped !! and Keep learning with us

[@tellurmumgotohell]

Thank you very much for explaining this, you did a better job than my school teacher.

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@mujtabakhan4521]

thank you💖💖💖💖💖💖

[@shallusingh3082]

Excellent Session to understand the Basics 🙂

[@edurekaIN]

Glad it was helpful!

[@rajat1999gupta]

atlast this concept is clear for me, thank you

[@abdulkayumshaikh5411]

Thank you so much for this join tutorial #edureka

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@sandhyaharsha5774]

pretty clear thank you

[@edurekaIN]

Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)

[@theweirdclub3945]

Thanks this was helpful

[@edurekaIN]

Thank you😊 Glad it was helpful!! Keep learning with us..

[@238remo]

It is very nice and very helpful

[@edurekaIN]

You're Welcome 😊 Glad it was helpful!!

[@michaelchiz8055]

I enjoyed this

[@roshnray6566]

Such platforms really eradicated dependency from the folks who not used to share the knowledge after multiple polite requests 😊

[@edurekaIN]

We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !

[@vinayaksharma-ys3ip]

Thank You ma'am very much@!!👍

[@edurekaIN]

Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )

[@nikhilgarg009]

Thank you so much for making Joins easy to understand...

[@edurekaIN]

You are welcome👍

[@xPain91]

Thanks it helped me to understand INNER JOIN and find a solution for my task :)

[@vinaymishra6659]

Wow good

[@umermib3058]

You have saved my day thank you so much edureka and the instructor for this clear explanation

[@edurekaIN]

We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@dipteshbehera9111]

Thank you .I need to hands on these joins for more clarity . Please suggest how to proceed.

[@edurekaIN]

Thanks for showing interest in edureka ! kindly go through our channel for more information

[@spiritualquest6092]

Simply amazing tutorial, very skillful tutor!

[@tanvirhasanmonir1627]

Thanks a lot. Compressed full lessons on join.

[@ekanshmishra4517]

THANK YOU👍 Just one word for all the efforts, knowledge, research,and way to explaination.

[@fobembe]

Great Job. Concise and straight to the point.

[@evanbaker783]

This is a great help! Thank you!

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@webdevfreetutorials8501]

best explanation so far, thanks

[@guptasridhar9492]

Thanks a lot for this vedio, i really got a idea about the joins

[@rusanmaharjan5879]

Thank you so much it helped me for my viva..

[@daneshsharrma8855]

The examples helped me understand, thank you very much for the informative video.

[@edurekaIN]

Thank you so much for your review on our channel  Great to hear that Edureka is helping you learn better . We’ll strive to make even better learning contents/courses in the future ! Do subscribe the channel for more updates : )

[@nvkchannel8201]

awesome...thanks dear

[@edurekaIN]

Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)

[@davida6146]

Looking at the SQL query at 3:16 , does the Table matter for which one you choose to retrieve "FROM" and which one you choose to "INNER JOIN" ? or does it have to be first table, second table always?

[@edurekaIN]

Hi David, No the order of table doesn't matter for inner joins. However it does matter for the outer join commands.

[@ucfjeans2911]

good video...pls keep sharing....thanks very much

[@yashgupta8336]

thanku so much very clear and concise

[@sandhyareddy9122]

Thank you thank you mam.very clear explanation.learned about joins from ur video got full clarity

[@amitkumarswengineer5004]

Nice session

[@ashutoshverma6431]

Nice Explanation...!Loved it

[@ninorinney9217]

Thank you very much for the explanation and the examples, your effort is much appreciated. :)

[@edurekaIN]

Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@navdeepsinghchauhan7607]

thanks a lot

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@vijayjangid8967]

Thank you so much

[@maven558]

Perfectly executed thank you

[@parashuramrv6729]

simple and clear ma'am thank you , could you please do a session on hibernate and spring

[@edurekaIN]

Hi Parashuram, thanks for the appreciation. We will definitely look into your suggestions. Do subscribe to our channel and stay connected with us. Cheers!

[@ranjinithiru9898]

hi.. you have explained very clearly about joins thanks a lot it helped me to understand well...

[@parthabora6515]

Thank you for the in-detail explanations.

[@niranjanparida9795]

Great explanation ....................

[@sukumar4920]

Gr8 Session. Thank You👍

[@edurekaIN]

Hi Kumar, thanks for appreciating our efforts! Do subscribe, like and share to stay connected with us. Cheers :)

[@sanjeetsangale8720]

mam can you please provide the example pdf to us so that it becomes more easy to understand for all of us.thank you so much..

[@edurekaIN]

Hi ! Good to know that our videos are helping you to learn better :) Please share your mail id to share the data sheets :)We’ll update you soon . Do subscribe the channel for more updates : )

[@abhishekrayavarapu]

Excellent Tutorial, Thumbs Up

[@sizwemsimango9208]

Clear and simple presentation making the information easy to follow, absorb and understand. Thank you

[@sudheshsankarkk]

Thank you for sharing 🙏

[@koikariuki4400]

thanks this was so easy to understand

[@akhilsuresh6593]

Super class. Helpful ma'am. Thank you ma'am 😊

[@edurekaIN]

Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@manishchoudhary8384]

Best video that can explain Joins . Such a crucial topic in such a easy explanation

[@Jagdish96-f9b]

Superb explanation

[@Mumbaikar547]

Thank You 😊 This video was helpful cleared so many concepts.

[@kasthuri2730]

Mam, your teaching flow very helpful. thanks for this video..

[@vikkijogalvin]

Great video!

[@motivationforthomas]

I am new to sql, Correct me If I am wrong. So the natural join is better than inner join because it reduces/ignores the redundant column. My question is that why do we need to select the same column from different table in an inner join as said in your example. The next question is what if we select the same column twice in a query while using natural join will it reduce the redundant column or not.

[@anuragbawankar685]

Thanks a lot !!!!

[@edurekaIN]

Many thanks! Glad you liked it ! We are glad to have learners like you . Do subscribe our channel and hit that bell icon to never miss an video from our channel .

[@udaykiran-rh8es]

make a video based on sub queries please

[@edurekaIN]

Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update

[@MohamedElsayed-fv2kp]

Thank you so much, Please where can I get the slides ?

[@edurekaIN]

Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@DazzleCo]

Very Helpful session. Thanks for sharing.

[@SurendraYadav-hb7cy]

Very nice information

[@ayodamolaolusanya7213]

Awesome video @edureka, where can one get the database or exercise files from

[@edurekaIN]

Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@dory1997]

For an inner join - what if the same employee was on multiple projects? How would that effect the output?

[@rbern412]

Thanks for the detailed explanation.

[@mounikayathakula8585]

mam at 16:49 when we do inner join we will got only common records from both tables right.. but output only A Rcord shoud have to come, But why C &B came.. i got confused could you reply me with solution.. Thanks for Advance

[@ameylokhande9918]

Thank you so much! The concepts explained were on point.

[@lewellenpereira6437]

Thanks it's every helpful ❣️

[@sivaramkrishnan3852]

@edureka : Is their a SQL training course by this instructor?

[@edurekaIN]

Hi Siva, here is a link to our SQL training module bit.ly/2H8EWXH, keep learning with us, cheers !!

[@srujangowda8490]

TOP CLASS

[@samkodag4454]

Hello ma'am, For data analyst what SQL commands, methods are used.

[@edurekaIN]

Hi Sam, you need to have a thorough knowledge of basic commands like triggers, views, stored procedures, set operations and joins. You can refer this article for more: www.edureka.co/blog/sql-commands

[@endone3661]

fantastic !!!. XD

[@MohseenAttarVlogs]

Could you share this data to practice

[@edurekaIN]

Ok sure :) Please share your email id with us for to share the code

[@mrz3134]

did a better job than my college 💀

[@edurekaIN]

😊 Glad it was helpful!

[@glennv.merkel3020]

superb explanation and amazing animations 😍😍😍😍

[@edurekaIN]

Hey Peter, thank you for appreciating our efforts. We are glad you loved our video. Do subscribe to our channel and stay connected with us. Cheers!

[@krishnathulasimeegada4123]

Thanaku mam

[@muralikumar3016]

Great info but please do a video on all keys on keys in SQL

[@edurekaIN]

Thank you for the compliment. We will process your request soon. Do subscribe to our channel and stay connected with us. Cheers :)

[@satjotsingh6026]

Hi, When i tried to start the comment with SELECT * FROM followed by table name, it does not auto-populate as shown in video. Can you please help with it

[@ucfjeans2911]

thanks for sharing...nice video

[@priyankapanda2276]

good content...

[@rufiladhani7822]

In inner joins and full outer join which table should come after from. In short does the order matters?

[@edurekaIN]

For INNER joins, no, the order doesn't matter. The queries will return same results, as long as you change your selects from SELECT * to SELECT a. But the order matters for (LEFT, RIGHT or FULL) OUTER joins. Hope that solves your query.

[@thepokergod1980]

Thank you! Very helpful.

[@naturist3020]

very well explained mam

[@linguafranca7834]

So basically we have to know the matching column in both tables to apply inner join.

[@anandanhumanoid]

Thankyou

[@lifeissnowpiece4505]

Thank you but close title on video

[@edurekaIN]

Thanks you for showing interest in Edureka and Thanks for you priceless suggestions & feedbacks :) DO subscribe for more updates and videos to come

[@pawandubey6245]

Why can't we use left join as right join by changing the order of two tables?

[@edurekaIN]

Hi Pawan, right and left outer joins are functionally equivalent. Neither provides any functionality that the other does not, so right and left outer joins may replace each other as long as the table order is switched.

[@sriramch3128]

Can u provide the dataset?

[@edurekaIN]

Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )

[@sigmaphysicsclasses3232]

Thanks mam.