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
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 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
-
create groups of data and work with the GROUP BY clause in a SQL statementuse the GROUP BY clause on multiple columns in a SQL statementdemonstrate illegal queries when using the GROUP BY function in a SQL statementuse the HAVING clause to restrict grouped rows returned in a SQL statementnest group functions to a depth of two functions in a SQL statementwrite SQL statements using GROUP BY and HAVING
IN THIS COURSE
-
1.Group Functions4m 2s
-
2.AVG and SUM Functions3m 32s
-
3.MIN and MAX Functions2m 12s
-
4.COUNT and COUNT DISTINCT Functions6m 59s
-
5.Group Functions and NULL Values4m 21s
-
6.Creating Groups of Data4m 51s
-
7.GROUP BY Clause5m 56s
-
8.GROUP BY on Multiple Columns7m 43s
-
9.Illegal Queries6m 41s
-
10.Restricting Group Results Using the HAVING Clause6m 44s
-
11.Nesting Group Functions5m 34s
-
12.Exercise: Use GROUP BY and HAVING8m 1s
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.