Programming Microsoft Sql Server 2022 Aggregate Functions
 

This video, the first of a four part series, explains a category of data analysis functions that are provided by Microsoft SQL Server 2022 (and earlier) called aggregate functions. The student will learn what each function does, how to create a complex query using the function and how to use the data results in a Microsoft Excel spreadsheet to create graphs and reports for further analysis.
This video concentrates on the aggregate window functions. It is a follow up to the author's Apress book, The SQL Server BI Toolkit, and can be used with the book or stand alone to achieve the learning goals. The objective of each section is to introduce the SQL Server window function, learn how to use it in a query using SQL Server Management Studio and generate results that can be copied to a Microsoft Excel spreadsheet for further analysis.
The ideal viewer is a student that has basic database and SQL knowledge and wants to take their skills to the next level.
Screenshot