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 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 16sTopic description characters !"£$%^&*()_+ peter "was" 'here' ¾ ‰ © FREE ACCESS
-
2. AVG and SUM Functions3m 57sTo group numeric data in a SQL statement, use the AVG and SUM functions. FREE ACCESS
-
3. MIN and MAX Functions3m 4sIn this video, you will use the MIN and MAX functions to group numeric, character, and date data types in a SQL statement. FREE ACCESS
-
4. COUNT and COUNT DISTINCT Function3m 37sLearn how to use the COUNT and COUNT DISTINCT functions in SQL statements. FREE ACCESS
-
5. Group Functions and NULL Values3m 11sTo work with NULL values when grouping a set of rows in a SQL statement, use the GROUP BY clause. FREE ACCESS
-
6. Creating Groups of Data2m 26sLearn how to create groups of data in an SQL statement. FREE ACCESS
-
7. GROUP BY Clause3m 52sAfter 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
-
8. GROUP BY on Multiple Columns4m 52sIn this video, find out how to use the GROUP BY clause on multiple columns in a SQL statement. FREE ACCESS
-
9. ILLEGAL GROUP Function4m 23sAfter completing this video, you will be able to describe illegal queries when using the GROUP BY function in a SQL statement. FREE ACCESS
-
10. Restricting Group Results using the HAVING clause4m 32sFind out how to use the HAVING clause to restrict the rows that are returned in a SQL statement when using grouping. FREE ACCESS
-
11. Nesting Group Functions4m 42sDuring this video, you will learn how to use nesting of group functions to a depth of two functions in an SQL statement. FREE ACCESS
-
12. Exercise: Use the Group By and Having Functions3m 37sIn 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.
