Oracle Analytic Functions In-Depth & Advanced Oracle SQL
4.6 (406 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,149 students enrolled

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
Bestseller
4.6 (406 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3,145 students enrolled
Created by Khaled Alkhudari
Last updated 1/2020
English
Current price: $119.99 Original price: $199.99 Discount: 40% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 49 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 85 lectures 09:20:37
+ Course Preparation
6 lectures 29:04

Very Important

Preview 02:04
Create new pluggable database
04:00
Create the HR Schema
07:24
Navigate the HR Schema
04:25
+ Grouping and Aggregating Data Using SQL
22 lectures 02:13:37
Chapter Summary
01:01
Introduction
02:46
Group Functions and Group by part 2
06:39
Group Functions and NULLS
03:16
Rollup Part 2
07:50
Rollup Part 3
06:22
Rollup Part 4
09:01
Cube Part 1
03:55
Cube Part 2
07:21
Cube Part 3
05:14
GROUPING Function Part 1
07:38
GROUPING Function Part 2
04:49
GROUPING Function Part 3
07:19
GROUPING Function Part 4
04:43
The GROUPING_ID function
07:31
GROUPING SETS Part 1
09:32
GROUPING SETS Part 2
03:29
Composite Columns
06:18
Concatenated Groupings
04:23
Solving one task in 4 methods
06:22
+ Analyzing and Reporting Data Using SQL
32 lectures 03:41:26
RANK & DENSE_RANK Part 1
12:25
RANK & DENSE_RANK Part 2
04:22
RANK & DENSE_RANK Part 3
08:49
RANK & DENSE_RANK Part 4
05:40
RANK & DENSE_RANK ( Aggregate Syntax )
07:27
PERCENT_RANK Part 1
08:00
PERCENT_RANK Part 2
05:01
PERCENT_RANK Part 3 ( Aggregate Syntax )
10:05
CUME_DIST (cumulative distribution) Part 1
08:34
CUME_DIST (cumulative distribution) Part 2
05:06
LISTAGG function Part 1
04:55
LISTAGG function Part 2
07:11
NTILE function
06:07
ROWNUM & ROW_NUMBER Part 1
06:27
ROWNUM & ROW_NUMBER Part 2
04:13
ROWNUM & ROW_NUMBER Part 3
07:30
LAG & LEAD Functions Part 1
06:44
LAG & LEAD Functions Part 2
08:27
Aggregate functions VS Analytic Part 1 ( Very Important)
07:16
Aggregate functions VS Analytic Part 2 ( Very Important)
11:01
Aggregate functions & windowing clause 1
08:55
Aggregate functions & windowing clause 2
07:11
Aggregate functions & windowing clause 3
07:18
Aggregate functions & windowing clause 4
09:45
Aggregate functions & windowing clause 5
08:34
Aggregate functions & windowing clause 6
03:06
Aggregate functions & windowing clause 7
05:23
Aggregate functions & windowing clause 8
05:04
Aggregate functions & windowing clause 9
06:43
first_value & last_value PART 1
06:43
first_value & last_value PART 2
03:29
first_value & last_value PART 3
03:55
+ Advanced Oracle SQL
10 lectures 01:06:36
DBMS_RANDOM part 1
06:08
DBMS_RANDOM part 2
05:09
Using SELECT statement to create dynamic scripts
06:34
Hierarchical Queries Part 1
03:45
Hierarchical Queries Part 2
06:50
Hierarchical Queries Part 3
07:35
Hierarchical Queries Part 4
08:46
Hierarchical Queries Part 5
07:15
DML logs using package dbms_errlog
08:28
create matrix report using PIVOT
06:06
+ Bonus section- the full installation info
15 lectures 01:49:54
Course Setup Notes / 4 Options
04:32
Option 2- creating the HR Schema
07:34
Option 3- Part 1 : Oracle Database 12c Architecture
05:02
Option 3- Part 2 : Downloading Oracle DB 12c
03:42
Option 3- Part 3 : Installing Oracle DB 12c
09:16
Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
10:39
Option 3- Part 5: Unlock HR Account Part 1
04:30
Option 3- Part 6 : Unlock HR Account Part 2
11:49
Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
03:33
Option 4- Installing Oracle 11g express Edition + Unlock HR
10:21
HR Schema in this Course
04:34
Navigate HR schema
07:05

...

oracle 18c express edition part 1 (download and install )
08:59

...

oracle 18c express edition part 2 (unlock hr )
11:32

...

oracle 18c express edition part 3 ( sql developer )
06:46
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.
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

Who 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