- Course
Group and Aggregate Data with T-SQL
Boost your SQL skills by learning how to organize and summarize data. This course explores grouping along with aggregate and window functions to help you uncover patterns and trends.
What you'll learn
SQL is one of the most popular languages to learn for anyone working with data. In this course, Group and Aggregate Data with T-SQL, you’ll learn how to shape raw data into a story your stakeholders can follow. First, you’ll explore aggregate functions like SUM, MAX, AVG, and GROUP BY. Next, you’ll discover how to filter grouped data with the HAVING clause. Then, you'll see the difference between HAVING and WHERE. Finally, you’ll learn how to apply window functions to level up your analysis and uncover hidden insights. When you’re finished with this course, you’ll have the skills and knowledge to group, summarize, and analyze data effectively using T-SQL.
Table of contents
About the author
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.