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
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 : )
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 : )
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 : )
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 !
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 : )
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 : )
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 !
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 !
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 !
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:)
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 : )
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 : )
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 : )
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?
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
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 .
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.
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 : )
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
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 : )
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 : )
Hi Parashuram, thanks for the appreciation. We will definitely look into your suggestions. Do subscribe to our channel and stay connected with us. Cheers!
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 : )
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
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
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 : )
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.
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 : )
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 : )
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.
try explaining a little slowly while you show how to code cz some guys here just come for that part only and you just copied that part where you could have explained a bit more
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
I'm so thankful to be born in an era where resources like these are available for free :)
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 : )
thanks for this video
❤💘
Best RUclips Channel😍😍😍
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 : )
This video is so Heplful. Thnak you! edureka
You're Welcome 😊 Glad it was helpful!! Keep learning with us..
Thanku Mam🙂
You are welcome . Glad it was helpful!
I am so grateful to this resource. Well Explained.
Thank you 😊 Glad it was helpful!!
I will definitely buy course in edureka superb explaining
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 : )
Great job, thank you!
You are 😊 Glad it helped !! and Keep learning with us
Excellent Sahiti. Explained so well.
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 !
Thank you very much😊😊😊😊
Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)
I enjoyed this
Great👍👏😊😊😊😊😊👍👍👍👍
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 : )
thank you💖💖💖💖💖💖
Thanks this was helpful
Thank you😊 Glad it was helpful!! Keep learning with us..
Thank you so much for this join tutorial #edureka
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 : )
Thank you very much, Edukera is one of the best youtube chanels
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 !
atlast this concept is clear for me, thank you
The best explanation I personally found on the web. Thank you!!!
You are welcome 😊 Glad it was helpful!
pretty clear thank you
Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)
Excellent Session to understand the Basics 🙂
Glad it was helpful!
Thankyou for this video..very clear and undetanding information!
You're welcome 😊 Glad it was helpful!! Keep learning with us..
It is very nice and very helpful
You're Welcome 😊 Glad it was helpful!!
Nice session
best explanation so far, thanks
Thank you .I need to hands on these joins for more clarity . Please suggest how to proceed.
Thanks for showing interest in edureka ! kindly go through our channel for more information
Such platforms really eradicated dependency from the folks who not used to share the knowledge after multiple polite requests 😊
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 !
Thank You ma'am very much@!!👍
Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
Thanks a lot. Compressed full lessons on join.
Thank you so much for making Joins easy to understand...
You are welcome👍
Wow good
Thank you so much
Thank you very much for explaining this, you did a better job than my school teacher.
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 !
awesome...thanks dear
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:)
This is a great help! Thank you!
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 : )
Great Job. Concise and straight to the point.
Great explanation ....................
thanks a lot
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 : )
Perfectly executed thank you
thanku so much very clear and concise
You have saved my day thank you so much edureka and the instructor for this clear explanation
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 : )
Thanks it helped me to understand INNER JOIN and find a solution for my task :)
Thank you for sharing 🙏
Superb explanation
Thank you so much it helped me for my viva..
good video...pls keep sharing....thanks very much
thanks this was so easy to understand
Thanks a lot for this vedio, i really got a idea about the joins
Simply amazing tutorial, very skillful tutor!
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?
Hi David, No the order of table doesn't matter for inner joins. However it does matter for the outer join commands.
Nice Explanation...!Loved it
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
Great video!
Thanks a lot !!!!
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 .
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.
Excellent Tutorial, Thumbs Up
Gr8 Session. Thank You👍
Hi Kumar, thanks for appreciating our efforts! Do subscribe, like and share to stay connected with us. Cheers :)
For an inner join - what if the same employee was on multiple projects? How would that effect the output?
The examples helped me understand, thank you very much for the informative video.
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 : )
Very nice information
make a video based on sub queries please
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
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..
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 : )
Thank you so much, Please where can I get the slides ?
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 : )
simple and clear ma'am thank you , could you please do a session on hibernate and spring
Hi Parashuram, thanks for the appreciation. We will definitely look into your suggestions. Do subscribe to our channel and stay connected with us. Cheers!
Thank you for the in-detail explanations.
Thanaku mam
THANK YOU👍
Just one word for all the efforts, knowledge, research,and way to explaination.
hi.. you have explained very clearly about joins thanks a lot it helped me to understand well...
Thank you thank you mam.very clear explanation.learned about joins from ur video got full clarity
TOP CLASS
@edureka : Is their a SQL training course by this instructor?
Hi Siva, here is a link to our SQL training module bit.ly/2H8EWXH, keep learning with us, cheers !!
did a better job than my college 💀
😊 Glad it was helpful!
Awesome video @edureka, where can one get the database or exercise files from
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 : )
Thanks for the detailed explanation.
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
Could you share this data to practice
Ok sure :) Please share your email id with us for to share the code
Hello ma'am,
For data analyst what SQL commands, methods are used.
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
Very Helpful session. Thanks for sharing.
Thank you very much for the explanation and the examples, your effort is much appreciated. :)
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 : )
fantastic !!!. XD
Clear and simple presentation making the information easy to follow, absorb and understand.
Thank you
In inner joins and full outer join which table should come after from. In short does the order matters?
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.
Mam, your teaching flow very helpful. thanks for this video..
Thanks it's every helpful ❣️
very well explained mam
Thankyou
thanks for sharing...nice video
Thank you! Very helpful.
Can u provide the dataset?
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 : )
good content...
Thank you but close title on video
Thanks you for showing interest in Edureka and Thanks for you priceless suggestions & feedbacks :) DO subscribe for more updates and videos to come
Great info but please do a video on all keys on keys in SQL
Thank you for the compliment. We will process your request soon. Do subscribe to our channel and stay connected with us. Cheers :)
Best video that can explain Joins . Such a crucial topic in such a easy explanation
-1! so lean explanation!
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 : )
Thank you so much! The concepts explained were on point.
Tq
Why can't we use left join as right join by changing the order of two tables?
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.
So basically we have to know the matching column in both tables to apply inner join.
Thanks mam.
try explaining a little slowly while you show how to code cz some guys here just come for that part only and you just copied that part where you could have explained a bit more