Lec-69: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
HTML-код
- Опубликовано: 5 авг 2024
- 👉Subscribe to our new channel: / @varunainashots
0:00 - Introduction
1:05 - Nested Subquery
1:37 - Example
6:54 - Nested Subquery
9:39 - Correlated Subquery
12:29 - Joins
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RUclips: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
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
Ohh Great..Congratulations Zeeshan..Keep growing..lots of love and blessings
@@GateSmashers tyttru ryt ans me trttytytytyy btytyt you My ttyyyry you ttyytytytyyty you My btyyrttyrtyrtttytyybryyyrrtyrtyyytyyyyyyyyyyyyytytyyryyyrtyrtyytytb you My try Betty ttyytytytyyty Tyr ytttyryytyryyyyttryyttryrbyyybttyryryyytyrtyytytyrrtyrtyrytryrryryyryyyttyyyyyyttytyrtyryyrtrtyryytyryyryrtyruryyryttyttyrbytytrytyttytuytytyytyyyyytytyyryyryytrtyrtyyyrtyyyyttyyyyyyrytyrytyttrrtyyyyrytyrtyrtyyrryyttyrytrbrytyryrybtyyyyyyyyryrytty
@@manishajadhav9099 ye kon c language hai ...
@@manishajadhav9099 binod
@@manishajadhav9099 madam aap binod ho gyi h
Like am getting addicted to your videos 😂 ! Like seriously how perfect a clss can ne!?
+1
ruclips.net/video/5FsIa4Mp3ho/видео.html🙏🏻🙏🏻
💯
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🙂
This representation of the different applications of the concepts that so frequently overlap in our minds, deserves one big Hats off!!
The best explanation of subquery on the internet.
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!
Sir This is the best tutorial on SQL that I have ever watched. Great work.
I came for a doubt video ended up watching the entire series, one of the best explanations thank you sir🙏
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.
sahi bola bhai
ruclips.net/video/5FsIa4Mp3ho/видео.html🙏🏻🙏🏻
True..
Sir bolo na thi guy kya hota hai
Subscribe karo, aur Kiya hai to ,aur devices se kro kyuki subscribers bhot jaruri hai😅😅
Such effortless teaching!! May god bless you!
A1 quality teaching! I am amazed and lucky to find this channel. Thanks a lot!
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
This video is very important. Everyone should watch this for University and GATE exams too
Thanks to you formaking these videos with elaborate things.I hope one day I get a good job in SQL.God Bless you.
Thank you for this explaination, it was getting slightly confusing! Your work is really amazing!
really its very helpful and concepts are so clearly explained
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.
Afghanistan and IT 🧐. Internet is a luxury in afgan, how can this ....
@@nammi895 Afghanistan is becoming a peaceful country brother
@@mohammedumarfarhan9900 really ? but news is telling different things
@@eren-qu9uu yaa again things r starting to get crumbled
@@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?
You are too good sir...i am a faculty even I m learning teaching from you... Thanks a lot
Thank you sir for giving us feedback
@@GateSmashers Sir she is Ma'am.
@@hrishikeshmishra1929 🤣🤣🤣🤣🤣🤣
You are doing great work. Appreciate your knowledge and teaching skills..hats off. Thanks for sharing it with everyone
Excellent explanation Sir.I am a Assistant Professor but still learning from your videos.Stay blessed.
From all the students like me thanks from everyone's side.. plz share more knowledgeable things with us
way of teaching is so good and clear all deep concept.
Excellent teaching , Thank you sir
Thank u sir for uploading continously lecture
Great video!Thank you sir!
Great content from a great teacher.
I would like to ask you one question is How would you make the decision of writing Nested query and co-related query?
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
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 ❤️.
Amazing way of comparing !!
Thank you for your efforts ❤️🤗🙏
Hats off to u for ur hard work and dedication sir
Thank u so much for these amazing playlist
please make a video explaining simple assembly language programs, like adding two numbers etc.
You teach so well. You don't even need to ask for like. Great Job. Thanks
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.
really helpful video sir , thankyou so much
Really great ,always great 👍 teaching ,you tube will gives blessings 😀
Thank you so much sir for great efforts
Keep it up👍👍
that's amazing thought that we compare thing which have something common..
best teaching in you tube 💝👍👍
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.
Big thanks for clear explanation of the concepts
Thanku soo much sir...your teaching style is awesome
Done Amazing work !! Thansk for this playlist
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
Thank you for wonderful explanation
your explanation is suprisingly clear and detailed. subcribe immediately. Thank you so much
Your teaching method is very good, Thank you sir.
The way you are explaning is very awsome!!!!!!!!!
Thank you so much sir 😃Your content help me a lot for gate preparation
Best explanation ever...thank you so much sir....m your fan now🥳🥳
Sir your video are really very helpful.... easiest explanation ever✨
Excellent explanation sir.
Its very very useful. Thank you so much
World's Best RUclipsr/Teacher/Helper.❤ Thankyouu so much
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
Thank you sir 🤗
If tutor is such , students can understand rocket science also very easily... great job.
You ar doing such a great job u ar classes helped me lot
Thank you !!!
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.
Wonderful explanation
thanks again- that was awesome
exlanant teaching 🤞👏🏼👏🏼
All concepts are clear sir thank you for creating video on dbms
Zabardast
Trade off between "Space" vs "Time"....Good one!!!
Sir you are the best, keep up the good work
Very helpful video..👍
Thank you Sir
Great video cleared all the 3 concepts properly 🙂
Great...
Simple explanation thank you bro ...
ek he to dil ❤ hai sir je kitti baar jeeetoge
thanks a lot for this comparision video. I was confused and frustated from previous individual videos......
You are just too awsome
Concept looks too easy when you teach 😉😉😉
Thankyou sir
Thanks sir...
This is what I was searching for.........❤❤
Gurujee shandar jabardast zindabaad
Good work man, keep it up.
wow!.....Amazing bro.
Thanks, you are amazing.
dhanyvad
Thank you sir.
this guy is a legend
you made me pass dbms
Thankuu you so much sir ji❤❤❤
A nice example for compresion.
I need classes for it and I love the way u teach
Sir aap bahut hi achhe faculty ❤️🙏
Awesome!!!!!!
OMG OMG OMG OMG i need this
Superb explanation varun bro
Your videos literally changed my life
Very very helpful thankyou
very helpfull. Please explain how to use subquery in Left outer join. thanks.
mind blowing vid
Very helpful😊
Thanks sir
you are really great dada......from bangladesh love you so much
awesome
You really deserve a thumbs-up 💕☺.