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 !

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!

You don't need to go in any other channels to understand the window functions, this video is more than enough.

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

Brilliant! 💙 Your talent to simplify such a complex concept is amazing. Thank you for sharing.

Love how you explain it simply, I wish there are more activities or problems for us . Thanks alot dear.

This is actually a Granularity Level of explaination.. What a LOD explaination 👏👏👏👏👏

I wish I could subscribe a thousand times!!! one single subscription is not enough to justify this level of quality for your content !!!

Awesome content !!! Loved they way you explain everything with great visuals !! 🐐

Yesterday, I messed up in test with window functions...Came here! This really helped me. Thank alot Baraa!! You are really gifted with teaching!!

best resource to learn for sql

Excellent presentation. I appreciate your hand-drawn diagrams and breakdowns.

YOUR VIDEOS ARE AWESOME BRO ❤❤🎉🎉 KEEP IT UP!!! 🎉🎉

Finally Finally Finally I understood the concept and reason behind the window function😢❤Big burden is OVER() now.

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.

Literally top notch content.....

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.

Man! you teach the topics so well with visualizing every step! thank you!👏

YOUR EXPLAINATION ARE SOOOOO GOOD I CAME TO WINDOW FUNCTION BY SIMPLE WAY THANK U LOTSSSS ❤❤ BARAA

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 🥰

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.❤

wow! very useful tutorial, with a clear explanation and example. Hoping more content about data analysis you deserve a subscribed thank you!

What a man you are , your voice is so soothing i heard it on normal speed and understood everything great content man!

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.

Highly educational, thank you

You truly know how to teach well. Thanks for this tutorial!

I see a lot of hard work in your content, I hope you get 1M Soon.

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!

Hello, your teaching style is simple yet impactful, if you share dataset along with it, we can practice while watching

That's one of the best! Can't thank you enough!

Bro, TOP MOST BEST CHANNEL ON KZfaq 🎉🎉🎉. 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!

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!!!!

Bhai....You are amazing teacher! Salute to you from India❤

I totally loved your creative content.... so easy to understand lovedddd 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.

Thank you so much for such an amazing interactive session

That was super helpful, thank you!

So easy to follow, thank you

Thank you!! Really liked it, hope you complete this incredible course soon! We all appreciate this material :D

You explain it very nicerly , hatsoff to you bara

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

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 lessons Baraa. I am a new subscriber now!!

thanks for your valuable contents

Great video

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.

So good. Thank you!!

Like before viewing 👍

hi Baraa thank you so much for your amazing videos please make videos on sql performance tuning and debugging please

Excellent presentation. Thanks for sharing.

Correct 70 to 60 at 36.26 .... BTW the best video on SQL so far .Cheers Baraa

Thanks for a wonderful lecture

Thank you so much! I have learned a lot from this vid :)

THANK YOU SO MUCH FOR THIS CONTANT

best teacher for sql ill learn tabealu from you too

Getting such an amazing content for free feels like cheating.

Cant thank enough❤

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 ()

Awesome sharing. Thanks Baraa!

Thanks 👍

Thank you so much Sir ❤❤

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 ???

Wonderful bro

Sir please make a video on multiple tables joins in detail and also tell how the on condition works in joins.

Your videos are very addictive. KZfaq please take strict actions

Thank you ❤

excellent explanation as always..

Excellent Master🎉🎉❤

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?

Fantastic content Baraa, I love ur videos keep up good work

Great video, thank you! A bit curious, what's the software you're using to draw diagrams and stuff ?

Excellent video bro ! Can u make a total project in SQL

So damn good...

Thanks as always.

How you create animation videos what kind of tool you using?

the last problem can also be solved using the table as an alias select customerid,totalsales,rank() over(order by totalsales desc) as ranked from (select customerid, sum(sales) as totalsales from sales.orders group by customerid) as a

Thank you master!

Hi Baraa, Can you please add interview questions as well?

@baara can you post the full video for members only access ?

Please can you do python course? You teach differently.

Can u tell me ,which website did you use to create all diagrams for better understanding?

I wanna ask u Is there really coffee in that cup or is it just for fun

hey, i wasn't able to download free data materials of this course.. can u please provide the link.

Hi Baraa, we can use WHERE clause in WINDOW function inside FILTER function incase we are doing "Conditional Aggregation. Am I right?

SELECT Valuable_day FROM Days WHERE Valuable_day = You;

In real situation when we used frame what is the goal?!

How can I find the dataset . please help

Clearer at .75 speed….