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