Using GROUP BY, PIVOT, & UNPIVOT
SQL Server 2016
| Intermediate
- 11 videos | 1h 26m 31s
- Includes Assessment
- Earns a Badge
Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore the GROUP BY clause and how to change a table-valued expression into another table using the PIVOT and UNPIVOT operators.
WHAT YOU WILL LEARN
-
recognize when and where to use the GROUP BY clause
demonstrate how to group and rank the results of a query using the windowing functions in SQL Server 2016
describe how to process queries using the logical order of operations
describe the GROUP BY workflow process
describe how to use GROUP BY with aggregate functions in SQL Server 2016
demonstrate using complex GROUP BY clauses using GROUPING sets -
recognize how to filter groups using the HAVING clause
recognize how to use PIVOT and UNPIVOT relational operators in SQL Server 2016
demonstrate how to use PIVOT in SQL Server 2016
demonstrate how to use UNPIVOT in SQL Server 2016
describe how to determine the impact on NULL values in PIVOT and UNPIVOT queries
IN THIS COURSE
-
1.GROUP BY Overview7m 58sUP NEXT
-
2.Group and Rank Results10m 40s
-
3.Logical Order of Operations5m 31s
-
4.GROUP BY Workflow4m 51s
-
5.GROUP BY Clause and Aggregate Functions12m 47s
-
6.GROUP BY Clauses Using GROUPING Sets10m 3s
-
7.HAVING Clause6m 59s
-
8.Pivot and Unpivot Overview5m 17s
-
9.Using PIVOT7m 17s
-
10.Using UNPIVOT9m 5s
-
11.NULL Values in PIVOT and UNPIVOT Queries6m 4s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
