Oracle Analytic Functions In-Depth & Advanced Oracle SQL

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

Created by: Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst

What Will I 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

Requirements

• Familiarity with SQL
• Good working knowledge of the SQL language
• Familiarity with Oracle SQL Developer and SQL*Plus
• This course is not for beginners, do not take this course if you have no experience in SQL
• Downloading oracle database and this will be covered in details on Windows OS.

Target audience

• Students who already know Oracle SQL and they need to move to the next level in advance SQL
• Fresh and junior Oracle programmers who need to move to data warehouse path
• Oracle programmers who need to learn Oracle Analytic Functions In-Depth