SQL Window Functions Basics | Partition By, Order By, Frame |

[@DataWithBaraa]

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 !

[@nikhilsharma-jj6vd]

Hi, Can you also share the presentation and cheat sheet for this course on your website. That'd be really helpful

[@abhishekpatel5067]

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!

[@gowthamiheroorsrikanth5018]

I don't know what to say, the way you explain with those graphics and that subtle background music makes me wanna fall in love with the subject. You made me realize learning new things doesn't always have to be hard and old school. Hats off to you and your effort. You really are the most unique tutor I've ever come across.

[@SaiBro-t5p]

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

[@jephersonventura7510]

@@SaiBro-t5p this tutorial is the best out there!

[@PowerBiWithVivek]

this videos are like newton discovered the laws of motion, and gave us the expression, we don't have to go through the same path, we only need to understand the expressions.

[@wonderoverload0]

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.

[@harshmalhotra1967]

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

[@stewartmoore5158]

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

[@davronazimov8749]

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

[@rajdhaubanjar]

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

[@DataWithBaraa]

Thank you! 😊 Really glad to hear the video was helpful

[@Robot-e4r]

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.

[@WonderKids-d9c]

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!

[@NikhilKumbhar-p2x]

I found an exceptional SQL series on KZbin, and I must say, it's truly a masterpiece! Thank you for curating such an insightful and impactful playlist-it’s a game-changer for learning SQL!

[@DataWithBaraa]

Welcome aboard!

[@SahilLodhi29]

I must say the efforts you put in your videos with a light background music and with those beautiful graphics and the way you explain everything is so BEAUTIFUL. You are the best teacher for me, I love learning from you, you make everything so easy for me and I always like your videos and share it to my friends. Thank you So Much Baraa ❤

[@funnophessor]

The only person to see for Advance SQL on youtube yet. Thanks a lottttttttttttttttttttt... BARAA bro

[@DataWithBaraa]

Happy to help

[@abdulkayumshaikh5411]

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.

[@ricardod671]

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.

[@salmakhaled500]

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

[@jephersonventura7510]

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!

[@igwedavidadimchinobi4739]

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

[@DataWithBaraa]

Thank you so much 😀

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

[@RakshitDwivedi-pq8qc]

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!

[@dramekandya4918]

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

[@Stephanie-ng9fw]

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.

[@TDMac11]

You're the most amazing teacher on KZbin. I've struggled with window functions in live coding interviews but you really made it understandable. Thank You.

[@DataWithBaraa]

Wow thanks really nice to hear that ✌️

[@Stuti12345]

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.

[@DataWithBaraa]

Tons of Thanks for your nice words, I'm glad that everyone is enjoy the course :)

[@pawankumarnalla1535]

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.

[@DivyYadav-hg2js]

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

[@kalyanichoudhari5348]

Best channel for advanced SQL.

[@DataWithBaraa]

Thanks 😍

[@deepam.g4558]

You are god of content creators. Thank you so much for putting so much effort in visualizing the course.

[@funnophessor]

exactly

[@keyoordeshpande533]

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

[@SAhmBal89]

I wish I had found someone like Baraa earlier to teach me like this. Although I knew some of these functions, my concept is becoming much clearer, and I'm now able to understand what SQL is doing behind the scenes.

[@DataWithBaraa]

Amazing !

[@wapikasamanta4780]

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.

[@dhawalprajapati3705]

It is totally worthy content , Teaching Quality and the way of explanation can be defined as how to make complex things easy, with pictorial explanation it become very easy to understand and grasp it. Thanks dude!!!!!!!!!!!!!!

[@mconte77]

That is the best class regarding SQL Window functions I have ever seen. Congratulations on your outstanding work!!

[@DataWithBaraa]

Glad to hear that!

[@poojabihani-m9d]

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

[@ctvtv-ngogiahuy5807]

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

[@DataWithBaraa]

Wow thanks so much, your support means a lot for me and motivate me to make more content 🙂

[@TheJADHAVRAM]

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

[@DataWithBaraa]

Thanks for the kind words ❤️

[@marywangui7117]

am glad to find your channel today . you are a great teacher

[@iparpankaj]

Awesome!! I never seen such tutorial for free of cost !! much appreciated and keep up the good work of spreading knowledge!!

[@adrianor85]

Now I understand how the window function works. Thanks for the video!

[@belqassemmehdielyagoubi5078]

Great video! It's clear and helpful. Thanks for sharing your SQL knowledge!

[@sowmya6471]

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

[@DataWithBaraa]

Very smart! Thanks for the nice words

[@mohammadthousif7439]

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.

[@khawla092]

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 🥰

[@ISLAMICVIDE11]

I am really so grateful to you for providing such a high quality content free. May god bless you.....

[@PowerBiWithVivek]

I already have some knowledge of SQL, but going through the complete picture of window functions will remove the gaps, and will help me understanding why my query not working. Keep making these detailed and well explained video. Hope to see the Python and Power BI videos soon, and can we get some project of data analysis that is not for beginner but for some experienced guy like me , because that can help people like me get what the real world data look like, and what kind of analysis done on the data and what is the process to do data analysis, so can prepare us for interview with real life project for portfolio, and i hope to see it soon, and I love the content and energy.

[@HarshSingh-j8n]

Best Vedio and best explanation in my entire Education I have ever seen. Thanks a lot.

[@NohablaEspnaol]

You channel is a goldmine sir, thank you soo much!!

[@pinkythanu8766]

Hats off to you for sharing so much valuable contents for free ❤❤ THANK YOU SO MUCH sir... You are my Tableau and Sql guru

[@sominramchiary5880]

What a simple and easy explanation !! Thank you for the amazing tutorial

[@Theunemployedmen]

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

[@DataWithBaraa]

Wow, thanks dear ❤️

[@padhi100]

Best KZbin 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.

[@DataWithBaraa]

Oh really !! Thank you, I hope the students will like it 😊

[@krizzylovesnature]

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

[@DataWithBaraa]

My pleasure

[@sritamkumarrout4499]

Best window function class ever❤

[@gopikrishnasistla8896]

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.

[@DataWithBaraa]

Thanks and welcome, so nice of you!

[@kadirsuzen6696]

thanks millions of time. I love the way of your explaning and your presantation. !!!!

[@sapbo2284]

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.

[@DataWithBaraa]

Thanks for taking time writing this wonderful comment i really appreciate and happy to hear my content is helping. Have a nice day😉

[@ShalomMansoor-d8z]

You are great. A lot of work went into this - GREAT presentation. Thank you !!!

[@XYZandRGB]

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

[@DataWithBaraa]

Thank you! I'm glad you enjoyed it!

[@Parvin-m1s]

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

[@tumelomohale9766]

Great content man. This really helped me understand window functions more deeply

[@FRANELC-ss8sz]

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

[@DataWithBaraa]

Thanks for the nice feedback !

[@srikarreddy8252]

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

[@DataWithBaraa]

Glad you think so!

[@VigneshIyer-z9w]

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.

[@firstNamLastName-x6n]

best ever tutorials for sql ....thank you so much sir...!

[@DataWithBaraa]

Most welcome!

[@rezanurkabir70]

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!

[@DataWithBaraa]

Thanks for taking time writing this amazing feedback, I really appreciate it.

[@poojabihani-m9d]

Best Tutorial ever !!!!

[@sam_nyoike]

The hand-drawn diagrams were super helpful in understanding the topic. Great teaching methodology!

[@DataWithBaraa]

Thanks a lot! I'm happy to hear the hand-drawn diagrams made the topic clearer! 😊📝

[@akilagopinathg]

Great teaching, Thanks a ton!

[@jaideepthanage4934]

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

[@DataWithBaraa]

You are amazing too for leaving wonderful comment

[@GowdaKiranGangadhar]

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

[@DataWithBaraa]

Thank you for the amazing feedback :)

[@Banthi29]

Thank you so much for creating videos like this one! It's very clear and easy to follow

[@mochamadsyahrizal]

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

[@DataWithBaraa]

You're very welcome!

[@QPOSTB1]

what an amazing teacher 🤩🤩🤩🤩

[@Hi-pi7dd]

You are the # 1.

[@Ansari_FX]

When I found you, forget all Only BARAA❤❤

[@hafedhabdulhafeedh3195]

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

[@minjon56]

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

[@DataWithBaraa]

Thanks for the feedback ❤️

[@adrianoschwenkberg6773]

Highly educational, thank you

[@sagarprajapati6026]

Literally top notch content.....

[@DataWithBaraa]

Thanks !

[@snowclip7457]

Thanks man this helped me a lot

[@mohamedasiq4613]

Really worth baraa 💥👍

[@chidimbamalu3490]

Like before viewing 👍

[@DataWithBaraa]

:)

[@makarsh29]

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

[@RohitKumar-kd5fj]

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

[@DataWithBaraa]

Thanks for the info!

[@RohitKumar-kd5fj]

@@DataWithBaraa Indeed thanks to you Barra. Please make videos on sql order of execution in complete details .

[@uncanny8687]

Appreciate your hard work. Thank from india

[@DataWithBaraa]

My pleasure

[@ashutoshmishra-in9vt]

Your content is superb sir

[@gospelmoto2833]

EXCELLENT! you explained it well with amazing animation. You must be more than a teacher! Thanks, learned a lot. New sub here.

[@DataWithBaraa]

Thanks for the sub!

[@juancruz7836]

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

[@DataWithBaraa]

Thanks dear :)

[@nitinrawat-g6t]

best teacher for sql ill learn tabealu from you too

[@muhammadtahirmehmood7869]

Great work and presentation along with wonderful detail

[@tarusheebhalla1196]

I totally loved your creative content.... so easy to understand lovedddd it

[@DataWithBaraa]

Thank you so much 😀

[@ashutoshmishra4781]

You explain it very nicerly , hatsoff to you bara

[@DataWithBaraa]

hank you so much! I'm really glad you liked it! 🙏😊

[@shreyashmhatre9606]

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

[@nitinrawat-g6t]

best resource to learn for sql

[@godbhaigod]

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

[@DataWithBaraa]

I am happy it is OVER() :)

[@joyotiegbe1549]

Excellent presentation. Thanks for sharing.

[@DataWithBaraa]

You are welcome thanks !

[@daayush6654]

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

[@abhishekpatel5067]

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!

[@farukhahmad1561]

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

[@anilreddy1078]

Your explanation awesome Baraaa😇😇😇😇😇😇😇