Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Udemy Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Register & Get access to index
rt_1757576_8b8d.png



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
Author
ivancekic
Downloads
24
Views
864
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from ivancekic