Running & Rolling Total | Moving & Rolling Average | SQL Key Data Analysis Concepts
Ғылым және технология
In this video, you'll understand SQL Running Total, Rolling Total, Moving Average, and Rolling Average. They are essential SQL concepts for data analysis and reporting. They enable us to track current trends and historical patterns, essential for insightful business decisions.
These use cases highlight the importance of aggregate window functions in SQL for performing advanced data analytics.
🔔 If you enjoyed this video and found it helpful, please support the channel by Subscribing, liking and commenting. bit.ly/3GiCVUE
--------------------------------------------------
⏬ FREE DOWNLOAD LINKS ⏬
--------------------------------------------------
Access all course materials: bit.ly/advancedsqlcourse
You can find list to all courses & materials in my substack page datawithbaraa.substack.com/su...
----------------------------------------------------
🎓 Free Courses On KZread 🎓
-----------------------------------------------------
✅ Tableau Course
• Tableau Ultimate Full ...
✅ SQL Course - Basic concepts
• SQL Tutorial for Begin...
✅ AI Chat GPT Course
• ChatGPT Tutorial for B...
---------------------------------
☕ FOLLOW ME ☕
---------------------------------
Baraa Khatib Salkini
Website: www.datawithbaraa.com
Channel: bit.ly/3GiCVUE
LinkedIn: / baraa-khatib-salkini-8...
Email: baraa@datawithbaraa.com
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 intro
01:19 SQL Running Total & Rolling Total
09:30 SQL Moving Average
13:43 SQL Rolling Average
16:41 Summary
Thank you for watching! Remember to like, share, and subscribe for more high quality content on data. Stay curious, stay connected!
#SQL #DataAnalytics #SQLCourse #AdvancedSQL #Data #Analytics #Database #DataScience #Programming #Tech #Technology #Coding #DataAnalysis #SQLServer #BigData #DataManagement #Query #MasteringSQL #SQLTutorial #DataEngineering #bigdata #businessintelligence #datawithbaraa
Пікірлер: 21
If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE ⏱ TIMESTAMPS ⏱ --------------------------------- 00:00 intro 01:19 SQL Running Total & Rolling Total 09:30 SQL Moving Average 13:43 SQL Rolling Average 16:41 Summary Enjoy ☕
Your content is truly impressive, my friend. You've really hit the mark!
@DataWithBaraa
2 ай бұрын
Great 👍 thanks for leaving this nice feedback
You are a god sent. Such an excellent teacher. A new subscriber here. God bless you.
@DataWithBaraa
Ай бұрын
I am really happy that my content reached you! Thanks for the kind words, and may God bless you too ❤
Ending my day with a smile :) Great day! Great learning! Waiting for more videos..
@DataWithBaraa
2 ай бұрын
I'm really glad that you liked my content, i will make sure to keep publish new videos!
That was the best explanation and demonstration of window functions that I've seen, thanks a ton!
@DataWithBaraa
2 ай бұрын
Oh thanks for the kind words!
Thank you so much for the best explanations of the Window Functions! Love from Dallas, Texas !!
@DataWithBaraa
2 ай бұрын
I love Texas !!! You are very welcome and love back from Stuttgart !!
Thanks alot Baraa Master 🙏🙏🙏 always waiting for new videos from you.. ❤❤
@DataWithBaraa
2 ай бұрын
Thanks i will keep pushing on new contents.
Great Explanation Again Baraa!
@DataWithBaraa
2 ай бұрын
Thanks again!
Great content Bara. Presented in a great way! wondering - what sketch program do you use? is it powerpoint?
@DataWithBaraa
2 ай бұрын
Thanks for nice words, i use here Procreate, drawio and powerpoint
hi barra i need video for window function like first_value,last_vale,cume_dist,ntile,nth_value,etccc........
@DataWithBaraa
2 ай бұрын
On the way :)
Baraa when you are going to uppload next video it been 12 days.I have a request plz provide dataset ,and also some additional questins for pracice.
Mr. Bara The spoon feeder of data