Aggregating Data

Oracle 12c    |    Beginner
  • 12 Videos | 47m 29s
  • Earns a Badge
Likes 45 Likes 45
Grouping data according to specific conditions allows you to create more effective reports and analyze data in more productive ways. Explore group functions, grouping data, and the clauses used for grouping in Oracle Database 12c.

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
  • describe how to create groups of data and work with the GROUP BY clause in a SQL statement
    use with the GROUP BY clause on multiple columns in a SQL statement
    describe 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
    use nesting of group functions to a depth of two functions in a SQL statement
    write SQL statements using the GROUP BY and HAVING functions

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

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
Likes 37 Likes 37