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.
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!
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.
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.
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!
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.
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.
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
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.
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?
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
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
bara a full sql real life project after completing this course will boost our confidence
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 ❤️
how can someone be so good at teaching its unbelievable
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!
Glad you liked it!
You are the best Teacher. I have never understood Advance sql concepts so well uptill now .Thank you so so much.
شكرا يا براء ❤، لو تكمل في سلسلة SQL problem solving!
The best explanation for CTE. Thank you.
Man you're the best teacher ever!
This explanation was super clear! Thanks for breaking it down so well. Please keep making these awesome videos!
Hi Barar
detail explains ,you are incredible, keep rock
Thank you
Thank you for making CTE simple to understand.
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!
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 Baraa ! The best teacher
❤️
I've been waiting for this. Omg. Thank you. Let me start.
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 soooo much for your kind comment and your support for me, I am happy that I met your expectation :)
Great and easy to follow explanation. You are awesome, Baraaa!
Thank you! 😃
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
Thanks !!! You are amazing too for leaving this wonderful comment, thanks 🙏
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 ❤❤❤🇮🇳
YOU ARE ANGEL 😇
😇😇😇
Hi Baraa!!! Amazing explanation on CTEs!!! Requesting you to post a series on DATABRICKS
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!
thanks baraa for such a high quality only you can explain the complex topic easily
So nice of you
Baraa the way you explain is just amazing , I want to have a playlist of python course for data analyst as well
Can't wait for SQL/Python for data engineering. And very good video, sir!
Are you releasing course???😮
This premium content ❤❤❤❤
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.
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.
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 Baraa For Making this Video ❣❣
Once again Thank you Bara
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.
Thank YOU So Much Sir
Thank you too!
thank you for this valuable content
My pleasure!
Thanks for the great explanation!!!
bara im not sure wether i should learn tableau or should i learn power bi,according to u which should i start with?
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
Sehr gut gemacht 👍
Oh Hi Michael, danke 🙏
I enjoy your way to teach very much. Do you have any video explaining Window Functions and Subqueries I can check?
Yes check the channel
thanku baraa for providing this wonderful course but i cant see the latest video that u uploaded recently
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
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.
What is the next tool baraa? I hope it is python
Hi sir, Can you please make a video about power BI
Sir python for data analysis please.
Sure
Hey , is this possible
with cte as (
code block)
select * from cte
with cte1 as (
code block)
select * FROM cte1
Please provide presentation and cheatsheet
Will do
where can I download the database for this? I want to practice.
Follow the link in description
Hello Baraa ,Thank YOU for this Effort
Link To The presention Do not work
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?
why your coffee cup start steaming only when you put on the table? 😁
😅
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
First ;)
this time I will get my coffee first and then I will sit to study 😅😅
Hahaha yea without coffee it won’t work ✌️
bruh...ive been meaning to ask..is your coffee smoke real??
it always looks the same..lol
What do you think 🤔 😉