Data Analysis with Oracle Analytic Functions
4.5 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
967 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analysis with Oracle Analytic Functions to your Wishlist.

Add to Wishlist

Data Analysis with Oracle Analytic Functions

Learn data analysis by using Oracle Analytic functions to manipulate data
4.5 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
967 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • You should have a basic SQL knowledge
Description

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..


Who is the target audience?
  • Analyst
  • Big Data Professionals
  • Data Warehourse beginners
  • Students
  • Recent Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
02:39:28
+
Database Setup
9 Lectures 34:57

Oracle Database Hardware Requirements
00:19

Oracle Database Software Requirements
00:24



Unlock Sample HR Schema Account
03:30

Download TOAD
05:29

Install TOAD
03:33

Connect TOAD to Oracle Database
08:11
+
Oracle Analytic Functions
17 Lectures 02:04:38
What are Analytic Functions ?
06:43

Analytic Functions Syntax
04:07

The Partition By Clause
08:04

The Order By Clause
05:48

Dense Rank Function
05:57

Rank Function
06:04

First and Last Function
08:56

LAG Function
03:37

LEAD Function
06:44

LISTAGG Functions
06:14

ROW Number Functions
09:26

What is a Windowing Clause
08:06

The Default Windowing clause
10:52

Using Rows in Windowing Clause
11:26

Using Range with Windowing clause
07:36

Using Between with Windowing Clause
09:35

Using Multiple window into your data
05:23
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,548 Reviews
35,071 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.