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!
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.
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 RUclips. I love you and your work so much.
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!
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.❤
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.
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
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 Bara, I'm a programmer, not a data scientist, but thanks a lot. Ten years ago, Windows functions didn't exist; I just found out in 2022, but I didn't know how they worked. And you explained clearly to us. Thanks
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.
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.
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!
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 ()
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 ???
Baraaa, you are the best guru for me, but could you please change your microphone or speak louder so that we can clearly hear your voice without subtitles?
@@ankitkeshari9362 thanks for the kind words ❤️. Oh I didn’t notice that my sound is not clear, are the others having same issue? I will try to be loader in the next videos!
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!
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
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 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.
This is the best RUclips channel I have ever seen for SQL The way he is explaining in really awesome
Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!
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 RUclips. I love you and your work so much.
Thank you so much 😀
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!
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!
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 ❤️
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.
That is the best class regarding SQL Window functions I have ever seen. Congratulations on your outstanding work!!
Glad to hear that!
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 :)
This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏
Very smart! Thanks for the nice words
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 🙂
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
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.
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 🥰
What a simple and easy explanation !! Thank you for the amazing tutorial
Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.
Thank you! I'm glad you enjoyed it!
hi Bara, I'm a programmer, not a data scientist, but thanks a lot. Ten years ago, Windows functions didn't exist; I just found out in 2022, but I didn't know how they worked. And you explained clearly to us.
Thanks
Great content man. This really helped me understand window functions more deeply
YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA
Thanks for the nice feedback !
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!
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 ❤️
You are great. A lot of work went into this - GREAT presentation. Thank you !!!
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😉
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! 😊📝
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!
Thanks man this helped me a lot
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!
Bhai....You are amazing teacher! Salute to you from India❤
You are amazing too for leaving wonderful comment
Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D
Thanks dear :)
Love how you explain it simply, I wish there are more activities or problems for us . Thanks alot dear.
My pleasure
Brilliant! 💙 Your talent to simplify such a complex concept is amazing. Thank you for sharing.
Thanks for the feedback ❤️
Bro, TOP MOST BEST CHANNEL ON RUclips 🎉🎉🎉. KEEP IT UP. PLEASE HAVE MORE COMPLEX ON SQL + POWER BI BRO 🙏🙏🙏🎉🎉🎉
That's one of the best!
Can't thank you enough!
You explain it very nicerly , hatsoff to you bara
hank you so much! I'm really glad you liked it! 🙏😊
Thanks! great content
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 :)
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
Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching
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!
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!
Awesome content !!! Loved they way you explain everything with great visuals !! 🐐
Like before viewing 👍
:)
Best Tutorial ever !!!!
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
YOUR VIDEOS ARE AWESOME BRO ❤❤🎉🎉 KEEP IT UP!!! 🎉🎉
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 ()
Highly educational, thank you
I totally loved your creative content.... so easy to understand lovedddd it
Thank you so much 😀
Excellent presentation. Thanks for sharing.
You are welcome thanks !
Thank you so much for such an amazing interactive session
You are welcome :)
Thank you so much! I have learned a lot from this vid :)
I'm so glad!
Appreciate your hard work. Thank from india
My pleasure
Your explanation awesome Baraaa😇😇😇😇😇😇😇
Finally Finally Finally I understood the concept and reason behind the window function😢❤Big burden is OVER() now.
I am happy it is OVER() :)
I see a lot of hard work in your content, I hope you get 1M Soon.
Just awesome !!!
Literally top notch content.....
Thanks !
Great lessons Baraa. I am a new subscriber now!!
@@rajeshantony74 welcome to the channel and thanks for supporting ❤️
best resource to learn for sql
great and clear explanation, thank you!
hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please
That was super helpful, thank you!
glad it helped, thanks for the nice comment
best teacher for sql ill learn tabealu from you too
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
How you create animation videos what kind of tool you using?
I used ProCreate :)
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
So easy to follow, thank you
Glad to hear than ❤️
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 .
So good. Thank you!!
Glad you liked it!
@baara can you post the full video for members only access ?
Sir please make a video on multiple tables joins in detail and also tell how the on condition works in joins.
Hi, i explained Joins in details in the Basic SQL Course, please check that out ruclips.net/video/NTgejLheGeU/видео.html
@@DataWithBaraa But sir, in that tutorial you explained the concept of join using only 2 tables, but I am confused about more than 2 tables join.
@@cretive549 noted I will do SQL project at the end of the course and tackle this topic
@@DataWithBaraa please sir make seperate video on that. I want to learn multiple tables join in detail
thanks for your valuable contents
So nice of you
THANK YOU SO MUCH FOR THIS CONTANT
WELCOME
Thanks for a wonderful lecture
Most welcome!
Fantastic content Baraa, I love ur videos keep up good work
Thanks, i will try my best :)
Amazing
Thank you Baraa. Just a little edit at time stamp 3634 the total should be 60 instead of 70.
Thanks for correction
Great video
Wonderful bro
Hi Baraa, Can you please add interview questions as well?
Getting such an amazing content for free feels like cheating.
Cant thank enough❤
You are so welcome
Excellent Master🎉🎉❤
Thank you! 😃
Can u tell me ,which website did you use to create all diagrams for better understanding?
@@rezanurkabir70 I use drawio and procreate
Thank you!
excellent explanation as always..
Glad you liked it!
Baraaa, you are the best guru for me, but could you please change your microphone or speak louder so that we can clearly hear your voice without subtitles?
@@ankitkeshari9362 thanks for the kind words ❤️. Oh I didn’t notice that my sound is not clear, are the others having same issue? I will try to be loader in the next videos!
Excellent video bro ! Can u make a total project in SQL
Thanks 👍
Welcome 👍
Hi, Can you also share the presentation and cheat sheet for this course on your website
Thanks as always.
You are always welcome
I wanna ask u Is there really coffee in that cup or is it just for fun
Ofc !! Without coffee I can’t do anything !!