Lec-69: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL

[@ny2964]

Like am getting addicted to your videos 😂 ! Like seriously how perfect a clss can ne!?

[@mdaaweshpatanwala8542]

+1

[@rameshmalhotra9525]

th-cam.com/video/5FsIa4Mp3ho/w-d-xo.html🙏🏻🙏🏻

[@hridaybhatia5643]

💯

[@zeeshannadeem6319]

I'm from pakistan.I just want you to read this.I got A grade in my university exams in operating system just because of you.Couldn't understand what my teacher was teaching in class.So thankyou for your existence.God Bless you

[@GateSmashers]

Ohh Great..Congratulations Zeeshan..Keep growing..lots of love and blessings

[@manishajadhav9099]

@@GateSmashers tyttru ryt ans me trttytytytyy btytyt you My ttyyyry you ttyytytytyyty you My btyyrttyrtyrtttytyybryyyrrtyrtyyytyyyyyyyyyyyyytytyyryyyrtyrtyytytb you My try Betty ttyytytytyyty Tyr ytttyryytyryyyyttryyttryrbyyybttyryryyytyrtyytytyrrtyrtyrytryrryryyryyyttyyyyyyttytyrtyryyrtrtyryytyryyryrtyruryyryttyttyrbytytrytyttytuytytyytyyyyytytyyryyryytrtyrtyyyrtyyyyttyyyyyyrytyrytyttrrtyyyyrytyrtyrtyyrryyttyrytrbrytyryrybtyyyyyyyyryrytty

[@krishankantmani817]

@@manishajadhav9099 ye kon c language hai ...

[@kundanbora5476]

@@manishajadhav9099 binod

[@universeboss4865]

@@manishajadhav9099 madam aap binod ho gyi h

[@prameelakurakula6253]

I'm getting too interested in DBMS and wanted to go depth.You are doing such a great job that is helpful to all upcoming students .
U deserve all this likes , comments and appreciation.Tq🙂

[@srijitanitamajumdar5904]

This representation of the different applications of the concepts that so frequently overlap in our minds, deserves one big Hats off!!

[@vinitakeer515]

You are too good sir...i am a faculty even I m learning teaching from you... Thanks a lot

[@GateSmashers]

Thank you sir for giving us feedback

[@hrishikeshmishra1929]

@@GateSmashers Sir she is Ma'am.

[@Farahat1234]

@@hrishikeshmishra1929 🤣🤣🤣🤣🤣🤣

[@kalashnikov203]

I came for a doubt video ended up watching the entire series, one of the best explanations thank you sir🙏

[@shoaibsarwar679]

The best explanation of subquery on the internet.

[@ha-bf2xh]

From Afghanistan, I feel so lucky that I understand Hindi !!!!
you have amazing content, keep it up!
if I were the dean of my school, I would bring this guy and pay him twice as much as our current instructor is getting paid.

[@nammi895]

Afghanistan and IT 🧐. Internet is a luxury in afgan, how can this ....

[@mohammedumarfarhan9900]

@@nammi895 Afghanistan is becoming a peaceful country brother

[@eren-qu9uu]

@@mohammedumarfarhan9900 really ? but news is telling different things

[@mohammedumarfarhan9900]

@@eren-qu9uu yaa again things r starting to get crumbled

[@eren-qu9uu]

@@mohammedumarfarhan9900 what do u think happen when taliban capture whole afghanisthan (which is more likely outcome of war)?
does people able to leave normal life when this will happen?

[@PythonisLove]

This video is very important. Everyone should watch this for University and GATE exams too

[@SouravDasgupta1983]

Such effortless teaching!! May god bless you!

[@fahmidaakter7595]

Excellent explanation Sir.I am a Assistant Professor but still learning from your videos.Stay blessed.

[@sudoupdate]

It really hurt me when this guy work so hard and make such amazing content and yet he has to request everyone to like his video.

[@shashanksharma7747]

sahi bola bhai

[@rameshmalhotra9525]

th-cam.com/video/5FsIa4Mp3ho/w-d-xo.html🙏🏻🙏🏻

[@nadeemullashaik3340]

True..

[@FalseYoutuber]

Sir bolo na thi guy kya hota hai

[@VRautulwar]

Subscribe karo, aur Kiya hai to ,aur devices se kro kyuki subscribers bhot jaruri hai😅😅

[@abhishekgupta4360]

Sir This is the best tutorial on SQL that I have ever watched. Great work.

[@shrishtyjain6971]

really its very helpful and concepts are so clearly explained

[@anuprakashsharma5518]

please make a video explaining simple assembly language programs, like adding two numbers etc.

[@vaibhavgupta8856]

A1 quality teaching! I am amazed and lucky to find this channel. Thanks a lot!

[@Be_Better_Than_Before]

Thanks, Sir
One more advantage of 'join' is you can use columns from the department table too in the select clause.
But in a subquery or correlated subquery we can only use columns from the employee table in the select clause.
Please correct me if I am wrong.

[@Vishalk_mandal]

I watched many of your videos ,but i would like to thank you million times specially for the videos on subquaries and concurrency control ( variant of 2PL, Timestamp ordering protocol)
, Thanks

[@debuvlogs20]

Thanks to you formaking these videos with elaborate things.I hope one day I get a good job in SQL.God Bless you.

[@bhanu9033]

Thank u sir for uploading continously lecture

[@shubhamkadam7224]

i can see ur efforts ,ur knowledge and ur interest in teaching in depth so that concept gets more and more clear and it feels nice to see ur passion towards teaching...god bless u sir and stay always healthy and share ur knowledge with us....we are always eager to see u on screen with new concepts new content...thank u so much!

[@abhilashwankhade5]

I would like to ask you one question is How would you make the decision of writing Nested query and co-related query?

[@sandip_1401]

best teaching in you tube 💝👍👍

[@sabuhiitrat9637]

World's Best TH-camr/Teacher/Helper.❤ Thankyouu so much

[@alekyas4256]

If tutor is such , students can understand rocket science also very easily... great job.

[@BhaskarBharali]

Your teaching method is very good, Thank you sir.

[@shubhamnigam14]

ek he to dil ❤ hai sir je kitti baar jeeetoge

[@thekidcook4015]

The way you are explaning is very awsome!!!!!!!!!

[@rsikchi2783]

exlanant teaching 🤞👏🏼👏🏼
All concepts are clear sir thank you for creating video on dbms
Zabardast

[@ankitkumar-ln3gs]

way of teaching is so good and clear all deep concept.

[@swati8201]

First time itte ache teacher mile hai hume, kash ap jase facility hame mil jatte to har koi topper bun jata..
Deep love and respect from me ❤️.

[@krishnatagore5750]

thanks a lot for this comparision video. I was confused and frustated from previous individual videos......

[@punamsoni9929]

that's amazing thought that we compare thing which have something common..

[@jovitalobo1273]

You are doing great work. Appreciate your knowledge and teaching skills..hats off. Thanks for sharing it with everyone

[@pushkarratnaparkhi2205]

You teach so well. You don't even need to ask for like. Great Job. Thanks

[@nitinvijaykar4022]

Excellent explanation sir.

[@mokshadakothari1265]

Amazing way of comparing !!

[@anasabbasi5449]

Thank you Sir

[@pgoswami1437]

really helpful video sir , thankyou so much

[@MadhuriKishorr]

Excellent teaching , Thank you sir

[@princeshetye7205]

brother I like all of your videos and share with my friends.....you give so much of efforts and is very easy for me to understand....god bless you guru

[@md.musfiqurrahaman8810]

Varun vaia, I am from Bangladesh. Your videos are helping me a lot. Please upload the remaining videos as soon as possible.

[@GateSmashers]

thank you dear..sure will upload soon

[@navjiwanhira3888]

Trade off between "Space" vs "Time"....Good one!!!

[@GarimaChaudhary-g7w]

Thank you for sharing your knowledge. Your channel is one of best tutorial channel I have come across. This is my first comment since I joined youtube.

[@ManpreetKaur-gk7ou]

Best explanation ever...thank you so much sir....m your fan now🥳🥳

[@me59080]

Great content from a great teacher.

[@prabhneetsingh13]

Thank you for this explaination, it was getting slightly confusing! Your work is really amazing!

[@mohammadasif3052]

very helpfull. Please explain how to use subquery in Left outer join. thanks.

[@animationcrust1993]

Thank you for your efforts ❤️🤗🙏

[@thanhvyho2195]

your explanation is suprisingly clear and detailed. subcribe immediately. Thank you so much

[@anamikashree6129]

Thanku soo much sir...your teaching style is awesome

[@hemantkumawat3144]

Really great ,always great 👍 teaching ,you tube will gives blessings 😀

[@chitrakgarg1114]

Good video...I just started watching your vdos... Can you please let me know diff b/w Varchar and nvarchar

[@gopalchaudhary6170]

Sir aap bahut hi achhe faculty ❤️🙏

[@avishgoswami2141]

Your teaching skills are really fabulous!!

[@GateSmashers]

Thank you so much.. Keep learning and sharing

[@mpanghal9801]

Thank you so much sir for great efforts
Keep it up👍👍

[@tushartyagi3943]

Thank you so much sir ! for delivering us the most organized content in a less amount of time ....which is becoming very very helpful to me right now
Thanks for your selfless support

[@radhe7511]

Thank you sm sir!!! All your videos are so helpful. When my clg teacher failed to explain these topics, you helped me! Thank you sm.

[@sanchitwadehra]

dhanyvad

[@rababzehra-f5i]

Tata comparison part was good!

[@kshitijsrivastava6148]

Great video!Thank you sir!

[@ravinakumaras5717]

Wonderful explanation

[@achillles6838]

Your videos literally changed my life

[@shahinparween3496]

Thank you sir

[@aditinageshwar3217]

Thank you so much sir 😃Your content help me a lot for gate preparation

[@mukulbansal8269]

good work sir

[@anjaligour9830]

Sir your video are really very helpful.... easiest explanation ever✨

[@PradeepYadav-fg2yg]

sir you are very good teacher and u really make learning fun....after every video i feel like we can't thankyou enough...but sad part is only 1lakh people have watched this amazing video...guys please share this playlist as much as u can this is the least we can do

[@computerlearner7344]

From all the students like me thanks from everyone's side.. plz share more knowledgeable things with us

[@Rafay.__.mughal615]

this guy is a legend
you made me pass dbms

[@SanketSharmasanket7317]

awesome

[@kss2066]

Big thanks for clear explanation of the concepts

[@md.masudrana4447]

Please sir solve this query:
Emp( id,name, dept_id,salary)
Dept(dept_id, dept name)
Find max salary and average salary for specifics dept.

[@geetanshusinghnegi2672]

Done Amazing work !! Thansk for this playlist

[@mahathivasuki4388]

Its very very useful. Thank you so much

[@ajmalkhaniit]

Thank you again
Time analysis BHI sath main bata diya Karen taki ek idea rahega ki query Kitna time lega execute hone ke liye

[@ArohiKc-np3jp]

Thank you bct engineering notes for suggesting me this channel. This was really helpful i understood the concept clearly and have successful created a project on relational database. Thank you Gate Smashers.

[@gauravbisen3456]

You are just too awsome
Concept looks too easy when you teach 😉😉😉

[@divyaagarwal3563]

Thankyou sir

[@worldofjoy121]

A nice example for compresion.

[@kunalsingh5794]

Sir please complete the series of computer organization and architecture

[@decodebyanshuvlogs194]

informative

[@bruceWayne19993]

One cannot explain better than this

[@rehanamulla6302]

Thank you for wonderful explanation

[@srinivasaprabhu6657]

Simple explanation thank you bro ...

[@usharani-lt9mt]

You ar doing such a great job u ar classes helped me lot

[@Ritik_Mangal]

Dhanya ho prabhu

[@diwaker8616]

Hi Varun, i found an issue if you can clarify in Correlated Subquery i.e.
select * from emp where exists (select id from dept where emp.e_id = dept.e_id);
in this Inner query from where we are counting 'id' from dept. table? From my side the query should be
select * from emp where exists (select e_id from dept where emp.e_id = dept.e_id);
Hope i could make sense.

[@sumukhas5418]

Very very helpful thankyou

[@lovishdhingra801]

i am seriously telling i was very frustated about this topic but your video make the conceppt clear

[@omkarbhandare7394]

sir can we do nested subquery for 3 tables if yes then plzz make a vedio on it

[@shreenavkhandelwal4168]

I guess time taken is same in all the queries because it Joins as well when we do cross product, number of rows becomes m*n and then we do 1 comparison for each row, therefore total number of comparisons remain m*n.

[@krishanudutta2943]

Hats off to u for ur hard work and dedication sir
Thank u so much for these amazing playlist

[@MrParshant007]

Amazing Explanation!!

[@GateSmashers]

Glad it was helpful!

[@saurabhtiwari287]

God of dbms

[@computerlearner7344]

Thank you so much sir... DDA me or videos upload kijiye na please.. you are the best I am great fan of you the way you teach... I promise I will share all your videos.. we want more from you... You are just adorable n great teacher

[@istiqueahmed3919]

It is 4y passed people are still learning from your videos. After 10y people will still learn from your videos...

[@takibahmed8859]

Hello sir, since the three query is doing the same work, can you explain which of the three will give fast result? And why? Thank you 💖💖

[@nishanthadda8824]

join then nested subquery then corelated subquery

[@swapnilchorge7990]

sir what if we have duplicate eid s in department table i.e. what if one employee is working in two depts, then correlated query will return duplicate values. great video overall

[@mohitgupta7341]

wow!.....Amazing bro.