ivancekic submitted a new resource:
Oracle Analytic Functions In-Depth & Advanced Oracle SQL - Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL
Read more about this resource...
Oracle Analytic Functions In-Depth & Advanced Oracle SQL - Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL
View attachment 155
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 &...
Read more about this resource...