Oracle Database 12c R2 SQL: Reporting Aggregated Data Using Group Functions

Oracle SQL 12c    |    Beginner
  • 12 videos | 1h 6m 35s
  • Includes Assessment
  • Earns a Badge
Discover how to obtain summary information, such as averages, for groups of rows in SQL. Explore how to group rows in a table into smaller sets and how to specify search criteria for groups of rows.

WHAT YOU WILL LEARN

  • Describe how to use group functions to return one result based on a set of rows in a sql statement
    Use the avg and sum functions to group numeric data in a sql statement
    Use the min and max functions to group numeric, character, and date data types in a sql statement
    Use the count and count distinct functions in a sql statement
    Work with null values when grouping a set of rows in a sql statement
    Create groups of data in a sql statement
  • Create groups of data and work with the group by clause in a sql statement
    Use the group by clause on multiple columns in a sql statement
    Demonstrate illegal queries when using the group by function in a sql statement
    Use the having clause to restrict grouped rows returned in a sql statement
    Nest group functions to a depth of two functions in a sql statement
    Write sql statements using group by and having

IN THIS COURSE

  • 4m 2s
    After completing this video, you will be able to describe how to use group functions to return one result based on a set of rows in a SQL statement. FREE ACCESS
  • 3m 32s
    To group numeric data in a SQL statement, use the AVG and SUM functions. FREE ACCESS
  • Locked
    3.  MIN and MAX Functions
    2m 12s
    In this video, you will learn how to use the MIN and MAX functions to group numeric, character, and date data types in a SQL statement. FREE ACCESS
  • Locked
    4.  COUNT and COUNT DISTINCT Functions
    6m 59s
    During this video, you will learn how to use the COUNT and COUNT DISTINCT functions in SQL statements. FREE ACCESS
  • Locked
    5.  Group Functions and NULL Values
    4m 21s
    In this video, you will work with NULL values when grouping a set of rows in a SQL statement. FREE ACCESS
  • Locked
    6.  Creating Groups of Data
    4m 51s
    In this video, learn how to create groups of data in an SQL statement. FREE ACCESS
  • Locked
    7.  GROUP BY Clause
    5m 56s
    Find out how to create groups of data and work with the GROUP BY clause in SQL statements. FREE ACCESS
  • Locked
    8.  GROUP BY on Multiple Columns
    7m 43s
    In this video, you will use the GROUP BY clause on multiple columns in a SQL statement. FREE ACCESS
  • Locked
    9.  Illegal Queries
    6m 41s
    In this video, find out how to apply illegal queries when using the GROUP BY clause in a SQL statement. FREE ACCESS
  • Locked
    10.  Restricting Group Results Using the HAVING Clause
    6m 44s
    During this video, you will learn how to use the HAVING clause to restrict the grouped rows returned in a SQL statement. FREE ACCESS
  • Locked
    11.  Nesting Group Functions
    5m 34s
    In this video, learn how to use nested group functions in a SQL statement to a depth of two functions. FREE ACCESS
  • Locked
    12.  Exercise: Use GROUP BY and HAVING
    8m 1s
    Learn how to write SQL statements using the GROUP BY and HAVING clauses. 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 Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Course Oracle Database 12c R2 SQL: Using the Set Operators
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Aggregating Data
Course Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Course Oracle Database 12c R2 SQL: Creating Other Schema Objects