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

Produced in 2022

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
  • 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
  • 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

*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

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'.



39 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

The Training was good with examples. The Concepts are very clear

Good information, but the course could be much shorter if the instructor didn't read every single line back.

It was really really awesome,funtastic demo,presentation,practice workshop thankyou very much Khalid and Udemy team.Good luckRegardsSarvesh

This is a very good course looking forward to learning new skills and development, and growing in the Oracle field and acquiring more skills and development.

This course is too good. The trainer is the best and his style of explanation is awesome. Being from DBA profile I always avoided SQL development but his lecture made me change my mind. Now I find SQL fun and very easy to use. He must also make a course on Oracle DB Architecture it will be helpful.

Loud instructions, tutor will make you learn .... thats it .... Really good....

Actually I have a lot of reservations about this course. I think it should contain exercises and homework so the stuxdent will actually practice the content. However, I needed this course because I had a job inreview and after I duzzeld them with rollups and pivots I got the job so as far as I am concearn this course certainly served the purpose

Khaled Alkhudari is really an amazing teacher. I need to refresh my knowledge after 7 years I don't work in Oracle and I enjoying with this course. Congrats to Khaled and I'll start another course when finishing it!!

Good course. Met the expectations!!!

Very good for me, interpretation was detailed and understandable. Thank you.

The course covers a lot of advanced concepts explained well with examples. This course is definitely a must take for sql programmers with some experience and who would like to there skills to the next level. One drawback is too much reading line by line making videos unnecessarily longer i had to fast forward lectures because anyone who knows how to read can read the queries written and no need to repeat lectures should be to the point :) Still a very good course. Thank you

I love the course. It is very informative and the Khaled is a very good instructor.