Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Oracle Analytic Functions In-Depth & Advanced Oracle SQL, available at $94.99, has an average rating of 4.45, with 86 lectures, based on 1635 reviews, and has 9196 subscribers.

You will learn about 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 This course is ideal for individuals who are Students who already know Oracle SQL and they need to move to the next level in advance SQL or Fresh and junior Oracle programmers who need to move to data warehouse path or Oracle programmers who need to learn Oracle Analytic Functions In-Depth It is particularly useful for Students who already know Oracle SQL and they need to move to the next level in advance SQL or Fresh and junior Oracle programmers who need to move to data warehouse path or Oracle programmers who need to learn Oracle Analytic Functions In-Depth.

Enroll now: Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Summary

Title: Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Price: $94.99

Average Rating: 4.45

Number of Lectures: 86

Number of Published Lectures: 86

Number of Curriculum Items: 86

Number of Published Curriculum Objects: 86

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Course Preparation

Lecture 1: Chapter Summary

Lecture 2: Oracle 12c /18c Architecture

Lecture 3: Review some Basic commands in 12c / 18c

Lecture 4: Create new pluggable database

Lecture 5: Create the HR Schema

Lecture 6: Navigate the HR Schema

Chapter 2: Grouping and Aggregating Data Using SQL

Lecture 1: Chapter Summary

Lecture 2: Introduction

Lecture 3: Group Functions and Group by part 1

Lecture 4: Group Functions and Group by part 2

Lecture 5: Group Functions and NULLS

Lecture 6: Rollup Part 1

Lecture 7: Rollup Part 2

Lecture 8: Rollup Part 3

Lecture 9: Rollup Part 4

Lecture 10: Cube Part 1

Lecture 11: Cube Part 2

Lecture 12: Cube Part 3

Lecture 13: GROUPING Function Part 1

Lecture 14: GROUPING Function Part 2

Lecture 15: GROUPING Function Part 3

Lecture 16: GROUPING Function Part 4

Lecture 17: The GROUPING_ID function

Lecture 18: GROUPING SETS Part 1

Lecture 19: GROUPING SETS Part 2

Lecture 20: Composite Columns

Lecture 21: Concatenated Groupings

Lecture 22: Solving one task in 4 methods

Chapter 3: Analyzing and Reporting Data Using SQL

Lecture 1: RANK & DENSE_RANK Part 1

Lecture 2: RANK & DENSE_RANK Part 2

Lecture 3: RANK & DENSE_RANK Part 3

Lecture 4: RANK & DENSE_RANK Part 4

Lecture 5: RANK & DENSE_RANK ( Aggregate Syntax )

Lecture 6: PERCENT_RANK Part 1

Lecture 7: PERCENT_RANK Part 2

Lecture 8: PERCENT_RANK Part 3 ( Aggregate Syntax )

Lecture 9: CUME_DIST (cumulative distribution) Part 1

Lecture 10: CUME_DIST (cumulative distribution) Part 2

Lecture 11: LISTAGG function Part 1

Lecture 12: LISTAGG function Part 2

Lecture 13: NTILE function

Lecture 14: ROWNUM & ROW_NUMBER Part 1

Lecture 15: ROWNUM & ROW_NUMBER Part 2

Lecture 16: ROWNUM & ROW_NUMBER Part 3

Lecture 17: LAG & LEAD Functions Part 1

Lecture 18: LAG & LEAD Functions Part 2

Lecture 19: Aggregate functions VS Analytic Part 1 ( Very Important)

Lecture 20: Aggregate functions VS Analytic Part 2 ( Very Important)

Lecture 21: Aggregate functions & windowing clause 1

Lecture 22: Aggregate functions & windowing clause 2

Lecture 23: Aggregate functions & windowing clause 3

Lecture 24: Aggregate functions & windowing clause 4

Lecture 25: Aggregate functions & windowing clause 5

Lecture 26: Aggregate functions & windowing clause 6

Lecture 27: Aggregate functions & windowing clause 7

Lecture 28: Aggregate functions & windowing clause 8

Lecture 29: Aggregate functions & windowing clause 9

Lecture 30: first_value & last_value PART 1

Lecture 31: first_value & last_value PART 2

Lecture 32: first_value & last_value PART 3

Chapter 4: Advanced Oracle SQL

Lecture 1: DBMS_RANDOM part 1

Lecture 2: DBMS_RANDOM part 2

Lecture 3: Using SELECT statement to create dynamic scripts

Lecture 4: Hierarchical Queries Part 1

Lecture 5: Hierarchical Queries Part 2

Lecture 6: Hierarchical Queries Part 3

Lecture 7: Hierarchical Queries Part 4

Lecture 8: Hierarchical Queries Part 5

Lecture 9: DML logs using package dbms_errlog

Lecture 10: create matrix report using PIVOT

Chapter 5: Bonus section- the full installation info

Lecture 1: Course Setup Notes / 4 Options

Lecture 2: Option 2- creating the HR Schema

Lecture 3: Option 3- Part 1 : Oracle Database 12c Architecture

Lecture 4: Option 3- Part 2 : Downloading Oracle DB 12c

Lecture 5: Option 3- Part 3 : Installing Oracle DB 12c

Lecture 6: Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer

Lecture 7: Option 3- Part 5: Unlock HR Account Part 1

Lecture 8: Option 3- Part 6 : Unlock HR Account Part 2

Lecture 9: Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c

Lecture 10: Option 4- Installing Oracle 11g express Edition + Unlock HR

Lecture 11: HR Schema in this Course

Lecture 12: Navigate HR schema

Lecture 13: oracle 18c express edition part 1 (download and install )

Lecture 14: oracle 18c express edition part 2 (unlock hr )

Lecture 15: oracle 18c express edition part 3 ( sql developer )

Lecture 16: about oracle apex

Instructors

Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst

Rating Distribution

1 stars: 11 votes
2 stars: 16 votes
3 stars: 138 votes
4 stars: 571 votes
5 stars: 899 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu