Skip to content
Write a review
UdemySQLPaid courseExpert levelCertificate

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

4.3
1,994 reviews

Created by: Khaled Alkhudari

Last updated May 2024

icon
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

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.3 out of 5higher than 22% of them
  • Reviews1,994#99 of 389 by number of reviews
  • Length9.4 hourslonger than 68% of them
  • Last updatedMay 2024more recently than 53% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

icon
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 exercises
Expert Expert Level product length iconTime: 9.4h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Khaled Alkhudari

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft  and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.



icon
More courses by Khaled Alkhudari

$19.99

$11.99

$99.99

All courses by Khaled Alkhudari

icon
Reviews

4.3

1,994 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Yasmeen AL-Ward on 6/19/2026

Khaled is one of the best SQL and PL/SQL instructors. He explains concepts in a clear, structured, and easy-to-follow way, making complex topics easy to understand. The course is practical, engaging, and well organized. Thank you, Khaled, for this excellent course. Highly recommended!

By Gregory Knox on 6/4/2026

accent very hard to hear

By Prakash Chakravarthy Gope on 8/22/2021

Awesome Explanation. Few days back, I tried to learn the concept from ORACLE website and nothing clear. But I understood the concept completely and Its wonderful explation. Thanks a lot for your efforts to make our task easy.. 61_DBMS_RANDOM Part-1 is not playing. Please upload again

By Dániel Kovács on 3/19/2021

Lectures, without hands-on ("to do by yourself") exercises. Good summary of topics, good explanations, good pointers for further reading.

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

Showing 12 of 118 reviews

Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Visit course on Udemy Write a review
  • Video Duration: icon 9.4h
  • Price: $13.99
  • Provider: icon Udemy
  • Updated: icon May 2024
  • Level: Expert Expert
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com