SQL - Aggregate Functions and Group By Clauses | Jon Avis | Skillshare

SQL - Aggregate Functions and Group By Clauses

Jon Avis, IT Systems Engineer

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.

27

Students

1

Project

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Jon Avis

IT Systems Engineer

My name is Jon. I am from the UK and currently work in Hong Kong as an IT Systems Engineer for an investment bank. I have over four years experience as an IT Systems Engineer. 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

Report class