Using GROUP BY, PIVOT, & UNPIVOT

SQL Server 2016
  • 11 Videos | 1h 32m 1s
  • Includes Assessment
  • Earns a Badge
Likes 20 Likes 20
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

  • Playable
    1. 
    GROUP BY Overview
    7m 58s
    UP NEXT
  • Playable
    2. 
    Group and Rank Results
    10m 40s
  • Locked
    3. 
    Logical Order of Operations
    5m 31s
  • Locked
    4. 
    GROUP BY Workflow
    4m 51s
  • Locked
    5. 
    GROUP BY Clause and Aggregate Functions
    12m 47s
  • Locked
    6. 
    GROUP BY Clauses Using GROUPING Sets
    10m 3s
  • Locked
    7. 
    HAVING Clause
    6m 59s
  • Locked
    8. 
    Pivot and Unpivot Overview
    5m 17s
  • Locked
    9. 
    Using PIVOT
    7m 17s
  • Locked
    10. 
    Using UNPIVOT
    9m 5s
  • Locked
    11. 
    NULL Values in PIVOT and UNPIVOT Queries
    6m 4s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 39 Likes 39  
COURSE Functions
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 22 Likes 22  
Likes 23 Likes 23