Data Analysis with Oracle Analytic Functions

Data Analysis with Oracle Analytic Functions, available at $49.99, has an average rating of 4.55, with 27 lectures, based on 47 reviews, and has 1182 subscribers.

You will learn about Write and understand the syntax for analytic functions Analyse data with Rank Function Analyse data with First and Last Function Analyse data with LAG Function Analyse data with LISTAGG Function Analyse data with Row Number Function Analyse data with LEAD Function Analyse data with Windowing Clause This course is ideal for individuals who are Analyst or Big Data Professionals or Data Warehourse beginners or Students or Recent Graduates It is particularly useful for Analyst or Big Data Professionals or Data Warehourse beginners or Students or Recent Graduates .

Enroll now: Data Analysis with Oracle Analytic Functions

Summary

Title: Data Analysis with Oracle Analytic Functions

Price: $49.99

Average Rating: 4.55

Number of Lectures: 27

Number of Published Lectures: 27

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Write and understand the syntax for analytic functions
Analyse data with Rank Function
Analyse data with First and Last Function
Analyse data with LAG Function
Analyse data with LISTAGG Function
Analyse data with Row Number Function
Analyse data with LEAD Function
Analyse data with Windowing Clause

Who Should Attend

Analyst
Big Data Professionals
Data Warehourse beginners
Students
Recent Graduates

Target Audiences

Analyst
Big Data Professionals
Data Warehourse beginners
Students
Recent Graduates

There is a demand for people who can use data to perform analysis thus helping businesses and organizations make important and critical decisions.
SQL stands for Structure Query Language. It is an internationally standard language used to communicate with various databases for data manipulation. SQL is vital for data analysis .

In this beginners course we will be using analytic functions to perform data analysis from an Oracle database .

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and is defined by the analytic clause. For each row, a sliding window of rows is defined. The window determines the range of rows used to perform the calculations for the current row. Window sizes can be based on either a physical number of rows or a logical interval such as time.

Analytic functions are commonly used to compute cumulative, moving, centred, and reporting aggregates.
In this course we learn the syntax used to write analytic functions which includes the use of Partition By and
Order By.

The analytic functions we will use for our data analysis include:

    • Dense Rank Function
    • Rank Function
    • First and Last Function
    • LAG Function
    • LEAD Function
    • LISTAGG Functions
    • ROW Number Functions
    • Windowing Clause

Using analytic functions for data analysis can help provide answers to business solutions :

    •   Who are the top ten sales-reps in each region?
    •   How many employees in an organization
    •   How many employees earn less than 45K in an organization
    •   How many new employees joined the company in the past 18 months
    •   What goods are flying off the supermarket shelves and so on..

Course Curriculum

Chapter 1: Database Setup

Lecture 1: Introduction

Lecture 2: Oracle Database Hardware Requirements

Lecture 3: Oracle Database Software Requirements

Lecture 4: Download Oracle Database

Lecture 5: Install Oracle Database

Lecture 6: Unlock Sample HR Schema Account

Lecture 7: Download TOAD

Lecture 8: Install TOAD

Lecture 9: Connect TOAD to Oracle Database

Chapter 2: Oracle Analytic Functions

Lecture 1: What are Analytic Functions ?

Lecture 2: Analytic Functions Syntax

Lecture 3: The Partition By Clause

Lecture 4: The Order By Clause

Lecture 5: Dense Rank Function

Lecture 6: Rank Function

Lecture 7: First and Last Function

Lecture 8: LAG Function

Lecture 9: LEAD Function

Lecture 10: LISTAGG Functions

Lecture 11: ROW Number Functions

Lecture 12: What is a Windowing Clause

Lecture 13: The Default Windowing clause

Lecture 14: Using Rows in Windowing Clause

Lecture 15: Using Range with Windowing clause

Lecture 16: Using Between with Windowing Clause

Lecture 17: Using Multiple window into your data

Lecture 18: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 2 votes
3 stars: 7 votes
4 stars: 15 votes
5 stars: 22 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