SQL Window Functions Basics | Partition By, Order By, Frame | #SQL Course #3

☕ Stay connected

📚 Free Courses

🎓Other Platforms (Certifications)

⏱️ Timestamp
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

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**

[DataWithBaraa]

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

[davronazimov]

Thank you Baraa, l started watching window functions series, you made it so easy to understand, hats off to you for all your efforts.

[Ascendify]

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

[wonderoverload]

Bro, your way of teaching is just amazing. I just found you some days ago and I'm really happy. Those notes you make, the design, the animation, step by step explaining...it's just fabolous. Anyone can easily understand the concepts the way you make these videos. Your videos are so addictive. Nobody can't get bored with that stuff. I never felt to skip any part. I know this must take a lot of time to make, so hats off to you to putting your efforts in it.

[salmakhaled]

very underrated
thank u so much for introducing such advanced topics for free!
every one else just keep explaining basic stuff we already know

[harshmalhotra]

This is the best YouTube channel I have ever seen for SQL The way he is explaining in really awesome

[stewartmoore]

You explain this better than anyone I've ever seen... and I've watched a lot of tutorials. Insane. Thank you!!

[Robot-er]

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.

[ricardod]

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.

[rajdhaubanjar]

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

[WonderKids-dc]

This video is a perfect changer for the ones stuck in Window Functions, the way and style of teaching is brilliant. It's fun learning SQL from u. You're truly a underrated GEM!

[abdulkayumshaikh]

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.

[igwedavidadimchinobi]

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 YouTube. I love you and your work so much.

[sowmya]

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

[keyoordeshpande]

Amazing teaching skills. Even though these concepts come under advance category. You make them very simple to understand. Thank you!

[jephersonventura]

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!

[RakshitDwivedi-pqqc]

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!

[ctvtv-ngogiahuy]

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

[dramekandya]

Why didn't I know him before. This guy is such a source of inspiration that he is a good teacher. Everything becomes simple as if by magic

[MegaJohnwesly]

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