Oracle Analytic Functions In-Depth & Advanced Oracle SQL (Udemy.com)

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

( 117 Reviews )

Created by: Khaled Alkhudari

Produced in 2021

What you will 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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 92 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a sql course? Or looking for more detail on Khaled Alkhudari's Oracle Analytic Functions In-Depth & Advanced Oracle SQL? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course 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 exercisesWho 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

Time: 9.5h

*Some courses are excluded from this sale. Coupon not working? If the link above doesn't drop prices, clear the cookies in your browser and then click this link here.
Also, you may need to apply the coupon code directly on the cart page to get the discount.

Coupon Code

Instructor Details

Khaled Alkhudari

4.6 Rating
117 Reviews

My name is Khaled Al Khudari, I graduatedin 2003 in computer science.
I have more than 12 years'experience in oracle development, I worked many projects with the bestcompanies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others )
I HaveMany Certifications ( OCA, OCP, Oracle ERP certifications and many others )
I have big experience inOracle ERP modules and data migration, and I have experience in Education systemlike Banner, People soft and desire tolearn .
Ibelieve in success through hard work & dedication.
My motto in life is: If you wantsomething, work hard & you will achieve it; there are no short cuts'.

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.6

117 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Jaime Suncin on 12/27/2020

Lack of complementary resources

By Dilip Kumar Panigrahi on 12/20/2020

awesome

By Daniele Grossi on 12/20/2020

Course very interesting.
There are not subtitles but english language of the teacher is very good
and simple

By Ricardo Valdivia on 10/25/2020

bien, explica en detalle el uso de cada funcin involucrada en sql analytics

By Mohammad Aurangzeb Khan on 10/20/2020

A very good and well designed course, The complex concepts have been simplified. We appreciate Native and Non-Native English accent ...

By Abhishek Bhalla on 10/14/2020

very nice

By SenthilNathan on 10/13/2020

Good Information and covered key points in Oracle SQL different functions!

By Inderjeet Singh on 10/12/2020

Good Explanation

By Nika Jincharadze on 10/4/2020

Very nice way of explaining

By kalyan bunny on 10/2/2020

It is so early for me to write a review on how is the content.

By Zackery James Camille on 9/20/2020

Mr Khaled Alkhudari is a great educator and his communication skills are exceptional. Both of these traits make going through and learning this course manageable and rewarding.

By Chetan Agrawal on 9/17/2020