Aggregating Data

Oracle 12c    |    Beginner
  • 12 videos | 45m 29s
  • Earns a Badge
Rating 4.7 of 152 users Rating 4.7 of 152 users (152)
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

  • Locked
    1.  Group Functions
    3m 16s
    Topic description characters !"£$%^&*()_+ peter "was" 'here' ¾ ‰ © FREE ACCESS
  • Locked
    2.  AVG and SUM Functions
    3m 57s
    To group numeric data in a SQL statement, use the AVG and SUM functions. FREE ACCESS
  • Locked
    3.  MIN and MAX Functions
    3m 4s
    In this video, you will 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 Function
    3m 37s
    Learn how to use the COUNT and COUNT DISTINCT functions in SQL statements. FREE ACCESS
  • Locked
    5.  Group Functions and NULL Values
    3m 11s
    To work with NULL values when grouping a set of rows in a SQL statement, use the GROUP BY clause. FREE ACCESS
  • Locked
    6.  Creating Groups of Data
    2m 26s
    Learn how to create groups of data in an SQL statement. FREE ACCESS
  • Locked
    7.  GROUP BY Clause
    3m 52s
    After completing this video, you will be able to describe how to create groups of data and work with the GROUP BY clause in a SQL statement. FREE ACCESS
  • Locked
    8.  GROUP BY on Multiple Columns
    4m 52s
    In this video, find out how to use the GROUP BY clause on multiple columns in a SQL statement. FREE ACCESS
  • Locked
    9.  ILLEGAL GROUP Function
    4m 23s
    After completing this video, you will be able to describe illegal queries when using the GROUP BY function in a SQL statement. FREE ACCESS
  • Locked
    10.  Restricting Group Results using the HAVING clause
    4m 32s
    Find out how to use the HAVING clause to restrict the rows that are returned in a SQL statement when using grouping. FREE ACCESS
  • Locked
    11.  Nesting Group Functions
    4m 42s
    During this video, you will learn how to use nesting of group functions to a depth of two functions in an SQL statement. FREE ACCESS
  • Locked
    12.  Exercise: Use the Group By and Having Functions
    3m 37s
    In this video, you will 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

Channel Oracle Database 12c Administrator Certified Professional
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)
Journey How to Transform Tables with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Subqueries
Rating 4.7 of 179 users Rating 4.7 of 179 users (179)
Course Databases, Rules, & Procedures
Rating 4.3 of 146 users Rating 4.3 of 146 users (146)
Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)