Disclosure: when you buy through links on our site, we may earn an affiliate commission.

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
4.6
4.6/5
(939 reviews)
6,286 students
Created by

8.7

CourseMarks Score®

7.2

Freshness

9.1

Feedback

9.2

Content

Platform: Udemy
Video: 9h 20m
Language: English
Next start: On Demand

Table of contents

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

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

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
• Downloading oracle database and this will be covered in details on Windows OS.

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
Sr Oracle Developer/ Sr system analyst
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 9h 20m
Language: English
Next start: On Demand

Students are also interested in