Lec-126: How SQL Query executes?? Order of SQL Query Execution⏳🔄

►Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

[anshumandash]

Placement k time full apka dbms ka playlist dekha tha . Ajj job me 1 saal ho gaya, thank you sir

[inderpanda]

1. FROM - From where we will retrieve the data. (From employee table)
2. JOIN - Data retrieve from another more table. (From sales, From market)
3. WHERE - Using specific conditions (where city = "Delhi")
4. GROUP BY - Arranging similar row (Group by Department)
5. HAVING - Using specific condition on Group by data (Having count department _name > 2)
6. SELECT - Now the selection process starts (Select employee, count(department) as dpt_count)
7. DISTINCT - To show unique value in selection statement (Select Distinct(employee) as Unique_emp )
8. Order By - How to display the result (Order by dpt_count DESC)
9. Limit - How many rows we needed (Limit by 3)

[hostswap]

this is one of the best video in whole playlist.. thank you very much for this crystal clear

[dikshantsharma]

Thank you sir for maintaining my academics throughout my btech semester! Your lecture is just awesome ♥️

[jade]

thank you sir for updating the sql playlist, much appreciated 😁

[Hamza-Shreef]

though i don't understand Indian Language i felt it was really useful.
thank you bro

[jaydwarkadhish]

*HAPPY NAVRATRI SIR 🤗🤗🤗✨🎊🎇MA DURGA BLESS YOU AND YOUR FAMILY ♥AND GIVE YOU GOOD HEALTH, HAPPINESS 😊😇🙏🏻KEEP IT UP☺👌🏻👍🏻LOTS OF ♥♥♥FROM GUJRAT ✨*

[ComputechComputerBasics]

Thank you sir 😊
Your video is very useful 👍

[sayanmondal]

thank you sir, i was not understand those things in english .. you are really awesome

[jaydwarkadhish]

*SIR PLZ UPLOAD VIDIO ON "concepts of multithreads, benifits of threads and types in operating system"OUR EXAMS ARE COMING ON 13 OCTOBER 🙏🏻*

[saileshpanchal]

tysm bhai ye yek sabse bada confusion tha mere liye

[quangminhle]

your lecture is so awesome, can you update the English substitles, Gate smashers?

[samyakdahiwale]

hello sir, .... can you please upload a video on NP-Hard topic with its simple problems as me and my of colleagues getting lot's of difficulties .... please sir its our humble request to you

[alleditzs]

sir, SQL me triggers pe bhi video bana do please🙏🙏

[RaghuprasaadIyer]

Sir, you should yous black background with white text for better visibility when recording with camera

[macn]

Please make a vedio on optimization of query

[pushpakgautre]

Sir mixture of having, group by, joins,subquery, ke practice questions do na

[anshulagarwal]

Query processing ka poora playlist banaiye.

[done]

sir count(dept_name) will give 5 right, how will the having condition be satisfied please clear
at 04:39

[amirmaqbool]

sir I request to you sir make the video on sql form builder