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
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.
Thank you for your TH-cam 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.
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!
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.
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.
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 ❤❤❤🇮🇳
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.
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
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.
You're very welcome! Glad it was helpful ❤️
This explanation was super clear! Thanks for breaking it down so well. Please keep making these awesome videos!
Can't wait for SQL/Python for data engineering. And very good video, sir!
Thank you for your TH-cam 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.
Glad you like my videos, I will do that!
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!
Thank you Baraa For Making this Video ❣❣
Once again Thank you Bara
I've been waiting for this. Omg. Thank you. Let me start.
Hi Baraa!!! Amazing explanation on CTEs!!! Requesting you to post a series on DATABRICKS
Man you're the best teacher ever!
I was really waiting for this video, Thanks a lot Baraa , looking forward to the next ones! :D
In the making glad you liked it 🙏
Thank you for making CTE simple to understand.
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.
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.
thank you for this valuable content
My pleasure!
Sehr gut gemacht 👍
Oh Hi Michael, danke 🙏
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 ❤❤❤🇮🇳
thanks baraa for such a high quality only you can explain the complex topic easily
So nice of you
Thanks for the great explanation!!!
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.
Heyy Bara I become your fan, the way you teach, they way you clear all the concepts, thank you so much!!
You're very welcome!
thanku baraa for providing this wonderful course but i cant see the latest video that u uploaded recently
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.
hi baraa.....thanks a million for such amazing video and teaching.
can you please provide data set that you are using for cte
Thanks please follow link 🔗 in description
What is the next tool baraa? I hope it is python
Please provide presentation and cheatsheet
Will do
Hello Baraa ,Thank YOU for this Effort
Link To The presention Do not work
Sir python for data analysis please.
Sure
First ;)
this time I will get my coffee first and then I will sit to study 😅😅
Hahaha yea without coffee it won’t work ✌️