Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. This course will cover various types of aggregate functions such as SUM, MIN, MAX, AVG, and COUNT, as well as the GROUP BY clause, which is used to arrange your data into subsets before summarizing it. Lastly, this course will demonstrate how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators. This course is one of a series of courses that cover the objectives for 70-761: Querying Data with Transact-SQL exam.
Database administrators, database developers, and BI professionals