Aggregating Data
Oracle 12c
12 Videos | 47m 29s - Earns a Badge
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
-
1.Group Functions3m 16s
-
2.AVG and SUM Functions3m 57s
-
3.MIN and MAX Functions3m 4s
-
4.COUNT and COUNT DISTINCT Function3m 37s
-
5.Group Functions and NULL Values3m 11s
-
6.Creating Groups of Data2m 26s
-
7.GROUP BY Clause3m 52s
-
8.GROUP BY on Multiple Columns4m 52s
-
9.ILLEGAL GROUP Function4m 23s
-
10.Restricting Group Results using the HAVING clause4m 32s
-
11.Nesting Group Functions4m 42s
-
12.Exercise: Use the Group By and Having Functions3m 37s
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.
