Rating 4.61 out of 5 (1014 ratings in Udemy)

• 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