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
Likes 25 Likes 25
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

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.