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

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Loading & Transforming Data in Power BI
Rating 4.7 of 830 users Rating 4.7 of 830 users (830)
Course AWS Associate Solutions Architect 2020: AWS Review Course 2
Rating 4.8 of 95 users Rating 4.8 of 95 users (95)
Course Selenium Deep Dive: Component Testing with Selenium Framework
Rating 4.4 of 165 users Rating 4.4 of 165 users (165)