Skip to content

PRO TIP Block youtube.com at the DNS level β€” Pi-hole, NextDNS or your hosts file β€” but allow youtube-nocookie.com and i.ytimg.com. These tutorials keep playing; the rabbit hole does not.

Learning without distractions

SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course 23

107.6K views on YouTube

Visually explained how SQL aggregate window functions like COUNT, AVG, SUM, MAX, and MIN work over data partitions.

Want More? πŸ‘‡
– *Free Download Materials* https://www.datawithbaraa.com/wiki/sql#sql-welcome
– *Free SQL Course* https://youtu.be/SSKVgrwhzus
– *Full Package* (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/sql-full-course-for-beginners
– *Subscribe* for more Free Data content: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1

*πŸ† DATA ACADEMY*
– *SQL* https://www.datawithbaraa.com/course/sql-full-course-for-beginners
– *Python* https://www.datawithbaraa.com/course/the-ultimate-python-mastery
– *Python Handbook* (sketches, notes, code) https://academy.datawithbaraa.com/l/digital_download/998313/the-python-handbook
– *Tableau* https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners

*πŸŽ“UDEMY*
– *SQL* https://www.udemy.com/course/the-complete-sql-bootcamp-30-hours-go-from-zero-to-hero/?referralCode=D20781228C2EB8B98339
– *Python* https://www.udemy.com/course/the-complete-python-bootcamp-13hours-go-from-zero-to-hero/?referralCode=776491A4119FF8AF41CA
– *Tableau* https://www.udemy.com/course/the-tableau-ultimate-course-from-zero-to-hero/?referralCode=6544726FDC491A6B25EC

━━━━━

*CONNECT WITH ME*
πŸ“¬ Newsletter https://www.blog.datawithbaraa.com
πŸ‘¨β€πŸ’» LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/
πŸ“Έ Instagram https://www.instagram.com/datawithbaraa/
πŸŽ₯ TikTok https://www.tiktok.com/@datawithbaraa
🌍 Website https://datawithbaraa.com/
πŸ’¬ Discord https://discord.gg/gsVJbMxKcA
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link
πŸ“© Sponsorships baraa@datawithbaraa.com

━━━━━
*Get 25%* OFF DataCamp’s Here https://datacamp.pxf.io/bOEe66
━━━━━

*MY FREE COURSES*
– *SQL* https://youtu.be/SSKVgrwhzus
– *Python* https://youtu.be/Rq5gJVxz55Q
– *Tableau* https://youtu.be/UcGF09Awm4Y
– *Databricks* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZoxVkw-KPhcmgLWjHWVUc9
– *Power BI* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZge4KDGqGtqgiuVuhVZWzu
– *Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7
– *Data Careers* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd

━━━━━

πŸ“– *Table of Content*
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

This course is perfect for data analysts, data engineers, data scientists, software developers, and studentsβ€”covering everything from the basics to advanced SQL topics.
#sql #sqlserver #data #analytics #dataanalysis #datascience