Introduction to SQL Window Functions

Learn How Windowing Functions Works

4.60 (110 reviews)
Udemy
platform
English
language
Databases
category
Introduction to SQL Window Functions
1,448
students
3.5 hours
content
Jan 2024
last update
$54.99
regular price

What you will learn

Install Oracle database

Install TOAD

Install SQL Developer

Connect TOAD and SQL Developer to Oracle

Write syntax for analytic functions

Use aggregate functions

Use analytic functions

Understand windowing clause

Understand and use Partition By clause

Understand and use Order By clause

Description

SQL window functions —also known as windowing functions, OVER functions, or analytic functions — are tremendously useful. These functions make building complex aggregations much simpler. In this step-by-step course , I  will lead you through SQL window functions. At its end, you'll embrace this topic with ease and feel comfortable using window functions in SQL databases.

The most popular business problems  can be solved with SQL . What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions have to be translated from business language to programming language.

This course covers the syntax and semantics of SQL window functions. It shows how powerful they are, what the typical use cases are, and how to use ORDER BY and PARTITION BY to set up a frame for window functions. You'll also learn the difference between ROWS and RANGE clauses.

Topics covered includes:

  • Installing Oracle database
  • Installing TOAD
  • Installing SQL developer
  • Connecting TOAD and SQL Developer to Oracle Database
  • Anatomy of Analytic | Window functions
  • Aggregate functions
  • Analytic functions
  • How windowing works

What Am I Going To Get from This SQL Window functions  Course?

  • You'll discover how window functions can be used to:
  • Compute running totals and running averages
  • Build rankings
  • Use DENSE RANK
  • Find first and last values
  • Use  OVER clause
  • Use Partition By clause
  • Use Order By clause
  • Use Windowing clause

You'll also get a deeper understanding of SQL aggregate  and analytic functions.

Who Should Take This Course?

  • Beginning database analysts
  • Developers who want to keep their knowledge of SQL current
  • Students taking classes in relational databases
  • Anyone who wants to learn SQL window functions


Content

Setting Up Your Database Environment

Introduction
Tools the professionals use
Installing Oracle Database
Unlocking Schema
Installing TOAD
Connecting TOAD to Oracle
Installing Oracle SQL Developer
Connecting SQL Developer to Oracle Database

Anatomy of an Analytic and window function

What are analytic functions
What are windows functions
The Syntax
The PARTITION BY clause
The ORDER BY clause

Aggregate Functions

MAX
MIN
COUNT
SUM
AVG

Analytic Window Functions

ROW NUMBER functions
RANK functions
DENSE RANK functions
LEAD functions
LAG functions
FIRST and LAST functions
LISTAGG functions

How Windowing works

Introduction
Working with the default windowing clause
ROWS and Windowing clause
RANGE and Windowing clause
BETWEEN and Windowing clause
Using multiple Windows into your data

Reviews

Narayana
May 2, 2023
Missing the Link and KB's and kindly share the 11g XE link as oracle has come up with newer versions. Working examples with queries actually helped me to understand the concepts better.
Surya
September 19, 2021
Overall the content of the course is good. But some of the videos feel so draggy. It would be better if the important points were given more attention. Like in windowing section half o the video duration covers where the function is not applied. Only if these were improved, definitely a 4+ stars.
Ipsita
December 9, 2020
Its good for understanding basic window function.It would be good to have more examples and also exercises and a last section with some complex query samples.
Vineet
November 22, 2020
Could have added a graphic example to help in understanding the concept. There should be quizzes for checking knowledge
Atimanas
April 15, 2020
The real world example where these operators would play a role is not given. E.g. it states what a rank or dense rank do. But it doesn't state a real world problem where one can be used over other as an suitable solution.
Kattel
November 3, 2019
The instructor was great but it could have been better with more examples and exercises. Also, the instructor's voice is dormant, meaning you hear it and makes you want to sleep.. no energy when teaching. Being Honest.
Sébastien
May 23, 2019
The tone and voice is perfect for great understanding - especially for non native english speakers. The trainer takes adequate time to explain concepts that can appear subjective and abstract in a clear an simple fashion. well done !

Charts

Price

Introduction to SQL Window Functions - Price chart

Rating

Introduction to SQL Window Functions - Ratings chart

Enrollment distribution

Introduction to SQL Window Functions - Distribution chart

Related Topics

1644068
udemy ID
4/13/2018
course created date
7/14/2019
course indexed date
Bot
course submited by