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

Oracle SQL 12c    |    Beginner
  • 12 Videos | 1h 12m 5s
  • 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE