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

( 39 Reviews )

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
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
39 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)

0.0 (0 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

39 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Murali Krishna Koduri on

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

By Gerald Amoakuh on

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

By Sarvesh Kumar Chaurasiya on

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

By Thandokazi Rozani on

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.

By Shubham Khamitkar on

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.

By Damo Achaiyan on

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

By Ido Sokolovsky on

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

By Carlos Andiazabal on

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

By Lenin Kannaiyan on

Good course. Met the expectations!!!

By Josef Lechner on

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

By Ahsan Parvez on

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

By Surabhi Agarwal on