How to Query an Oracle Data Warehouse with Advanced Aggregations (LISTAGG, FIRST, LAST, ROLLUP, Cube and more).
The original SQL language focused on providing standard selection, projection, and sorting of data. Enhancements over the years allow SQL to deliver much more robust analysis of data. This webinar investigates how LISTAGG, FIRST, LAST, Rollup, Cube, Grouping Functions, and Grouping Sets provide these capabilities, typically used in Data Warehouse environments.
After a brief review, we will show how these features allow you to concatenate values of a measure column into a single output column for a GROUP, add subtotals and grand totals to a report of summary data, extend the generation of subtotals across multiple dimensions, provide meaningful labels for subtotals and grand total rows, and limit subtotals to only those that you need for your reporting. These features are particularly useful to generate reports (from a data warehouse) tailored to specific user needs without having to use inefficient workarounds.
Audience: Oracle and APEX developers who want to improve their SQL skills. A basic foundation in SQL is required.
- Lectures 7
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 21
- Certificate No
- Assessments Yes