Using GROUP BY, PIVOT, & UNPIVOT

SQL Server 2016    |    Intermediate
  • 11 Videos | 1h 26m 31s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 61 Likes 61  
COURSE Triggers
Likes 32 Likes 32  
Likes 34 Likes 34