What you'll learn
- Use SQL with aggregation operators.
- SQL for Analysis and Reporting functions
- Group and aggregate data using the ROLLUP and CUBE operators
- The GROUPING function
- Composite Columns and the concatenated Groupings
- RANK & DENSE_RANK
- PERCENT_RANK
- CUME_DIST (cumulative distribution)
- The LAG/LEAD Functions
- LISTAGG function
- Aggregate functions VS Analytic Part
- Aggregate functions & windowing clause In-Depth
- Moving Average and running totals
- ROWNUM & ROW_NUMBER
- Advanced Oracle SQL
- And much more