SQL Internals | Indexes in SQL | Order of Execution in SQL | Advanced SQL | SQL Scenario based

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

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

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

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

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

SQL Internals | Indexes in SQL | Order of Execution in SQL | Advanced SQL | SQL Scenario based

In this session I have talked about
1. clustered index vs non clustered index
2. scan vs seek
3. how to read an execution plan in sql
4. various operators in the execution plan in sql
5. order of execution in sql
6. how sql server do optimisation internally

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

If you haven't subscribed to the channel then please do subscribe for more insightful content

#SQLinternals #AdvancedSQL #OrderOfExecution #bigdata #dataengineering

[sumitbarde]

Sumit Sir Thank you for this video. I am using SQL from 2-3 years. I can write hard and complex queries, but the things mentioned in this video are so in depth that i didnt know anything such kind exists. Overall I can say optimizations are your thing.

[eg]

Thank you for these sessions. You explain the concepts so well

[Sandip_Patle]

🔰This is the best series of learning SQL on YouTube I've ever seen.
The way you teach here is quite similar to your big data program which is really really commendable.
As you've mentioned, before going into a big data program, first we need to learn SQL, at least the basics of it.
And I can say, this series of SQL is a perfect recipe to have a good understanding of a big data program.
You're really putting your hard work into it.
Thank you very much and please keep bringing this valuable content likewise. 🙏

[arunsundar]

have been using SQL queries for so many years, however not knowing or caring much about what is happening behind the scenes, now this video is making knowing the internals fun & interesting, thank you very much sir :)

[karthikbalasubramanya]

This is the best explanation so far than other tutorial ever...

[AmitSingh-utwt]

Thank you sumit sir always faced problem in understanding the order of execution. Your explanation has cleared out everything.

[supersetia]

Very well explained. Good job done. Keep it up.

[mujtabanoori]

Wow! Amazing Video.. you have made me very clear about it Thank you. Really Amazing

[saiasrithayakkali]

Sir, This video is much more helpful compared to all others that are available in YouTube but you mentioned you will do the series of videos for further detailed explanation. Can please release those asap so that it will be helpful for many others like me.

[wisdom_vlog]

Looking forward for more videos on SQL.

[radha__radha__radha]

Thank you Sumit sir for the wonderful explanation... Can you please videos on more topics like stored func/ procs, Triggers, Pivot.

[mallikarjunpatil]

Thanks for the beautiful in-depth explanation, this makes things simple

[Pbairoju]

Hi sir
I have been watching your video, as a beginner I would say it's a great explanation.
One request from my end, pls make a video on the difference among the views, stored procedures and functions along with the triggers in detail in SQL.
Thanks.

[arsl]

I never understood why I can't use the alias of aggregates in the where / having clause. To avoid the error I used sub queries/ ctes so that I can use alias in where and having clauses. With this video, I have finally understood why alias cannot be used in the where and having clause but can be used in the order by clause.

Thank you for the great content.

[shwetha]

This is really good ! Please continue on reducing the cost and optimizing. It always depends on data and other variable but a baseline would be great🙂

[sushmaksushma]

Thank you so much sumit sir for teaching sql so clearly. Can you please make a vedio on window functions sir

[mananyadav]

Amazing it is...never did i realize the internals of database is so intresting

[sankuM]

Really very helpful @Trendytech Insights!! 59:26, does it mean that engine has kind of stats on the data already where it knows about the distribution of orders in certain ranges. (e.g. count >10, count>100, etc.) in order to decide the execution order of operation??? 🤔🤔🤔

This one is going to help lot of data geeks to get the internals sorted! 😃 Thank you so much!!!

[hasanmougharbel]

God bless your great efforts in this channel.
I have a simple question to ask as a newbie sql learner.
Could i manage to channel or extract all sql data generated from an accounting program (based on sql) to our new sql server.
The reason that we are bounded with the graphical interface of this accounting software as we cant
come up with any solutions regarding analytics and automation, unless we can tailor and rearrange this sql database based to our specific needs.
Thanks for helping me

[atishayjain]

Finally I understood the order of execution😅. Awesome content.