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.

YOU MIGHT ALSO LIKE

COURSE Finding and grouping data in Excel 365
CHANNEL Wintellect SAP Crystal Reports
COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 165 Likes 165  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
Likes 50 Likes 50  
COURSE Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Likes 47 Likes 47  
COURSE Oracle Database 12c R2 SQL: Managing Schema Objects
Likes 31 Likes 31