- 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.
Intermediate
- 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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Group and Aggregate Data with T-SQL
Intermediate
Table of contents
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.