SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN |

[@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:00:28 What are Window Aggregate Functions? 00:02:50 Window Function: COUNT 00:19:33 Window Function: SUM 00:26:58 Window Function: AVG 00:36:02 Window Function: MIN & MAX 00:45:39 Running Total & Rolling Total 00:55:15 Moving Average 01:04:22 Summary Enjoy ☕

[@pinakastra]

I'm not sure whether you would ever come across my comment or not, but just need to say a very big "Thank You". I am one of those thick headed people who cannot understand any concept easily unless it's broken into very basic pieces. Truth be told I have been working with Python from last 5+ years, I have worked on a lot a big projects including Backend, Automation, AI/ML projects, etc. successfully, even led a team of people but I always used to run away from SQL as I felt very bored whenever I started. But you my friend, the way you have taught me SQL is just out of the box. The only person who actually made me interested in learning this is "YOU" and I will always be thankful to you for that, forever.

[@DataWithBaraa]

Wow amazing thank you for taking your time writing your experience, I am really glad to help!

[@SAhmBal89]

I've consumed many other contents and even taken paid courses, but it felt like something was still missing to help me understand things clearly. However, after watching your content, I feel like I don't need to look elsewhere. The way you explain advanced queries in simple terms is superb. For me, your content is truly invaluable - it's like finding treasure. Thank you.

[@MALIK_AR7]

u deserve a Nobel peace price for ur services barra

[@DataWithBaraa]

Oh thats a lot but thanks dear

[@deepam.g4558]

I agree

[@kevinrambo]

Superbly explained and you speak very fluently. No 'ums', 'uhs', 'likes', and 'ya knows' that are so common. Thank you for posting, big fan here!

[@jephersonventura7510]

This is my 2nd comment on your videos and I will again say that you are doing wonders in teaching me advanced things. 6 months ago I lost my job and been looking to pivot into Analytics. You've now empowered me with tools and education that I thought was impossible. Thank you again for your hard work. Hope you see this comment and see the impact you're having on thousands of people!

[@DataWithBaraa]

Oh wow, ofc i read each comment, first of all i am sorry that you lost your job, but in other hand i am happy to hear that i was able to make a change in your life, this is exactly why i make these courses for free to help people and specially students that can’t afford paying for expensive courses. Your comments has motivates me more than you imagine to keep pushing and generate more content, because it is not easy to do as this is side thing i do beside my job. Thanks again and i hope you find a better job soon, keep me updated please.

[@LMessii10]

Criminally underrated, after spending 2 days searching numerous videos about these SQL functions and getting confused everytime, thankfully i found your channel. Crystal clear explanation. Absolutely the best ! I am highly obliged Baara. Thank you

[@DataWithBaraa]

Great to hear!

[@poojabihani-m9d]

Thank you Bara, this is my 2nd comment as this is my 2nd tutorial which I watched from your channel. and all i want to say Thank You so Much, You are an answer to my prayers as i remember yesterday i was crying because I Have watched alot of tutorials on youtube for did not satisfied with the content and teaching style and today i found your channel and tears of happiness are flowing through my eyes as till this time i have completed 2 of your tutorial on window function and make notes and i am getting everything you are explaining and understanding each of these topics , PLEASE NEVER STOP PROVIDING THESE TOP NOTCH CONTENT AND waiting for more advanced tutorials ( stored procedures, triggers, indexes and more) . Thank you so much for providing these contents for free as there are students like me who cannot afford expensive courses and there are you an angel to me , really made my day and plays a very important role in my life !!!

[@PowerBiWithVivek]

I just cant get enough of it, such a well explained tutorial, i have just watched the 2 hours of window functions, and feel i am hungry for more, such a nice tutorial.

[@wonderoverload0]

So impressive that I just bought your Tableau course on Udemy.

[@firstNamLastName-x6n]

what a teacher you are man..! damn good... thank for this tutorials..

[@alexshat4715]

Baraa thank you for the detailed explanation, not every teacher can explain complex things with simple examples. I am very glad that I came across your videos) Thank you for the excellent content and knowledge.

[@apostoloskozanitis5688]

A massive thanks to you Bara for offering to us this really precious content ! We really apreciate it

[@DataWithBaraa]

@@apostoloskozanitis5688 thanks dear glad you liked it ❤️❤️

[@azaansfunworld4300]

I don't miss any of your videos. I have never seen anyone explaining so clearly, feels like wow!

[@DataWithBaraa]

Wow amazing feedback thanks for supporting 😀

[@maoquanjiao2857]

Thanks your great work for The SQL and Tableau. That gave me a lot of helping for Data Analysis project. Your are the best Teacher!!

[@samhudaya7549]

Your content is exceptional, especially considering it's freely available. I've watched your entire Tableau series, and the concepts are crystal clear. Much appreciated! Can you do looker videos also

[@DataWithBaraa]

Thank s I appreciate your words, I will consider it 😊

[@umarahmad2817]

Dear Bara, I am from Pakistan. I have no words, to describe my love and gratitude for you. Only Allah can give you better Jaza(reward).

[@GowdaKiranGangadhar]

Hey, Bara! Your explanation was clear and easy to follow. I really appreciated how you broke down all the topics step by step. Now, I'm eagerly awaiting for the next video

[@DataWithBaraa]

Awesome, thank you!

[@sakshideshmukh2130]

absolutely the best advance SQL course out there!

[@DataWithBaraa]

Glad you think so!

[@SahilGupta-s2w]

Best faculty to master Sql for data analysis🎉❤

[@ImtiyazMohammed-mp8mp]

The time and effort you've put is evident, love the explanation and the visualization. I know you are at 36k subscribers now but soon it will be millions InshaAllah. Love your work. Thank you.

[@DivyYadav-hg2js]

please dont stop braa loved ur channel

[@akashyuvaraj7275]

Love from India Thankyou for wonderful tutorial sir

[@arbazblog786]

bara baro, first time i have seen master of sql in youtube and you have made advance sql in easiest and simple , thank you a lot bro. plz make more video regrading complet python tool

[@DivyYadav-hg2js]

ur amaing baraa im a student and in love with ur videos highly recommend this channel for complete information as on all the rest channel no one is providing indepth clarity and lacking the complete information ur amazing my friend

[@AchalZensar]

Awesome tutorials on Window Functions. Very detail-oriented. Keep up the great work Baraa!

[@Humanity_matters_1st]

Wow, this tutorial was super helpful! You explained everything so clearly and made even the tricky parts easy to understand. Thanks for taking the time to create such high-quality content-can't wait to watch more of your videos!

[@DataWithBaraa]

Thanks for your kind support, glad you liked it ❤️

[@MuhammadEhtisham-cm5vr]

the best content and page i ever found , plz complete the series , you are the best bara !

[@DataWithBaraa]

@@MuhammadEhtisham-cm5vr thanks 🙏 I’ll do my best ❤️

[@user-wc1wu3ls9d]

Wacthing from Indonesia, you are the best teacher i found in this platform

[@DataWithBaraa]

Love from Germany ! Thanks 🙏

[@ayushshukla5255]

Sir, you are amazing whether we talk about skills or presentation visuals or anything , Just a humble request please create a full tutorial for SQL advanced

[@DataWithBaraa]

Nice to hear, I am working on it 👍

[@klid662]

Bro, i have learn from you about tableau and then try to learn sql. You are far superior than other youtuber due to give explanation each concept

[@rajkumarpandey3788]

This was amazing thing which I have seen ever for SQL teaching skills, it will give more values to your teaching if you also provides the ppt which you are presenting for last movement revision.

[@vikashsoni9200]

Thank you, sir. You have great knowledge. Your teaching style is very good.

[@tomylapoiss452]

Thank you this tutorial. At 26:54 when you are calculating the percentage contribution by product, you actually did the contribution by order… I was expecting you to group sales by product before dividing by the total sales.

[@ekambat]

undoubtedly the best..Thanks Baraa

[@khalidazizi8346]

I don't know how to appreciate you. You are the best among all

[@Dennisaj]

*"This is the most CRIMINALLY UNDERRATED KZbin channel barn NONE!!!" Brah... Can you imagine if you did an entire 20-40 hour course on Java, C#, Python, or C++?*

[@DataWithBaraa]

@@Dennisaj thanks! Sadly over 75% of viewer watching continues my content, don’t support the channel by subscribing, liking and commenting. Which leads KZbin algorithm not to suggest my content with others. I hope in future that I can reach more people otherwise I will be forced to stop or make my courses with payment which I really hate to do and try to keep it for free because there are many students that can’t effort to buy courses.

[@sreenidhi3342]

Thanks a lot ​@@DataWithBaraa

[@rezanurkabir70]

Thank you for another fantastic SQL tutorial! Your explanations are clear and easy to follow. 👌

[@dayal4256]

Very Big Thank you for cutting edge clear content with perfect real time examples. Expecting More Valuable Content from your side like this , Once Thank you so much for the Content and your teaching style !!

[@shubh_pokharkar8145]

sum(expression ) over( partition by expression order by expression frame(row or range btw lower limit to higher ) in over inside parenthesis we write or define window or partition on which function to be exectuded , use partition by if want to creatre multiple windows in table for calculations and order by to sort the rows inde wondows or entire window and frame clause is used to define we want function to be executed on entire prtition or subset of rows in that partition

[@OscarBalwin]

Thank you for your dedication in helping us all in expanding our knowledge and understanding! You are really above and beyond instructor -big appreciation Baraa

[@DataWithBaraa]

Hi Oscar, thanks for the amazing feedback! I really appreciate it.

[@DivyYadav-hg2js]

im glad i found u bara

[@FirangizMuslumzada]

this course is just superb! you are the teacher of all teachers . cheers, baraa!

[@srikarreddy8252]

This is THE BEST video on aggregated window functions!!

[@DataWithBaraa]

Nice ❤️

[@ashutoshmishra4781]

Your technique of explaining by visual are just amazing🔥🔥

[@DataWithBaraa]

Thanks a lot! I'm glad you enjoy it! 🎉🔥

[@letsdomistakes]

Thank you Baraa for these amazing tutorials.

[@DataWithBaraa]

@@letsdomistakes you are welcome dear!

[@MalayKumar1000]

Hey! Baraa...thank you so much. You have been the guiding light for me. Not sure if there is someone else who can explain these topics with so much alacrity. Will surely recommend you to every other student I meet.

[@hussamoulan2260]

You are amazing Sir, your slides, your way of explaining things, is just fabulous. My English is not well but you explain things in such a way that even a person like me can understand it very well❤

[@simonameshkova7149]

Hello, Baraa :) Already gone through the SQL and Advanced SQL courses and half of Tableau course so far and appreciate your work - it's easily understandable and you make even the difficult parts seem easy. Can you extend a little bit the explanation for the aggregate functions with DISTINCT - count, sum etc. It'll be really helpful.

[@DataWithBaraa]

Hi, I really appricate your feedback and happy to hear you are enjoying the content. I will try to add it throughout the course.

[@simonameshkova7149]

@@DataWithBaraa Thanks for your answer. Can you share how often will you upload a new video as part of the Advanced SQL Course considering the complexity of the topics of course? Can't wait for the next one. :)

[@FRANELC-ss8sz]

Baraa it's just like a wowwwwww Detailed explaination super❤❤❤ from india

[@berno10]

Awesome! Awesome! instructor, so glad I found your page your teaching skills are top-notch. Thank you for sharing with us

[@Bhargavi-vz1zt]

love the way you explain!! Thank you for such informative videos.

[@DataWithBaraa]

You are so welcome!

[@Sathish-fugo]

Hi , you helped me a lot through your Lecture .Now I got a better knowledge on SQL . Thanks for your Work . Love From INDIA ❤

[@muhamedhalil]

Amazing content. Keep these videos coming, they are priceless.

[@OrtikAbdakimov]

the best sql tutorial course !!! Thank you for your effort and contribution! Please continue it as u showed the road map for sql in the first video. Thank you

[@DataWithBaraa]

Thanks, will do!

[@irfanshaikh-ck5lz]

❤ Love from the india baraa keep posting videos regularly

[@hemucool5678]

Very much appreciated. Top-notch classes!

[@baobanks1692]

Best tutorial ever i mean ever!!!!!!!!

[@anjalisingh1205]

Hello Baraa! Your SQL tutorials have been incredibly helpful in my learning journey. You're the best tutor I've found on KZbin. I downloaded the database file you provided but unfortunately, I am having trouble unzipping it. I’ve tried several solutions, but it seems the file might be corrupted. Could you please re-upload it? Thank you for your help, and keep up the fantastic work!

[@purushottammitra1258]

Awesome Content Baraa!! Love from India!

[@DataWithBaraa]

thanks love back from Germany !

[@Stranger360yt]

Man your videos are awesome. Easy to grasp the concept. And may I know how to get the database which your using in the video?

[@daayush6654]

Amazing explanations with the visuals

[@DataWithBaraa]

Thanks !

[@amarpawar-tl5we]

Pls give download option for downloading the material. unable to download queries and material ! Please check at once. Amazing content with great teacher !!! Thank you.

[@santoshkiran5858]

❤❤❤ Mind-blowing lecture Awesome

[@hariharansrinivasan9493]

Hi bara,lessons are really good but not able to download/see the notes that which you have been used in this advance sql chapter.. In noted section download it redirects to Microsoft server sql page not able to refer the notes,pls upload the advance sql topic notes

[@DataWithBaraa]

I'll fix it

[@hariharansrinivasan9493]

@DataWithBaraa thanks for the reply bara! It would be really helpful for us once the advance SQL notes is available as soon as possible,thanks

[@mohammadthousif7439]

At 54:08 i think the aggregation for the last row should be 115

[@sunpreetsingh5143]

Bara YOU ARE AMAZING :)..u make it extreamly easy to understand..

[@DataWithBaraa]

You are more amazing for leaving this kind comment 😊

[@AhmedRehan01]

Thanks Baraa for these amazing lectures. Can you please provide the recommended order for watching these videos?

[@DataWithBaraa]

Yes please follow the playlist :) kzbin.info/www/bejne/e33Hq2Oajd-Kfa8

[@AhmedRehan01]

@@DataWithBaraa thank you

[@ransfordsaddicamoleka2924]

Finally, ....thanks very much Sir

[@Toyahan43]

Another awesome tutorial! Can you please tell me how I can access the presentation notes for this?

[@gopikrishnasistla8896]

Hi sir Is Running avg and moving avg Both are same or not . Sir why advance sql classes going on sql server and not used in mysql Thank you sir

[@rezanurkabir70]

Best and precise. Make a course about postgreSQL 😍👍

[@CuocSongQuanhTa204]

Hi Baraa. I really your white board presentation. May I ask what that software do you use? Thanks in advance!

[@DataWithBaraa]

Procreate

[@GuyOrlov]

on 46:10 there is an error spell, should be 'historical' no 'hisotrical' paterrns. but great video I needed this.

[@donyelldf]

Great video and explanation, thank you

[@DataWithBaraa]

Glad it was helpful!

[@azaansfunworld4300]

I am your fan for the way you explain :)

[@DataWithBaraa]

Ah you like it? Very happy to hear that

[@asrithagudla4865]

hy hi can i know why are we writing t in sudquery at 42:44

[@arianeteixeira9144]

Thank you very much for this amazing class.

[@DataWithBaraa]

You are welcome 😊

[@nethrakr]

Hi, why do we add 't' while writing a subquery with WHERE clause, what is this 't'?

[@yashkamath9969]

t is an Alias, since we need to name any derived tables

[@nitinrawat-g6t]

YOUR CHANNEL IS GEM ! BUT REALLY UNDERRATED

[@DataWithBaraa]

Thanks atleast reached you !

[@udaymehta8917]

Thank you very much sir for your LOVE towards free & open & quality education. Nowadays, I watch & practice your SQL Advanced videos to fulfill my day. Your video made my day. I' very happy today, because of your hard work. Also, I'm going for Interview today and this video is acting like Cnfidence booster for me. Also, kindly share your India Travel experience. If you're still in India, is it possible to meet with you sir?

[@DataWithBaraa]

Thank you so much for your kind words! Best of luck with your interview-you’ll do great! 🙌 My India trip was amazing-such a vibrant and inspiring place. I’m not there anymore, but I’d love to visit again!

[@lakshmie3203]

Hi Baraa... How are you doing???? A very big thanks to you for this SQL class video and other classes... excellent detailed explanation ...thanks alot Baraa..

[@DataWithBaraa]

You are welcome!

[@micaelzekarias1537]

So fantastic thanks.

[@Ascendify5]

Thank you for making me data hungry😋 waiting for your next class master let's go🎉

[@DataWithBaraa]

Most welcome 😊

[@aditipanwar4568]

Too good!

[@DivyYadav-hg2js]

leave a like for this gem teacher

[@rakibulhaque3444]

Thanks

[@asrithagudla4865]

thank you

[@tejaskhairnar620]

Thank you sir for these amazing tutorials. plz share the presentation mention in that tutorials

[@tnarijit6062]

Where I get the table u used?

[@ak3965-l8q]

is pdf available ??

[@SaidurRahman-c8w]

sir, can u please provide these sketch notes, they're not available on the website.

[@jezdel6298]

I tried restoring database for your SalesDB.bak file from your link but it keeps failing.

[@DataWithBaraa]

What error are you getting

[@jezdel6298]

@@DataWithBaraa Execution Error : Restore of database 'SalesDB' failed.

[@AmitYadav-vb5bs]

Sir, Could you please make an industry-level project related to SQL

[@DataWithBaraa]

Yes it will be last chapter

[@tumelomohale9766]

Hi Baraa, is this MySQL or PostgreSQL? If MySQL, how much of this is transferrable (as it is) to PoastgreSQL?

[@arnavsharma2485]

please put videos for pyspark as well and if possible for R also

[@SaadiaZahoor]

Thnx brother

[@DataWithBaraa]

Welcome

[@QPOSTB1]

hi teacher i have a question can i use max and min with name ?

[@DataWithBaraa]

Yes

[@alzhrthy]

damn if i could like this more than once

[@DivyYadav-hg2js]

bara i urge u to get data science projects tooo plz