SQL Execution Plans EXPLAINED | SQL Hints | #SQL Course 40

☕ *Stay Connected*

📚 *Free Courses*

🎓 *If You Need Certifications*

⏱️ *Timestamp*
00:00 - Intro
00:12 - What is Execution Plan?
03:29 - Execution Plan Basics
10:22 - Execution Plan: Heap vs Clustered
13:02 - Execution Plan: Nonclustered
18:54 - Execution Plan: Rowstore vs Columnstore
25:33 - SQL Hints

#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[fullpower]

I would go to a war for you for teaching me SQL, you deserve Dronacharya award (highest award given to teachers/coaches in India)
I hope you stay happy and live long ❤

[souravroy]

Hi Baraa, i know education category in youtube is not much profitable and I understand you are doing it for sharing your knowledge more than money. i feel like 100x confident with each video I am watching.

[shahbazfareedchishti]

This playlist has increased my knowledge exponentially, this playlist is much more detailed than any paid course

[Jp-yxod]

There are many sql tutorials on the YouTube. But yours give more practical knowledge. Thank you.

[GameSpreePH]

I love this tutorial. No nonsense like other video tutorials. Direct to the point and everything is clear

[sajidkabaaphu]

Bro have been studying PBI and focusing on optimization, and this playlist with advanced topics like indexes/execution plan/partitioning/the different type of tables is a gem for sure, thanks Baraa I tried searching everything but couldn't find something like this. The visuals and your explanation is top notch.

[Dondib]

Thank you, Mr Baraa, for your excellent teaching and guidance in SQL—I truly appreciate your support and dedication!🌟🌟🌟🌟🌟

[ndifsmurida]

I am forever grateful for your generosity with your knowledge, skills, and time. Everything about your channel is just pure premium!!!

[kushalnarendracumar]

Very well explained sir.. Thanks for these efforts.👍

[khalendershaik]

Thank you so much for all your efforts and I have learned a lot a from your videos. I have noticed, at 22:57 - After applying Column Store Index, Execution Plan shows increase in cost for table DimProduct to 79% from 10%

[indraverma]

thank you for this video ..really helpful

[pratikpatil]

Really great series really enjoying sir please add some real scenario based too so that we will get to know to deal with them

[johnp.o]

Hi Baara,
Learning a lot from you..
Question: Any plans down the road to start a Python series? Thanks

[HadeerMansha]

Sir can you make complete one shot video on joins, they are very confusing like how they work. How we can solve complex join problems, how we can implement 3 joins, 4 joins in one query. How self join works.

[rehansaif]

Thank you so much for all your efforts and I have learned a lot a from your videos.

[nikachurgulashvili]

sir you are amazing thank you for everything

[mayuramanahara]

This is very helpful, Thanks for the amazing tutorial. (Y)

[mayt.al-tameemi]

Thanks for all the efforts made. All of your videos are very useful. My question is what is Query Store and its relation with SQL performance

[sourishkundu]

Sir please make complete data analyst bootcamp on utube as there are not such good package all together 🙏🏻🙏🏻🙏🏻

[manu]

hi what is the stored procedure ? can you explain as next video...the window functions video my first video i watched from your channel... impressed yarr... thanks ton