SQL CTE (Common Table Expression) Full Guide | WITH Clause | #SQL Course #16

preview_player
Показать описание
This video covers everything about SQL CTEs (Common Table Expressions) and is a comprehensive SQL tutorial.

☕ Stay connected

📚 Free Courses

🎓Other Platforms (Certifications)

⏱️ Timestamp
00:00 Intro
00:26 What is CTE?
06:33 Why CTE?
11:29 How DB Execute CTE?
13:45 CTE Types
14:20 Standalone CTE
23:02 Multiple CTE
31:06 Nested CTE
44:44 Best Practices CTE
47:26 Recursive CTE
01:14:55 CTE Summary

#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**
Рекомендации по теме
Комментарии
Автор

TIMESTAMPS

00:00 Intro
00:26 What is CTE?
06:33 Why CTE?
11:29 How DB Execute CTE?
13:45 CTE Types
14:20 Standalone CTE
23:02 Multiple CTE
31:06 Nested CTE
44:44 Best Practices CTE
47:26 Recursive CTE
01:14:55 CTE Summary
Enjoy

DataWithBaraa
Автор

For the past few days, I've been struggling to learn this topic (CTE). I watched many tutorials, but they somehow didn’t benefit me. Just now, your video appeared on my homepage. You don’t know how much your videos and content are helping us. You're indeed putting in great effort. May Allah bless you with the strength to keep up this amazing work.
P.S. I’m also in the middle of your Tableau course, and honestly, I have no words to explain that masterpiece. You truly are a gem, sir.

Spicycaat
Автор

Thank you for your YouTube explanation! I'd love to see more videos from you covering both basic and advanced Python topics. Your explanations are clear, and I really appreciate them, and I believe you’ll continue to do great work.

RAGHU-cp
Автор

Thank you Baraa For Making this Video ❣❣

rajshekar
Автор

Hi Baraa!!! Amazing explanation on CTEs!!! Requesting you to post a series on DATABRICKS

priyanka_kaduluri
Автор

I was really waiting for this video, Thanks a lot Baraa, looking forward to the next ones! :D

juancruz
Автор

I've been waiting for this. Omg. Thank you. Let me start.

farmandfood
Автор

Man you're the best teacher ever!

MrAledez
Автор

This explanation was super clear! Thanks for breaking it down so well. Please keep making these awesome videos!

umesairam
Автор

Thank you for making CTE simple to understand.

fasihrehman
Автор

Hey Baraa, great content. I also use temp tables instead of CTE's for more accuracy. if possible, please create a video explaining the difference between CTEs and TEMP tables and performance techniques between temp and cte's? I really appreciate any help you can provide. your videos are always great to deep dive and cover missing points.

shivavenna
Автор

Baraa, I been waiting days for this video and you did not dissapoint! I keep commenting over and over showing love cause I truly appreciate you sharing your wisdom with us.

Cheers from the USA!

jephersonventura
Автор

Thank you so much for all of your hard work and helpful videos, I wish you all the best. I would love to see you make a video that provide us information about where to download high-quality SQL dataset with multiple tables to practice, I think it would be great.

sayowhatisuupmynaiba
Автор

thanks baraa for such a high quality only you can explain the complex topic easily

nitinrawat-gt
Автор

Can't wait for SQL/Python for data engineering. And very good video, sir!

exhaustive_the_sixth
Автор

Heyy Bara I become your fan, the way you teach, they way you clear all the concepts, thank you so much!!

poojabihani-md
Автор

Hello sir I'm chandrim Dey sajjan I'm the biggest fan of your content and also your voice, I watch your every contact and I learn full tableau in your video, and also SQL, I'm a Data analyst inshusist not get a job but hope it's happening. Love from India ❤❤❤🇮🇳

chandrimdey
Автор

Thank you so much brother. I was going through the triggers topic for SQL, is it kind of important of we can skip that topic.

utkarshgupta-qc
Автор

hi a million for such amazing video and teaching.
can you please provide data set that you are using for cte

Perwezhassan
Автор

Woohoo! Finally, you’re back! Thanks, Bara, for the new video. I’m a new subscriber to your channel, and I just wanted to say thank you for the excellent quality of your content. You’re the only one covering all the advanced SQL topics, so huge thanks, bro! May God bless you!

Whenever I see students struggling with advanced SQL, I’m always redirecting them to your channel. Keep it up, bro!

I’ve got two quick questions if you don’t mind:

Any plans to create videos on data engineering stuff like Data mining, data warehouse, Apache, Hadoop, etc.? If so, could you let us know which topics?
I’m unable to download the presentation slides you use to teach advanced SQL. When I click on the SQL files or presentation option, it redirects me to the SQL Server Management Studio (SSMS) download page. Could you help me out with this?
Looking forward to hearing from you! Stay blessed.

rajandayma