Video Training / IT and Programming for PC Tutorials →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.
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.
Homepage
https://app.pluralsight.com/library/courses/t-sql-group-aggregate-data/table-of-contents