Aggregating Data
Oracle 12c
| Beginner
- 12 Videos | 45m 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 statementuse the AVG and SUM functions to group numeric data in a SQL statementuse the MIN and MAX functions to group numeric, character, and date data types in a SQL statementuse the COUNT and COUNT DISTINCT functions in a SQL statementwork with NULL values when grouping a set of rows in a SQL statementcreate groups of data in a SQL statement
-
describe how to create groups of data and work with the GROUP BY clause in a SQL statementuse with the GROUP BY clause on multiple columns in a SQL statementdescribe illegal queries when using the GROUP BY function in a SQL statementuse the HAVING clause to restrict grouped rows returned in a SQL statementuse nesting of group functions to a depth of two functions in a SQL statementwrite 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.