IIRF Online > Office Productivity > Oracle > Oracle Database > Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Oracle Analytic Functions In-Depth & Advanced Oracle SQL by Udemy
Move your skills in SQL to another level by using Oracle Analytic functions + Advanced SQL, All the scripts are attached
Course Highlights
- 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
Skills you will learn!
Curriculum
6 Topics
Chapter Summary
Oracle 12c /18c Architecture
Review some Basic commands in 12c / 18c
Create new pluggable database
Create the HR Schema
Navigate the HR Schema
22 Topics
Chapter Summary
Introduction
Group Functions and Group by part 1
Group Functions and Group by part 2
Group Functions and NULLS
Rollup Part 1
Rollup Part 2
Rollup Part 3
Rollup Part 4
Cube Part 1
Cube Part 2
Cube Part 3
GROUPING Function Part 1
GROUPING Function Part 2
GROUPING Function Part 3
GROUPING Function Part 4
The GROUPING_ID function
GROUPING SETS Part 1
GROUPING SETS Part 2
Composite Columns
Concatenated Groupings
Solving one task in 4 methods
32 Topics
RANK & DENSE_RANK Part 1
RANK & DENSE_RANK Part 2
RANK & DENSE_RANK Part 3
RANK & DENSE_RANK Part 4
RANK & DENSE_RANK ( Aggregate Syntax )
PERCENT_RANK Part 1
PERCENT_RANK Part 2
PERCENT_RANK Part 3 ( Aggregate Syntax )
CUME_DIST (cumulative distribution) Part 1
CUME_DIST (cumulative distribution) Part 2
LISTAGG function Part 1
LISTAGG function Part 2
NTILE function
ROWNUM & ROW_NUMBER Part 1
ROWNUM & ROW_NUMBER Part 2
ROWNUM & ROW_NUMBER Part 3
LAG & LEAD Functions Part 1
LAG & LEAD Functions Part 2
Aggregate functions VS Analytic Part 1 ( Very Important)
Aggregate functions VS Analytic Part 2 ( Very Important)
Aggregate functions & windowing clause 1
Aggregate functions & windowing clause 2
Aggregate functions & windowing clause 3
Aggregate functions & windowing clause 4
Aggregate functions & windowing clause 5
Aggregate functions & windowing clause 6
Aggregate functions & windowing clause 7
Aggregate functions & windowing clause 8
Aggregate functions & windowing clause 9
first_value & last_value PART 1
first_value & last_value PART 2
first_value & last_value PART 3
10 Topics
DBMS_RANDOM part 1
DBMS_RANDOM part 2
Using SELECT statement to create dynamic scripts
Hierarchical Queries Part 1
Hierarchical Queries Part 2
Hierarchical Queries Part 3
Hierarchical Queries Part 4
Hierarchical Queries Part 5
DML logs using package dbms_errlog
create matrix report using PIVOT
15 Topics
Course Setup Notes / 4 Options
Option 2- creating the HR Schema
Option 3- Part 1 : Oracle Database 12c Architecture
Option 3- Part 2 : Downloading Oracle DB 12c
Option 3- Part 3 : Installing Oracle DB 12c
Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
Option 3- Part 5: Unlock HR Account Part 1
Option 3- Part 6 : Unlock HR Account Part 2
Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
Option 4- Installing Oracle 11g express Edition + Unlock HR
HR Schema in this Course
Navigate HR schema
oracle 18c express edition part 1 (download and install )
oracle 18c express edition part 2 (unlock hr )
oracle 18c express edition part 3 ( sql developer )
Oracle Analytic Functions In-Depth & Advanced Oracle SQL
Related Oracle Database Courses
Thank You!
Your review has been submitted successfully.