If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE --------------------------------- ⏱ TIMESTAMPS ⏱ --------------------------------- 00:00 intro 00:21 Window vs Group By 12:40 Window Syntax 17:44 Partition By Clause 27:55 Order By Clause 32:13 Frame Clause 46:39 4 Rules of Window 54:17 Summary Enjoy !
Hey Baraa! Just wanted to say a huge thank you for your SQL tutorials! They’ve been super helpful for me. If it’s not too much trouble, could you please share the SQL file and the presentation file of Advanced SQL Course | For Data Analytics? I’d really appreciate it!
This video is pure gold! I’ve taken SQL courses before, including "SQL for Data Analysts" from Udacity and "SQL para Analista de Datos" from A2 Capacitación, and I’ve even worked on personal projects using window functions. But this video perfectly captures how I imagined a class on window functions should be taught. The section on frames was a game-changer for me-I finally understand the logic behind how they work.
Respect to your hard work even a paid course would not do this much. What I am learning are: 1 ) SQL concepts 2 ) How To break down every part with examples - Building my problem solving skills 3 ) Visualizations of everything which is helping me while building logic by visualising the output data.
Thank God I found this video. I had a hard time to understand Window function, your ditactics is superb. Knowing how to teach is a superpower in fact, and you have it, sir.
successfully completed your sql 4 hours course , if i have a teacher like u i can master advance sql in 2months your course is criminally underrated,i have hope your channel will get what it deserves
You have an amazing teaching skill, breaking down the concepts into so graphically simple way. It's incredible. I'm learning data analytics to switch from non IT to IT field and this is the first channel which has this easy way of explaining the way sql works. It's just amazing.
One of those videos which after watching i really felt thankful to whoever brought you on this Earth. You are truly a Godsend. Thank you so much for this wonderful tutorial. You have made me so invested to follow along rest of your Window function videos and other advance SQL topics. Keep up the great work!
Without mincing words you are the definition of an AMAZING TEACHER. The animations are top-notch, making understanding of abstract concepts pretty simple. Simply put, with every sense of humility, BARAA, you are the best SQL teacher I have ever seen on UA-cam. I love you and your work so much.
You're the most amazing teacher on UA-cam. I've struggled with window functions in live coding interviews but you really made it understandable. Thank You.
ur amazinf brother the best channel of data scienece ever made ur teaching styles are just fantastic , PLEASE DONT STOP MAKING VIDEOS UR AMAZING UR PROVIDING THE QUALITY WHICH WE WOULDNT HAVE GOT EVEN IN THE PAID MATERIAL HANDS DOWN TO U
Hey Bara , Thank You So Much!! I was delaying or procrastinating alot in learning advance sql because even after taking various tutorials i was not completely getting or understanding these functions. but here after only completing this 1 tutorial of window functions i am so excited and curious to learn remaining advance sql . I would be forever grateful to you for not letting me give up on sql . PLEASE NEVER STOP TEACHING THESE CONCEPTS!! Thank You again soo much!! Love and Respect from India
Thank you so much! You are the best teacher to learn from. I'm an aspiring data analyst from a completely different education background and your courses have helped me so much. I am learning Tableau from you and now advanced SQL. I can't thank you enough.
I have seen multiple videos related to Tableau and SQL, but no one explains them like you do. You helped me a lot to clear up Tableau and SQL concepts.❤
You explain the complex things with simple steps and make it easily understandable, you are irreplaceable. Thank you for your efforts for sharing the knowledge.
Your explanations are literally top notch easy to understand and follow, the examples are also right on point. Most importantly the way you explain with your diagrams just makes it super easy for a beginner to grasp such complex and important concepts. You deserve a lot of appreciation and support for the kind of content you are doing. Big support and love, keep doing the excellent work.
Hi Baraa, Thank you so much for providing a top class content. Trust me, this is the best quality course I have found across all platforms. Even the paid courses aren't this neat. You are amazing. Few things I'd like you to add- 1. Can you provide slides for advanced materials like you did for the beginner course? It helped me a lot. 2. Eagerly waiting for Python classes, right now as I see, Python tops the charts for next content in your polls that you put in the website. When can we expect it come out? I'd like to start the learning process from person like you because you help build the strong fundamentals effectively. Thank you so much for what you are doing. More power to you.
Best UA-cam content and best source of learning.. I have shared your channel link to my Professors so they can pass on to other students in the University.
Hi sir . As per this video @time 57 minutes and 11 seconds Baraa sir videos for all learners. From my side Lot of thanks for your idea , thinking and hard work which will benefit all learners.
Hi Baraa, You have such command over the subject and your teaching methodology is excellent.This is the first time I've deeply understood the concepts of window functions.Thank you so much.
Your dedication to providing valuable content is truly commendable. The effort you put into each video is evident and greatly appreciated by your audience. Your channel serves as a reliable source of information and guidance for viewers of all backgrounds. Thank you for consistently delivering high-quality content that enriches the lives of many. Keep up the excellent work!
Hi Bara, I must commend the explanation of window functions provided in the video and it was truly exceptional and thorough. Overall, the explanation was superb!!!!
Hey Baraa! Just wanted to say a huge thank you for your SQL tutorials! They’ve been super helpful for me. If it’s not too much trouble, could you please share the SQL file and the presentation file of Advanced SQL Course | For Data Analytics? I’d really appreciate it!
select Baraa sum(very lovely explanation) over(such complicated topic, Lots of Blessing and love ❤❤❤❤ to you) from Akarsh; ---i know its hard for you to ignore the syntax error (but i think you got it) although, at 45:24 the default frame is 'RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ' not row (in my knowledge) and how can i use frame in data analysis ???
Excellent stuff Bara!! I love the illustrations esp on Window Frames. Please confirm on the default window frame. Is it RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW / ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW or both. Also what is the default window frame for ()
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
---------------------------------
⏱ TIMESTAMPS ⏱
---------------------------------
00:00 intro
00:21 Window vs Group By
12:40 Window Syntax
17:44 Partition By Clause
27:55 Order By Clause
32:13 Frame Clause
46:39 4 Rules of Window
54:17 Summary
Enjoy !
Hi, Can you also share the presentation and cheat sheet for this course on your website. That'd be really helpful
Hey Baraa!
Just wanted to say a huge thank you for your SQL tutorials! They’ve been super helpful for me. If it’s not too much trouble, could you please share the SQL file and the presentation file of Advanced SQL Course | For Data Analytics? I’d really appreciate it!
This video is pure gold! I’ve taken SQL courses before, including "SQL for Data Analysts" from Udacity and "SQL para Analista de Datos" from A2 Capacitación, and I’ve even worked on personal projects using window functions. But this video perfectly captures how I imagined a class on window functions should be taught. The section on frames was a game-changer for me-I finally understand the logic behind how they work.
Respect to your hard work even a paid course would not do this much.
What I am learning are:
1 ) SQL concepts
2 ) How To break down every part with examples - Building my problem solving skills
3 ) Visualizations of everything which is helping me while building logic by visualising the output data.
Thank God I found this video. I had a hard time to understand Window function, your ditactics is superb. Knowing how to teach is a superpower in fact, and you have it, sir.
successfully completed your sql 4 hours course , if i have a teacher like u i can master advance sql in 2months your course is criminally underrated,i have hope your channel will get what it deserves
@@Ascendify5 this tutorial is the best out there!
You are god of content creators. Thank you so much for putting so much effort in visualizing the course.
This is the best UA-cam channel I have ever seen for SQL The way he is explaining in really awesome
You don't need to go in any other channels to understand the window functions, this video is more than enough.
Thank you! 😊 Really glad to hear the video was helpful
You have an amazing teaching skill, breaking down the concepts into so graphically simple way. It's incredible. I'm learning data analytics to switch from non IT to IT field and this is the first channel which has this easy way of explaining the way sql works. It's just amazing.
Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!
One of those videos which after watching i really felt thankful to whoever brought you on this Earth. You are truly a Godsend. Thank you so much for this wonderful tutorial. You have made me so invested to follow along rest of your Window function videos and other advance SQL topics. Keep up the great work!
Without mincing words you are the definition of an AMAZING TEACHER. The animations are top-notch, making understanding of abstract concepts pretty simple. Simply put, with every sense of humility, BARAA, you are the best SQL teacher I have ever seen on UA-cam. I love you and your work so much.
Thank you so much 😀
You're the most amazing teacher on UA-cam. I've struggled with window functions in live coding interviews but you really made it understandable. Thank You.
Wow thanks really nice to hear that ✌️
Baraa your tutorials are unlike many others. You break thigns down in a very digestible way, then you give us examples in SQL Server.
10/10 Tutorial!
ur amazinf brother the best channel of data scienece ever made ur teaching styles are just fantastic , PLEASE DONT STOP MAKING VIDEOS UR AMAZING UR PROVIDING THE QUALITY WHICH WE WOULDNT HAVE GOT EVEN IN THE PAID MATERIAL HANDS DOWN TO U
am glad to find your channel today . you are a great teacher
Hats off to you for sharing so much valuable contents for free ❤❤ THANK YOU SO MUCH sir... You are my Tableau and Sql guru
I am really so grateful to you for providing such a high quality content free. May god bless you.....
Great video! It's clear and helpful. Thanks for sharing your SQL knowledge!
This fantastic teaching video is the best I've seen; even with my non-coding background, I was able to understand it in one sitting.
Hey Bara , Thank You So Much!! I was delaying or procrastinating alot in learning advance sql because even after taking various tutorials i was not completely getting or understanding these functions. but here after only completing this 1 tutorial of window functions i am so excited and curious to learn remaining advance sql . I would be forever grateful to you for not letting me give up on sql . PLEASE NEVER STOP TEACHING THESE CONCEPTS!! Thank You again soo much!! Love and Respect from India
Thank you so much! You are the best teacher to learn from. I'm an aspiring data analyst from a completely different education background and your courses have helped me so much. I am learning Tableau from you and now advanced SQL. I can't thank you enough.
Tons of Thanks for your nice words, I'm glad that everyone is enjoy the course :)
I have seen multiple videos related to Tableau and SQL, but no one explains them like you do. You helped me a lot to clear up Tableau and SQL concepts.❤
Thanks for the kind words ❤️
Awesome!! I never seen such tutorial for free of cost !! much appreciated and keep up the good work of spreading knowledge!!
You explain the complex things with simple steps and make it easily understandable, you are irreplaceable. Thank you for your efforts for sharing the knowledge.
This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏
Very smart! Thanks for the nice words
Your explanations are literally top notch easy to understand and follow, the examples are also right on point. Most importantly the way you explain with your diagrams just makes it super easy for a beginner to grasp such complex and important concepts. You deserve a lot of appreciation and support for the kind of content you are doing. Big support and love, keep doing the excellent work.
That is the best class regarding SQL Window functions I have ever seen. Congratulations on your outstanding work!!
Glad to hear that!
I wish I could subscribe a thousand times!!! one single subscription is not enough to justify this level of quality for your content !!!
Wow thanks so much, your support means a lot for me and motivate me to make more content 🙂
Cant thank you enough for this course, and how it easily and visually explained, perfect timing for my interview, we need you in our lives 🥰
Hi Baraa, Thank you so much for providing a top class content. Trust me, this is the best quality course I have found across all platforms. Even the paid courses aren't this neat. You are amazing. Few things I'd like you to add- 1. Can you provide slides for advanced materials like you did for the beginner course? It helped me a lot. 2. Eagerly waiting for Python classes, right now as I see, Python tops the charts for next content in your polls that you put in the website. When can we expect it come out? I'd like to start the learning process from person like you because you help build the strong fundamentals effectively. Thank you so much for what you are doing. More power to you.
What a simple and easy explanation !! Thank you for the amazing tutorial
Best UA-cam content and best source of learning.. I have shared your channel link to my Professors so they can pass on to other students in the University.
Oh really !! Thank you, I hope the students will like it 😊
Great teaching, Thanks a ton!
Best window function class ever❤
Great content man. This really helped me understand window functions more deeply
Great work and presentation along with wonderful detail
You are great. A lot of work went into this - GREAT presentation. Thank you !!!
Best Vedio and best explanation in my entire Education I have ever seen. Thanks a lot.
Man! you teach the topics so well with visualizing every step! thank you!👏
Glad you think so!
Hi sir . As per this video @time 57 minutes and 11 seconds Baraa sir videos for all learners.
From my side Lot of thanks for your idea , thinking and hard work which will benefit all learners.
Thanks and welcome, so nice of you!
What a man you are , your voice is so soothing i heard it on normal speed and understood everything great content man!
Wow, thanks dear ❤️
Love how you explain it simply, I wish there are more activities or problems for us . Thanks alot dear.
My pleasure
what an amazing teacher 🤩🤩🤩🤩
best ever tutorials for sql ....thank you so much sir...!
Most welcome!
Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.
Thank you! I'm glad you enjoyed it!
Hi Baraa, You have such command over the subject and your teaching methodology is excellent.This is the first time I've deeply understood the concepts of window functions.Thank you so much.
Thanks for taking time writing this wonderful comment i really appreciate and happy to hear my content is helping. Have a nice day😉
YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA
Thanks for the nice feedback !
Great Tutorial , very good examples with clear explanation, all you need to know about window functions in SQL, you are a legend sir, thank you
Brilliant! 💙 Your talent to simplify such a complex concept is amazing. Thank you for sharing.
Thanks for the feedback ❤️
Best Tutorial ever !!!!
Your dedication to providing valuable content is truly commendable. The effort you put into each video is evident and greatly appreciated by your audience. Your channel serves as a reliable source of information and guidance for viewers of all backgrounds. Thank you for consistently delivering high-quality content that enriches the lives of many. Keep up the excellent work!
Thanks for taking time writing this amazing feedback, I really appreciate it.
You truly know how to teach well. Thanks for this tutorial!
You're very welcome!
Correct 70 to 60 at 36.26 .... BTW the best video on SQL so far .Cheers Baraa
Thanks for the info!
@@DataWithBaraa Indeed thanks to you Barra. Please make videos on sql order of execution in complete details .
Thanks man this helped me a lot
Bhai....You are amazing teacher! Salute to you from India❤
You are amazing too for leaving wonderful comment
Awesome content !!! Loved they way you explain everything with great visuals !! 🐐
Bro, TOP MOST BEST CHANNEL ON UA-cam 🎉🎉🎉. KEEP IT UP. PLEASE HAVE MORE COMPLEX ON SQL + POWER BI BRO 🙏🙏🙏🎉🎉🎉
The hand-drawn diagrams were super helpful in understanding the topic. Great teaching methodology!
Thanks a lot! I'm happy to hear the hand-drawn diagrams made the topic clearer! 😊📝
Finally Finally Finally I understood the concept and reason behind the window function😢❤Big burden is OVER() now.
I am happy it is OVER() :)
Your explanation awesome Baraaa😇😇😇😇😇😇😇
best resource to learn for sql
YOUR VIDEOS ARE AWESOME BRO ❤❤🎉🎉 KEEP IT UP!!! 🎉🎉
That's one of the best!
Can't thank you enough!
Appreciate your hard work. Thank from india
My pleasure
Like before viewing 👍
:)
Thanks! great content
Literally top notch content.....
Thanks !
Hi Bara, I must commend the explanation of window functions provided in the video and it was truly exceptional and thorough. Overall, the explanation was superb!!!!
Thank you for the amazing feedback :)
best teacher for sql ill learn tabealu from you too
Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D
Thanks dear :)
EXCELLENT! you explained it well with amazing animation. You must be more than a teacher! Thanks, learned a lot. New sub here.
Thanks for the sub!
Highly educational, thank you
I totally loved your creative content.... so easy to understand lovedddd it
Thank you so much 😀
Hey Baraa!
Just wanted to say a huge thank you for your SQL tutorials! They’ve been super helpful for me. If it’s not too much trouble, could you please share the SQL file and the presentation file of Advanced SQL Course | For Data Analytics? I’d really appreciate it!
I see a lot of hard work in your content, I hope you get 1M Soon.
great and clear explanation, thank you!
You explain it very nicerly , hatsoff to you bara
hank you so much! I'm really glad you liked it! 🙏😊
Excellent presentation. Thanks for sharing.
You are welcome thanks !
Thank you so much for such an amazing interactive session
You are welcome :)
select Baraa
sum(very lovely explanation) over(such complicated topic, Lots of Blessing and love ❤❤❤❤ to you)
from Akarsh;
---i know its hard for you to ignore the syntax error (but i think you got it)
although, at 45:24 the default frame is 'RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ' not row (in my knowledge)
and
how can i use frame in data analysis ???
Awesome sharing. Thanks Baraa!
your welcome
Thanks for a wonderful lecture
Most welcome!
Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching
Just awesome !!!
So easy to follow, thank you
Glad to hear than ❤️
Great lessons Baraa. I am a new subscriber now!!
@@rajeshantony74 welcome to the channel and thanks for supporting ❤️
wow! very useful tutorial, with a clear explanation and example. Hoping more content about data analysis you deserve a subscribed thank you!
Much appreciated! I will keep pushing as long you guys are enjoying my content
Excellent stuff Bara!! I love the illustrations esp on Window Frames. Please confirm on the default window frame. Is it RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW / ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW or both. Also what is the default window frame for ()
Great video
fantastic please keep going
Amazing
THANK YOU SO MUCH FOR THIS CONTANT
WELCOME
Thank you!
hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please
So good. Thank you!!
Glad you liked it!
thanks for your valuable contents
So nice of you
Thank you so much! I have learned a lot from this vid :)
I'm so glad!
Thanks 👍
Welcome 👍
Great video, thank you! A bit curious, what's the software you're using to draw diagrams and stuff ?
Thank you, I use drawio and procreate