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 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 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 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 !
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 : )
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 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 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 : )
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 .
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
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 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 : )
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 : ) 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, 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
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 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
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.
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 : )
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
❤💘
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!
Best TH-cam 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 : )
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 : )
Thanks a lot. Compressed full lessons on join.
The best explanation I personally found on the web. Thank you!!!
You are welcome 😊 Glad it was helpful!
Great job, thank you!
You are 😊 Glad it helped !! and Keep learning with us
atlast this concept is clear for me, thank you
I enjoyed this
thank you💖💖💖💖💖💖
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 :)
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 !
Thanks it helped me to understand INNER JOIN and find a solution for my task :)
Excellent Session to understand the Basics 🙂
Glad it was helpful!
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 : )
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 !
Great Job. Concise and straight to the point.
Simply amazing tutorial, very skillful tutor!
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 :)
Perfectly executed thank you
Thankyou for this video..very clear and undetanding information!
You're welcome 😊 Glad it was helpful!! Keep learning with us..
THANK YOU👍
Just one word for all the efforts, knowledge, research,and way to explaination.
Thank you so much it helped me for my viva..
Thanks this was helpful
Thank you😊 Glad it was helpful!! Keep learning with us..
Thank you so much for making Joins easy to understand...
You are welcome👍
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 : )
Nice session
Wow good
Thanks a lot for this vedio, i really got a idea about the joins
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 !
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 : )
Thank you so much
best explanation so far, thanks
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 !
Superb explanation
Nice Explanation...!Loved it
It is very nice and very helpful
You're Welcome 😊 Glad it was helpful!!
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 : )
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 : )
Thank you for sharing 🙏
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 video!
thanks this was so easy to understand
thanku so much very clear and concise
good video...pls keep sharing....thanks very much
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:)
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!
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 : )
Thank you for the in-detail explanations.
Gr8 Session. Thank You👍
Hi Kumar, thanks for appreciating our efforts! Do subscribe, like and share to stay connected with us. Cheers :)
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
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 .
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.
Very nice information
TOP CLASS
Excellent Tutorial, Thumbs Up
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
Thanaku mam
Clear and simple presentation making the information easy to follow, absorb and understand.
Thank you
fantastic !!!. XD
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
For an inner join - what if the same employee was on multiple projects? How would that effect the output?
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 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 : )
Thankyou
good content...
Thanks for the detailed explanation.
Mam, your teaching flow very helpful. thanks for this video..
Very Helpful session. Thanks for sharing.
Best video that can explain Joins . Such a crucial topic in such a easy explanation
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 : )
Tq
Thanks it's every helpful ❣️
Thank you so much! The concepts explained were on point.
Thank You 😊 This video was helpful cleared so many concepts.
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 : )
very well explained mam
thank you
Thanks mam.
thanks for sharing...nice video
Super class. Helpful ma'am.
Thank you ma'am 😊
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 : )
Thank you! Very helpful.
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
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 : )
Could you share this data to practice
Ok sure :) Please share your email id with us for to share the code
So basically we have to know the matching column in both tables to apply inner join.
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
@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 !!
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.
-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 : )
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 :)
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
Gr8