SQL - Aggregate Functions and Group By Clauses

Jon Avis, Application Support Analyst

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (30m)
    • COUNT

      4:04
    • MIN AND MAX

      3:35
    • SUM

      3:59
    • AVERAGE

      3:03
    • GROUP BY

      11:42
    • HAVING

      3:44

About This Class

In this class you will learn how to use Aggregate Functions and Group data in SQL. By the end of this class you will be able to:

  • Use the COUNT, MIN, MAX, SUM and AVG aggregate functions.
  • Group data using the GROUP BY clause.
  • Understand and use the HAVING clause.

3

Students

1

Project

0

Reviews (0)

Jon Avis

Application Support Analyst

My name is Jon. I am from the UK and currently work in Hong Kong as an application support analyst for an investment bank. I have over three years experience as a support analyst. This has allowed me to become an expert on SQL and Unix systems.

In my spare time I enjoy hiking, cycling, photography and traveling.

See full profile