SQL session 7 | Order of execution in SQL | Trendytech

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!

"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

In this session we have talked about the order in which things are executed in a SQL statement.

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥

#SQL #RDBMS #database #bigdata #dataengineering

[yashdhas]

This series is going to be a life changing for ETL developers.

[ManojKumar-urwl]

Excellect video sir, no body thought me this point in any of the youtube videos which I had watched till now.. hats off to you sir

[sudan]

This series is proving to be extremely useful for me, thanks a lot for creating this SQL playlist.
If possible, can you please include some practice questions as well?

[DataWbeast]

thanx for explanation sir love your lectures till now you are teaching according to what you mentioned in first lecture🙏🙏

[TrustinData]

Thank you so much for wonderful explanation . This motivates me to learn more.

[bhargavi_data_analyst]

I am binge watching, everything is so clear, thank you so much !!!

[tushartiwari]

If the number of rows at 12:20 time same as in both the distinct queries then will it work?

[pravinmahindrakar]

Excellent deep dive into concepts, Hats off to you

[DhananjayChoudhari-pd]

I have one question
If we run this query then it should be work or not

SELECT DISTINCT source _of_joining FROM students ORDER BY source_of_joining ;

[AyushSharma-ddul]

Very nicely explained, this was very intricate. Thank you :)

[kalaivanigunasekaran-rj]

amazing vedio... very depth understanding

[yogeswarreddy]

Hi sir,

Can you please tell me where I can find this notes

[vikashbist]

so what is the solution to get the output of that perticular question if we can't fire that query what should be the query to get that output?

[nikhilbarthwal]

Also, the output would not make sense as enrolment_date is set to TIMESTAMP. So technically every record will have a DISTINCT date/value

[Unknown_User]

I don't know how the below query is working for me

select DISTINCT source_of_joining from students
ORDER BY enrollment_date DESC
LIMIT 5;

Could you please explain?

[Chiriya]

Why this query is executing in XAMPP without any error?

[pridename]

Excellent work sir, would love to see something in python if you can.Thank you sir.

[mannunara]

Sir if WHERE clause is also used in query then what will be the order of execution? In this case also, FROM will be processed first?

[jayeshdahiya]

select distinct source_of_joining from students order by enrollment_date desc limit 3; this query works in db browser for sqllite

[uttamx]

Nice videos
Please make a few videos on practical scenarios.