Using GROUP BY, PIVOT, & UNPIVOT

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 26m 31s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
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

  • 7m 58s
    Upon completion of this video, you will be able to recognize when and where to use the GROUP BY clause. FREE ACCESS
  • 10m 40s
    In this video, you will learn how to group and rank the results of a query using the windowing functions in SQL Server 2016. FREE ACCESS
  • Locked
    3.  Logical Order of Operations
    5m 31s
    After completing this video, you will be able to describe how to process queries using the standard order of operations. FREE ACCESS
  • Locked
    4.  GROUP BY Workflow
    4m 51s
    Upon completion of this video, you will be able to describe the workflow process for GROUP BY. FREE ACCESS
  • Locked
    5.  GROUP BY Clause and Aggregate Functions
    12m 47s
    Upon completion of this video, you will be able to describe how to use GROUP BY with aggregate functions in SQL Server 2016. FREE ACCESS
  • Locked
    6.  GROUP BY Clauses Using GROUPING Sets
    10m 3s
    In this video, you will learn about using complex GROUP BY clauses using GROUPING SETS. FREE ACCESS
  • Locked
    7.  HAVING Clause
    6m 59s
    After completing this video, you will be able to recognize how to filter groups using the HAVING clause. FREE ACCESS
  • Locked
    8.  Pivot and Unpivot Overview
    5m 17s
    After completing this video, you will be able to recognize how to use the PIVOT and UNPIVOT relational operators in SQL Server 2016. FREE ACCESS
  • Locked
    9.  Using PIVOT
    7m 17s
    In this video, you will learn how to use PIVOT in SQL Server 2016. FREE ACCESS
  • Locked
    10.  Using UNPIVOT
    9m 5s
    In this video, you will learn how to use UNPIVOT in SQL Server 2016. FREE ACCESS
  • Locked
    11.  NULL Values in PIVOT and UNPIVOT Queries
    6m 4s
    Upon completion of this video, you will be able to describe how to determine the impact of NULL values on PIVOT and UNPIVOT queries. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Course Querying & Manipulating Data
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)
Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Analyzing Query Plans
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
Course SQL Platform & Installation Best Practices
Rating 4.5 of 50 users Rating 4.5 of 50 users (50)
Course Querying & Manipulating Data
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)