Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Oracle Analytic Functions In-Depth & Advanced Oracle SQL

via Udemy

Overview

Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached

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

This course is very important for all oracle database programmers especially for programmer who need to move to data warehouse path.

In this course you will learn many advance SQL and you willmasterOracle Analytic Functions In-Depth.

This course will make you expert in Reporting and SQL Analytic Functions.

This course is one of the most amazing courses in Oracle SQL.

Be sure that you will learn a unique knowledge in this subject.

The course is 100% practical and full of examples of exercises

Taught by

Khaled Alkhudari

Reviews

4.6 rating at Udemy based on 1216 ratings

Start your review of Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.