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

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE 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

[@DivyYadav-hg2js]

bara a full sql real life project after completing this course will boost our confidence

[@Spicycaat]

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.

[@DataWithBaraa]

You're very welcome! Glad it was helpful ❤️

[@barbmarques2022]

I'm amazed at how Baraa can take a complex subject such as Nested or Recursive CTEs and break them down into logical steps -- so easy to understand. Thank you!

[@DataWithBaraa]

Glad you liked it!

[@DivyYadav-hg2js]

how can someone be so good at teaching its unbelievable

[@isaacanyakwu8198]

I love your teaching methodology, you make learning so simple. You take your time to explain the logic without any assumptions. Kindly do something on powerbi.

[@SAhmBal89]

I can't explain in my words here that how your teaching style is so amazing and you have become my best teacher, I usually don't comment but after watching and learning from your contents I can't stop my self to do it, and I just want to say please don't delete your contents and channel as well😊😊 and keep learning and guiding us by your amazing contents, thank you ❤

[@DataWithBaraa]

Your kind words mean the world-thank you! I’ll keep creating and sharing for amazing learners like you.❤😊

[@kebincui]

The best tutorial about CTE👍❤. THANKS

[@kanchannatekar5798]

You are the best Teacher. I have never understood Advance sql concepts so well uptill now .Thank you so so much.

[@MrAledez]

Man you're the best teacher ever!

[@umesairam1391]

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

[@govardhanreddy690]

Thank YOU So Much Sir

[@DataWithBaraa]

Thank you too!

[@RAGHU-c2p]

Thank you for your KZbin 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.

[@DataWithBaraa]

Glad you like my videos, I will do that!

[@jephersonventura7510]

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!

[@DataWithBaraa]

Thank you soooo much for your kind comment and your support for me, I am happy that I met your expectation :)

[@shivavenna315]

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.

[@fasihrehman2555]

Thank you for making CTE simple to understand.

[@vasilkagenova6266]

The best explanation for CTE. Thank you.

[@Toyahan43]

BARAA! You are amazing as always. I always pray that your channel gets a lot of subscribers and you get the recognition that you deserve In sha Allah

[@DataWithBaraa]

Thanks !!! You are amazing too for leaving this wonderful comment, thanks 🙏

[@farmandfood7984]

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

[@micaelzekarias1537]

No words to thank you as always. GBU

[@poojabihani-m9d]

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

[@DataWithBaraa]

You're very welcome!

[@ELFBDS]

1:05:08 I loved hearing that I'm bass I just 😂

[@juancruz7836]

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

[@DataWithBaraa]

In the making glad you liked it 🙏

[@nitinrawat-g6t]

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

[@DataWithBaraa]

So nice of you

[@anri_szyrykowski]

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

[@godbhaigod]

Are you releasing course???😮

[@AnilKumar-dt7ns]

Hi Barar detail explains ,you are incredible, keep rock Thank you

[@AjAj-yg9vc]

Great and easy to follow explanation. You are awesome, Baraaa!

[@DataWithBaraa]

Thank you! 😃

[@rajandayma]

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.

[@priyanka_kaduluri]

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

[@farhanb7022]

YOU ARE ANGEL 😇

[@DataWithBaraa]

😇😇😇

[@jbjsb]

Thank you so much Baraa ! The best teacher

[@DataWithBaraa]

❤️

[@godbhaigod]

This premium content ❤❤❤❤

[@sayowhatisuupmynaiba]

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.

[@chandrimanalyst]

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 ❤❤❤🇮🇳

[@gauravbhandari8027]

Thanks for the great explanation!!!

[@debannitachattaraj25]

Baraa the way you explain is just amazing , I want to have a playlist of python course for data analyst as well

[@mahmoudalsayyad90]

شكرا يا براء ❤، لو تكمل في سلسلة SQL problem solving!

[@sarangabani-h8y]

as usual excellent teaching.. i love it.. expecting videos for python brother..

[@rajshekar1362]

Thank you Baraa For Making this Video ❣❣

[@MamadouCellouDiallo-u9v]

Once again Thank you Bara

[@utkarshgupta-q5c]

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.

[@ziadabdlbasset]

thank you for this valuable content

[@DataWithBaraa]

My pleasure!

[@DivyYadav-hg2js]

bara im not sure wether i should learn tableau or should i learn power bi,according to u which should i start with?

[@Perwezhassan]

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

[@DataWithBaraa]

Thanks please follow link 🔗 in description

[@mohammedhegazy8906]

What is the next tool baraa? I hope it is python

[@michaelplaz1499]

Sehr gut gemacht 👍

[@DataWithBaraa]

Oh Hi Michael, danke 🙏

[@piyushmahajan4422]

thanku baraa for providing this wonderful course but i cant see the latest video that u uploaded recently

[@balajithandavan6842]

Thanks for your video. Could please add one video for , daily dump uploaded in SharePoint to cumulative total sale. Please explain its connectivity query.

[@ErickGiovanniRuizHernandez]

I enjoy your way to teach very much. Do you have any video explaining Window Functions and Subqueries I can check?

[@DataWithBaraa]

Yes check the channel

[@RakshitDwivedi-pq8qc]

Hi Baraa, I have a question in the nested CTE's tutorial, you used ORDER BY function for RANK to Rank the customers. However you said earlier that ORDER BY clause cannot be used inside CTE. Does this rule not apply when we have an ORDER clause inside a Window function? Please clarify. Thank you for your amazing lecture on CTEs

[@DataWithBaraa]

reat question! The ORDER BY in a window function is used to rank or partition the data within the window, not to sort the final result set of the CTE. That's why it is allowed as part of the window function but doesn't affect the overall ordering of the final result.

[@anjuaj363]

Hi sir, Can you please make a video about power BI

[@amblessed_onwumere]

Tried Implementing the Recursive CTE at @57:41 in MySQL but it returns an error saying Table Series doesn't exist. Is this Recursive CTE only limited to Microsoft SQL Server?

[@affanskm3530]

Hey , is this possible with cte as ( code block) select * from cte with cte1 as ( code block) select * FROM cte1

[@ayushjha4503]

Please provide presentation and cheatsheet

[@DataWithBaraa]

Will do

[@abusalem4406]

Hello Baraa ,Thank YOU for this Effort Link To The presention Do not work

[@aabhasagrawal410]

Sir python for data analysis please.

[@DataWithBaraa]

Sure

[@LeonanielBalijon]

where can I download the database for this? I want to practice.

[@DataWithBaraa]

Follow the link in description

[@NGKannur]

First ;)

[@adwaitjawadekar1185]

Hello baraa im trying to find the database to practice cte function i have gone through the link but still i didnt find it can you please repost it somewhere it will be great help actually i found the data in advance sql video but that is not the supportive format for sql server please upload that it will be great help. Thanks in Advance

[@napoleanbonaparte9225]

ONLY ONW WORD "SUPERB SQL BY BAARA"

[@DataWithBaraa]

Thanks !!!

[@khalidazizi8346]

why your coffee cup start steaming only when you put on the table? 😁

[@DataWithBaraa]

😅

[@OPTIMUSPRIME-q8x]

this time I will get my coffee first and then I will sit to study 😅😅

[@DataWithBaraa]

Hahaha yea without coffee it won’t work ✌️

[@guiltycrown6024]

bruh...ive been meaning to ask..is your coffee smoke real?? it always looks the same..lol

[@DataWithBaraa]

What do you think 🤔 😉