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 ☕
@MALIK_AR7
5 ай бұрын
u deserve a Nobel peace price for ur services barra
@DataWithBaraa
5 ай бұрын
Oh thats a lot but thanks dear
@gopikrishnasistla8896
5 ай бұрын
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
@samhudaya7549
5 ай бұрын
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
5 ай бұрын
Thank s I appreciate your words, I will consider it 😊
@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.
@poojabihani-m9d
14 күн бұрын
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 !!!
@ayushshukla5255
4 ай бұрын
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
4 ай бұрын
Nice to hear, I am working on it 👍
@toyahan7195
7 күн бұрын
Another awesome tutorial! Can you please tell me how I can access the presentation notes for this?
@vikashsoni9200
4 ай бұрын
Thank you, sir. You have great knowledge. Your teaching style is very good.
@hemucool5678
29 күн бұрын
Very much appreciated. Top-notch classes!
@muhamedhalil
Ай бұрын
Amazing content. Keep these videos coming, they are priceless.
@FRANELC-ss8sz
5 ай бұрын
Baraa it's just like a wowwwwww Detailed explaination super❤❤❤ from india
@SaidurRahman-c8w
Ай бұрын
sir, can u please provide these sketch notes, they're not available on the website.
@rezanurkabir70
2 ай бұрын
Best and precise. Make a course about postgreSQL 😍👍
@mohammadthousif7439
2 ай бұрын
At 54:08 i think the aggregation for the last row should be 115
@ransfordsaddicamoleka2924
2 ай бұрын
Finally, ....thanks very much Sir
@GowdaKiranGangadhar
4 ай бұрын
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
4 ай бұрын
Awesome, thank you!
@user-wc1wu3ls9d
2 ай бұрын
Wacthing from Indonesia, you are the best teacher i found in this platform
@DataWithBaraa
2 ай бұрын
Love from Germany ! Thanks 🙏
@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 ❤️
@ashutoshmishra4781
3 ай бұрын
Your technique of explaining by visual are just amazing🔥🔥
@DataWithBaraa
3 ай бұрын
Thanks a lot! I'm glad you enjoy it! 🎉🔥
@lakshmie3203
5 ай бұрын
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
5 ай бұрын
You are welcome!
@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!
@CuocSongQuanhTa204
5 ай бұрын
Hi Baraa. I really your white board presentation. May I ask what that software do you use? Thanks in advance!
@DataWithBaraa
5 ай бұрын
Procreate
@Bhargavi-vz1zt
3 ай бұрын
love the way you explain!! Thank you for such informative videos.
@DataWithBaraa
3 ай бұрын
You are so welcome!
@Ascendify5
5 ай бұрын
Thank you for making me data hungry😋 waiting for your next class master let's go🎉
@DataWithBaraa
5 ай бұрын
Most welcome 😊
@AmitYadav-vb5bs
5 ай бұрын
Sir, Could you please make an industry-level project related to SQL
@DataWithBaraa
5 ай бұрын
Yes it will be last chapter
@simonameshkova7149
5 ай бұрын
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
5 ай бұрын
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
4 ай бұрын
@@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. :)
@tumelomohale9766
12 сағат бұрын
Hi Baraa, is this MySQL or PostgreSQL? If MySQL, how much of this is transferrable (as it is) to PoastgreSQL?
@AhmedRehan01
4 ай бұрын
Thanks Baraa for these amazing lectures. Can you please provide the recommended order for watching these videos?
@DataWithBaraa
4 ай бұрын
Yes please follow the playlist :) kzitem.info/news/bejne/poKa4GSakayIeoI
@AhmedRehan01
4 ай бұрын
@@DataWithBaraa thank you
@letsdomistakes
Ай бұрын
Thank you Baraa for these amazing tutorials.
@DataWithBaraa
Ай бұрын
@@letsdomistakes you are welcome dear!
@krna3058
Ай бұрын
24 Carat GOLD.
@purushottammitra1258
3 ай бұрын
Awesome Content Baraa!! Love from India!
@DataWithBaraa
3 ай бұрын
thanks love back from Germany !
@santoshkiran5858
5 ай бұрын
❤❤❤ Mind-blowing lecture Awesome
@micaelzekarias1537
4 ай бұрын
So fantastic thanks.
@daayush6654
Ай бұрын
Amazing explanations with the visuals
@DataWithBaraa
Ай бұрын
Thanks !
@rakibulhaque3444
17 күн бұрын
Thanks
@MalayKumar1000
2 ай бұрын
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.
@asrithagudla4865
Ай бұрын
thank you
@umarahmad2817
18 күн бұрын
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).
@Sathish-fugo
28 күн бұрын
Hi , you helped me a lot through your Lecture .Now I got a better knowledge on SQL . Thanks for your Work . Love From INDIA ❤
@berno10
Ай бұрын
Awesome! Awesome! instructor, so glad I found your page your teaching skills are top-notch. Thank you for sharing with us
@AchalZensar
5 ай бұрын
Awesome tutorials on Window Functions. Very detail-oriented. Keep up the great work Baraa!
@azaansfunworld4300
5 ай бұрын
I don't miss any of your videos. I have never seen anyone explaining so clearly, feels like wow!
@DataWithBaraa
5 ай бұрын
Wow amazing feedback thanks for supporting 😀
@donyelldf
5 ай бұрын
Great video and explanation, thank you
@DataWithBaraa
5 ай бұрын
Glad it was helpful!
@ArbazKhan-fy4vk
5 ай бұрын
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
@azaansfunworld4300
5 ай бұрын
I am your fan for the way you explain :)
@DataWithBaraa
5 ай бұрын
Ah you like it? Very happy to hear that
@rezanurkabir70
5 ай бұрын
Thank you for another fantastic SQL tutorial! Your explanations are clear and easy to follow. 👌
@khawla092
2 ай бұрын
In the rolling total example, the last example should not be 115 instead of 105
@sakshideshmukh2130
Ай бұрын
absolutely the best advance SQL course out there!
@DataWithBaraa
Ай бұрын
Glad you think so!
@khalidazizi8346
2 ай бұрын
I don't know how to appreciate you. You are the best among all
@FirangizMuslumzada
2 ай бұрын
this course is just superb! you are the teacher of all teachers . cheers, baraa!
@OscarBalwin
4 ай бұрын
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
4 ай бұрын
Hi Oscar, thanks for the amazing feedback! I really appreciate it.
@arnavsharma2485
Ай бұрын
please put videos for pyspark as well and if possible for R also
@srikarreddy8252
Ай бұрын
This is THE BEST video on aggregated window functions!!
@DataWithBaraa
Ай бұрын
Nice ❤️
@norianekrouf7279
2 ай бұрын
Can u have ressources of window part?!
@gopikrishnasistla8896
5 ай бұрын
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
@DataWithBaraa
5 ай бұрын
Use a pc or laptop 😉
@Dennisaj
2 ай бұрын
*"This is the most CRIMINALLY UNDERRATED KZitem channel barn NONE!!!" Brah... Can you imagine if you did an entire 20-40 hour course on Java, C#, Python, or C++?*
@DataWithBaraa
2 ай бұрын
@@Dennisaj thanks! Sadly over 75% of viewer watching continues my content, don’t support the channel by subscribing, liking and commenting. Which leads KZitem 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
2 ай бұрын
Thanks a lot @@DataWithBaraa
@SaadiaZahoor
Ай бұрын
Thnx brother
@DataWithBaraa
Ай бұрын
Welcome
@asrithagudla4865
Ай бұрын
hy hi can i know why are we writing t in sudquery at 42:44
@MuhammadEhtisham-cm5vr
2 ай бұрын
the best content and page i ever found , plz complete the series , you are the best bara !
@DataWithBaraa
2 ай бұрын
@@MuhammadEhtisham-cm5vr thanks 🙏 I’ll do my best ❤️
Пікірлер: 102