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 ☕
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!
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.
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
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!
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.
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
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
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
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
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 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. :)
*"This is the most CRIMINALLY UNDERRATED UA-cam channel barn NONE!!!" Brah... Can you imagine if you did an entire 20-40 hour course on Java, C#, Python, or C++?*
@@Dennisaj thanks! Sadly over 75% of viewer watching continues my content, don’t support the channel by subscribing, liking and commenting. Which leads UA-cam 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.
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..
Baraa I m following your SQL beginners course and done joins chapter and has a doubt: Inner joining on two tables having duplicate values the result table is something else,I m confused can you explain it or it would be great if you explain it by uploading a video😁. Thank you
Hi sir krish here. Using my samsung mobile i download Sales db , oltp, dwh data sets . All are in .bak file format. I am unable to open .Bak files in my mobile. Means file format not support to open Sir request help from your side. Thank you
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 ☕
u deserve a Nobel peace price for ur services barra
Oh thats a lot but thanks dear
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!
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.
absolutely the best advance SQL course out there!
Glad you think so!
Wacthing from Indonesia, you are the best teacher i found in this platform
Love from Germany ! Thanks 🙏
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
Thank s I appreciate your words, I will consider it 😊
This is THE BEST video on aggregated window functions!!
Nice ❤️
Very much appreciated. Top-notch classes!
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!
Thanks for your kind support, glad you liked it ❤️
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.
this course is just superb! you are the teacher of all teachers . cheers, baraa!
Your technique of explaining by visual are just amazing🔥🔥
Thanks a lot! I'm glad you enjoy it! 🎉🔥
the best content and page i ever found , plz complete the series , you are the best bara !
@@MuhammadEhtisham-cm5vr thanks 🙏 I’ll do my best ❤️
I don't know how to appreciate you. You are the best among all
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
Hi Oscar, thanks for the amazing feedback! I really appreciate it.
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
Awesome, thank you!
Thank you, sir. You have great knowledge. Your teaching style is very good.
I don't miss any of your videos. I have never seen anyone explaining so clearly, feels like wow!
Wow amazing feedback thanks for supporting 😀
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
Thanks, will do!
Amazing content. Keep these videos coming, they are priceless.
Hi , you helped me a lot through your Lecture .Now I got a better knowledge on SQL . Thanks for your Work . Love From INDIA ❤
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
Nice to hear, I am working on it 👍
Awesome! Awesome! instructor, so glad I found your page your teaching skills are top-notch. Thank you for sharing with us
Baraa it's just like a wowwwwww Detailed explaination super❤❤❤ from india
Thank you Baraa for these amazing tutorials.
@@letsdomistakes you are welcome dear!
love the way you explain!! Thank you for such informative videos.
You are so welcome!
Best and precise. Make a course about postgreSQL 😍👍
Amazing explanations with the visuals
Thanks !
Finally, ....thanks very much Sir
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.
Hi, I really appricate your feedback and happy to hear you are enjoying the content. I will try to add it throughout the course.
@@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. :)
Thank you for another fantastic SQL tutorial! Your explanations are clear and easy to follow. 👌
Awesome tutorials on Window Functions. Very detail-oriented. Keep up the great work Baraa!
Thank you for making me data hungry😋 waiting for your next class master let's go🎉
Most welcome 😊
Awesome Content Baraa!! Love from India!
thanks love back from Germany !
*"This is the most CRIMINALLY UNDERRATED UA-cam channel barn NONE!!!" Brah... Can you imagine if you did an entire 20-40 hour course on Java, C#, Python, or C++?*
@@Dennisaj thanks! Sadly over 75% of viewer watching continues my content, don’t support the channel by subscribing, liking and commenting. Which leads UA-cam 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.
Thanks a lot @@DataWithBaraa
thank you
I am your fan for the way you explain :)
Ah you like it? Very happy to hear that
So fantastic thanks.
❤❤❤ Mind-blowing lecture Awesome
Great video and explanation, thank you
Glad it was helpful!
YOUR CHANNEL IS GEM ! BUT REALLY UNDERRATED
Thanks atleast reached you !
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..
You are welcome!
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
Thanks Baraa for these amazing lectures. Can you please provide the recommended order for watching these videos?
Yes please follow the playlist :) ua-cam.com/video/ELdz0dXzWGM/v-deo.html
@@DataWithBaraa thank you
Thnx brother
Welcome
Thank you very much for this amazing class.
You are welcome 😊
Sir, Could you please make an industry-level project related to SQL
Yes it will be last chapter
sir, can u please provide these sketch notes, they're not available on the website.
Hi Baraa. I really your white board presentation. May I ask what that software do you use? Thanks in advance!
Procreate
please put videos for pyspark as well and if possible for R also
Baraa I m following your SQL beginners course and done joins chapter and has a doubt:
Inner joining on two tables having duplicate values the result table is something else,I m confused can you explain it or it would be great if you explain it by uploading a video😁.
Thank you
❤
❤
24 Carat GOLD.
At 54:08 i think the aggregation for the last row should be 115
Can u have ressources of window part?!
hy hi can i know why are we writing t in sudquery at 42:44
In the rolling total example, the last example should not be 115 instead of 105
🙏🙏🙏👌👌👌
Cannot restore the SaleDB.
Hi sir krish here. Using my samsung mobile i download
Sales db , oltp, dwh data sets . All are in .bak file format.
I am unable to open .Bak files in my mobile. Means file format not support to open
Sir request help from your side.
Thank you
Use a pc or laptop 😉