Thank you so much sir, sql join ka coms- ke liye hum ne UA-cam ka 10 se jada challe ki videos dekh Liya but samaj nehi paye aapke ...1 video me pura complete samaj a Gaya ....tq once again
The explanation is thoughtful! I have read many articles and videos, but this kind of query in JOINS has been insightful. I have a few questions. While using Joins is to get to merge two or more tables, then why are you using WHERE in the beginning. We can use only one table and will get the result. But here, in the beginning, there are two tables, and you are using WHERE. That means we can use WHERE in another result also. Please let me know if I'm thinking in the wrong direction!
Sir, it was very insightful and helpful. Great initiative from Great learning ..this course very helpful. Please come with more basic courses of SQL in parts of 1hr length maximum. So that we can learn better.
we can also join 3 tables using following command : select e1.first_name , e1.last_name , e2.dept_name from employee as e1, department as e2 , emp_dept as e3 where e1.emp_id = e3.emp_id and e1.emp_id = e2.emp_id;
Sir , I want to ask that at 33:20 you said we can do it via inner join too but sir we can also do it via Full outer join too incase we are not doing via natural join.
Sir can u uploaded full SQL video in hindi that's means jo data analytics ke liye use hota with examples .bahut helpfull hoga agar aap full SQL ka video banaye
Thank you, we're glad we could help you😇 Subscribe to our channel for more such content, and hit the bell icon so you are always notified of updates from us!
Sir please I tried to listen to other channels about analytical functions but you know they are making me cry 😭😭😭 they are not as good as you no proper explanation.i have searched in videos sir but no video about analytical please 🙏sir make a video on this
I am very thankful to you for such a great explanations but I don't understand, what is use of 'Cross Join and Self Join'. If possible, please explain. Its beyond my knowledge and understanding.
Thank you very much for such informative video and explaining in detail and making every concept easy to understand! If you can provide some exercise files for practice, it'll be more beneficial!
Hello dear I am confusing with question When I read any question so I can’t understand which join should I use so please tell me this how I recognise which join should I use
Ur last few seconds in which u r joining 3 tables but ram kumar is working on department 2 and 3 which means in developing and sales...but ur result shows that ram is working in HR 2 times which is wrong.
🔥 Get your free certificate of completion for the MySQL Basics Course, Register Now: glacad.me/3z71m2k
Lo lo i
bhai aap ko dil se salute aaap ne mera problem solve kr diya thanku so much
Literally I have No words for comments,this is the perfect video ,i clear my whole concept about joins in only one video.Thanks a lot sirr!!!
Thank you so much sir, sql join ka coms- ke liye hum ne UA-cam ka 10 se jada challe ki videos dekh Liya but samaj nehi paye aapke ...1 video me pura complete samaj a Gaya ....tq once again
Sir, I am the beginner, and the way you explained the Join concept was really awesome, great help for me Thanks.
Hello sir,
I am from non IT field and after learning a language , this lecture is very useful for further learning
gone through so many videos but this is the best to understand.THANK YOU
Awesome explanation...I had been confused over the join since beginning, but your video made my concept crystal clear...Thanx a lot
लय भारी सर👍👌
You are great, thanks for creating a video in Hindi, its very usefull for me.
the lecture is very amazing. i understand all concepts. next week my exams start and your video really helps me a lot
One of the best video on Joins in Hindi....❤️
Thank you Great Learning ❣️😊
All my doubts are cleared now.Thanks for the video.
Now thats what we call teaching skills .......❤
Explanation style is very nice ...Thank You
Thanks.. Superbly explain.. Simple and sweet
In one word... Thank you so much.
your video really cleared my concept about joins brother.
Thanks alot for making such content.
We appreciate it.
👏👏
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thank you sir for this teaching us this concept easily and simply
this was the the great explanation ever..god bless u
The explanation is thoughtful! I have read many articles and videos, but this kind of query in JOINS has been insightful. I have a few questions. While using Joins is to get to merge two or more tables, then why are you using WHERE in the beginning. We can use only one table and will get the result. But here, in the beginning, there are two tables, and you are using WHERE. That means we can use WHERE in another result also.
Please let me know if I'm thinking in the wrong direction!
Sir, it was very insightful and helpful. Great initiative from Great learning ..this course very helpful. Please come with more basic courses of SQL in parts of 1hr length maximum. So that we can learn better.
REALLY REALLY GREAT VIDEO. THANK YOU SO MUCH
UA-cam pe isse accha video koi nhi
Thanks sir bahut ache tariike se samjaya apne..
bahut badhiya bataya hai bhaiya ji. Full bhukaaal 🔥🔥🔥
Thank you so much bhaiya ❤️❤️
Self join thoda confusion hua but theek h maza aa gaya... Thanks
we can also join 3 tables using following command :
select e1.first_name , e1.last_name , e2.dept_name from employee as e1, department as e2 , emp_dept
as e3 where e1.emp_id = e3.emp_id and e1.emp_id = e2.emp_id;
Thanks a lot for your valuable session...
very Useful video .Thank you
I searched for simpler explanation in many websites, This was the best sir. thank you.
Sir , I want to ask that at 33:20 you said we can do it via inner join too but sir we can also do it via Full outer join too incase we are not doing via natural join.
Well explained, no need watch another videos for beginners
Very well explained
THANK YOU SO MUCH SIR:)
One of the best videos on joins, very easy to learn
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
thankyou so much sir for make this video this video saved my 4 to 6 hrs this is the best i got on youtube today thanks again sir.
this is the best video i have seen for this topis,do you have dsa course also.
Very beautifully and easily explained.
Indeed
Thank you very much !
Brilliantly explained brother. Really awesum
Sir can u uploaded full SQL video in hindi that's means jo data analytics ke liye use hota with examples .bahut helpfull hoga agar aap full SQL ka video banaye
Yaa it's opening an interest and explanation is also very simple that everyone can understand..like a true teacher..thank you sir
one of the best lecture in youtube
Great Explanation sir. Please create full sql course vedio..
It's such a very simple way
I AM PAYING FOR 2 LAKH FOR THE COURSE BUT YOU ARE BETTER THAN AL THOSE ACADEMIC
TEACHERS
Really appreciative
Great explanation in a very easy way to understand by a beginner. I had confused since I heard the term. Thank you Sir.
Perfect video for joins
Thank you soo much Great Learning ❤️
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Guys bestest video must watch ❣️
Great job brother appreciate your efforts well teaching...❤
Request for same functions of sql server.
Great learning is the great
I revised my concepts 💟💌💕❣️
Thank you, we're glad we could help you😇 Subscribe to our channel for more such content, and hit the bell icon so you are always notified of updates from us!
This lecture is very useful
thank you, really helpful.
Wow really wonderful video sir. I really got all the required knowledge which I wanted in joins
Explained very well
valuable info.
mindblowing video
Awesome video sir .i like to your teaching way ....thank you thank you so muchhhhhhh 😊😊
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Superb video 🤩.
I really liked it.
Thank you so much sir🎉😇
Best video for Sql joins
Sir please I tried to listen to other channels about analytical functions but you know they are making me cry 😭😭😭 they are not as good as you no proper explanation.i have searched in videos sir but no video about analytical please 🙏sir make a video on this
Best video on join
I am very thankful to you for such a great explanations but I don't understand, what is use of 'Cross Join and Self Join'. If possible, please explain. Its beyond my knowledge and understanding.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
great explanation
Thank you sir it is very helpful
thanku so much 🙏
great job brother...rightly said great learning!!
Thank you sir ...💖💖
Thank you very much for such informative video and explaining in detail and making every concept easy to understand!
If you can provide some exercise files for practice, it'll be more beneficial!
Thnks for uploding a video ❤
if we do the code with the help of natural join ,thats is very simple then why we use ,inner join or left join or right join ....can you please help
Great video sir please make on full SQL🙏🙏
Hi Please follow the link to watch SQL full course: ua-cam.com/video/PApdxLedQoc/v-deo.html
thank you, this is gem gold
simple explanation
Hello dear
I am confusing with question
When I read any question so I can’t understand which join should I use so please tell me this how I recognise which join should I use
Sir create table pey bhi ek video bana dijiye please
Wow yar al clear
Very nice 👍 awesome 👍👍👍👍
Plz make video also on subquery with easy & medium level practice problem.
does these queries also work on MySQL
sir, please make a video on PHP 7 new features.
Concept clear
Thank you for the video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
sir Oracle Application Express ko kaise use kare iss pe ek tuition pls..
Nice video
sir can u explain min,max,average function video
hello sir ,
one table is one row to apply join using self fliter how to find?
wonderful sir ji
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
do we have more videos from same instructor ? what is his name? Thanks
in department table instead of EMP_ID there is DEP_ID
Sir advance java ka toutial hai kya apka
u r awesome brother
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
sir 3 table join , aur same mein two table join mein inner join use hua h par amp_id column 2 or 3 Baar repeat kyun nahi hua.
Great video
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
thank you so much sir ji
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Ur last few seconds in which u r joining 3 tables but ram kumar is working on department 2 and 3 which means in developing and sales...but ur result shows that ram is working in HR 2 times which is wrong.
Nice
Could tell us more about cross join