h264, yuv420p, 1280x720 |ENGLISH, aac, 44100 Hz, 2 channels, s16 | 9h 20 mn | 4.96 GB

Instructor: Khaled Alkhudari

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

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

Description

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 will master Oracle 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

Who this course is for:

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