Using Aggregate Functions

SQL Server 2016
  • 9 Videos | 47m 16s
  • Includes Assessment
  • Earns a Badge
Likes 21 Likes 21
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

  • Playable
    1. 
    Aggregate Functions Overview
    3m 51s
    UP NEXT
  • Playable
    2. 
    SUM Aggregate Function
    2m 12s
  • Locked
    3. 
    AVG Aggregate Function
    1m 45s
  • Locked
    4. 
    MIN Aggregate Function
    2m 14s
  • Locked
    5. 
    MAX Aggregate Function
    1m 27s
  • Locked
    6. 
    COUNT Aggregate Function
    3m 43s
  • Locked
    7. 
    Aggregating Distinct Values
    11m 49s
  • Locked
    8. 
    NULL and Aggregate Functions
    11m 9s
  • Locked
    9. 
    Exercise: Using Aggregate Functions in SQL
    5m 7s

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 31 Likes 31  
Likes 39 Likes 39  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 24 Likes 24  
Likes 32 Likes 32  
Likes 34 Likes 34