Using Aggregate Functions

SQL Server 2016    |    Intermediate
  • 9 videos | 43m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 46 users Rating 4.7 of 46 users (46)
Aggregate functions in SQL Server 2016 are used to summarize data in multiple rows. Explore various types of aggregate functions such as SUM, MIN, MAX, AVG, and COUNT.

WHAT YOU WILL LEARN

  • Recognize the aggregate functions available using transact-sql
    Describe the built-in aggregate function sum in sql server 2016
    Describe the built-in aggregate function avg in sql server 2016
    List the built-in aggregate function in min server 2016
    List the built-in aggregate function max in sql server 2016
  • List the built-in aggregate function count in sql server 2016
    Describe how to aggregate distinct values using distinct
    Demonstrate how to use aggregate functions with null
    Use aggregate functions in sql server 2016

IN THIS COURSE

  • 3m 51s
    Upon completion of this video, you will be able to recognize the aggregate functions available using Transact-SQL. FREE ACCESS
  • 2m 12s
    After completing this video, you will be able to describe the built-in aggregate function SUM in SQL Server 2016. FREE ACCESS
  • Locked
    3.  AVG Aggregate Function
    1m 45s
    Upon completion of this video, you will be able to describe the built-in aggregate function AVG in SQL Server 2016. FREE ACCESS
  • Locked
    4.  MIN Aggregate Function
    2m 14s
    After completing this video, you will be able to list the built-in aggregate functions in MIN Server 2016. FREE ACCESS
  • Locked
    5.  MAX Aggregate Function
    1m 27s
    Upon completion of this video, you will be able to list the built-in aggregate function MAX in SQL Server 2016. FREE ACCESS
  • Locked
    6.  COUNT Aggregate Function
    3m 43s
    Upon completion of this video, you will be able to list the built-in aggregate function COUNT in SQL Server 2016. FREE ACCESS
  • Locked
    7.  Aggregating Distinct Values
    11m 49s
    After completing this video, you will be able to describe how to aggregate distinct values using the DISTINCT keyword. FREE ACCESS
  • Locked
    8.  NULL and Aggregate Functions
    11m 9s
    In this video, you will learn how to use aggregate functions with null values. FREE ACCESS
  • Locked
    9.  Exercise: Using Aggregate Functions in SQL
    5m 7s
    In this video, you will learn how to use aggregate functions in SQL Server 2016. 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

Channel MIT xPRO Data Science & Big Data Analytics
Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
Journey Analyze Data with SQL
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Windows Server 2016 Networking: IPv4 & IPv6 Address Management
Rating 4.7 of 80 users Rating 4.7 of 80 users (80)
Course Using GROUP BY, PIVOT, & UNPIVOT
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)