Live Webcast Abstract
The session introduces SQL aggregate functions in the Microsoft SQL Database Engine, which are essential for analyzing data and uncovering insights. These functions perform a calculation on a set of values and return a single value. Webinar participants will learn how to:
- Understand the role of aggregate functions in data analysis,
- Use COUNT to count all rows or distinct values in a column,
- Use SUM to calculate the total of values in a numeric column,
- Use AVG to compute the average of numeric values in a column,
- Use MIN and MAX to find the lowest and highest values in a column,
- Leverage aggregate functions for statistical data overview, and
- Combine multiple functions in complex SQL statements.
The session emphasizes critical concepts including NULL behavior in aggregates (COUNT(*) vs COUNT(column)), handling division by zero with NULLIF, avoiding integer division pitfalls, using DISTINCT appropriately for performance, and practical patterns for year-over-year comparisons, percentage of total calculations, and combining multiple aggregates for comprehensive data analysis with real-world examples from AdventureWorks sales and product data.
Date
Wednesday, June 17, 2026
1:00 PM EDT (New York) | 5:00 PM UTC
Instructor
Hristo Hristov is a seasoned data professional with experience spanning the intersection of data engineering and smart manufacturing solutions. Since 2017, he specializes in implementing advanced analytics solutions for bridging the IT/OT gap.
A technical writer with over fifty published articles on data and AI technologies, Python development, and cloud solutions. Passionate about transforming complex data into business value through innovative applications of Azure Data Platform, Python, IoT solutions, databases, and other cloud technologies.
Currently applying Industry 4.0 best practices, focusing on IoT connectivity, and implementing data and AI systems in manufacturing. Hristo holds a degree in Data Science and several Microsoft certifications covering SQL, Power BI, and related technologies.
For 20+ years, MSSQLTips.com has been delivering comprehensive technical solutions on a daily basis for the Microsoft SQL Server platform. In that time, an innovative team of over 300 authors from around the globe have delivered over 7000 articles and 1000 webcasts ranging from beginner topics to advanced solutions. Our community prides itself on delivering human only generated content.
