SQL Server Programming Part 11 - Common Table Expressions (CTEs)

By Andrew Gould

You can see a written version of this tutorial at:

You can download the script to create the Movies database used in this video at the following link:

You can see the range of resources and courses we offer in SQL Server here:

[mgmohitgoyal]

I have followed SSIS, SSRS, Power BI tutorials and Now I am about to complete this one. I just wanted to thank you guys for uploading these in-depth and well-explained courses on YouTube.

[sanoobarkhan]

no word can explain the beauty of such simplified and full of knowledge videos...so amazing.. Love you.

[JI]

the whole series are explained very clean. thank you very much

[Headlikeanorange]

The simple, clear and consise explanation I was looking for. Thanks so much!

[jadenguyen]

I learned SQL from the Coursera but your videos are very practical and I can apply advanced SQL to my job. Thanks so much for sharing this.

[TheSighlent]

This makes sense now! Thank you soooo much! ....I watched 30 min of videos before this and was nothing but confused. I watched 8 min of your video and you cleared all confusion

[houstonfirefox]

As usual for @WiseOwlTutorials, VERY well thought out and presented. Your later videos have the volume properly normalized to 50% volume. Nothing a quick hit of the volume knob can't fix while watching. Keep up the great work, a True Data Professional!

[ankitkraken]

This was great.
Love the way you explain. Would love to watch more detailed in depth tutorials for SQL where you explain these concepts.

[redguard]

Very easy to follow. Thanks so much!!!

[gabrielgil]

I love the way you explained everything, thank you so much.

[jra]

I learned sql at my job and udemy but these videos are excellent.

[kroll]

Great video, great explanation of very useful and helpful tool - CTE in SQL. Thanks a lot!

[kontrabando]

Thanks Andrew. Very clear and practical!

[TheAndozio]

Excellent. Thanks from BRazil. Very helpful your work.

[prajaakeeyaparty]

HI Team, your videos are really helpful and please make a videos on query optimization and execution plan in sql server

[JoeVago]

Thank you for these videos - nice work Wise Owl !

[mistery]

...like putting a warm knife through butter. Thanks a lot.

[troybryantIII]

This video plus the other videos are great.  Quick and straight to the point.  I think you said it before but do you have a link to the db so can also play with that data?

[alihancicek]

This was great. thank you very much, Please Can you make new videos about CTE?

[scotthartman]

Still not getting the purpose of all of this - why couldn't you just write inner joins, left outer joins, and subqueries... does this somehow improve performance? I'm continuing to look elsewhere, but if you could explain further why we need CTEs in our lives?? I would be very grateful!!!