Introduction to SQL Window Functions

Introduction to SQL Window Functions, available at $54.99, has an average rating of 4.6, with 34 lectures, based on 110 reviews, and has 1456 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner data scientist or Beginner data analyst or Beginner DBA or Anyone who wants to learn about SQL Window Functions It is particularly useful for Beginner data scientist or Beginner data analyst or Beginner DBA or Anyone who wants to learn about SQL Window Functions.

Enroll now: Introduction to SQL Window Functions

Summary

Title: Introduction to SQL Window Functions

Price: $54.99

Average Rating: 4.6

Number of Lectures: 34

Number of Published Lectures: 34

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: $94.99

Quality Status: approved

Status: Live

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

Who Should Attend

Beginner data scientist
Beginner data analyst
Beginner DBA
Anyone who wants to learn about SQL Window Functions

Target Audiences

Beginner data scientist
Beginner data analyst
Beginner DBA
Anyone who wants to learn about SQL Window Functions

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

Course Curriculum

Chapter 1: Setting Up Your Database Environment

Lecture 1: Introduction

Lecture 2: Tools the professionals use

Lecture 3: Installing Oracle Database

Lecture 4: Unlocking Schema

Lecture 5: Note on downloading Toad

Lecture 6: Downloading Toad Trial Software

Lecture 7: Installing TOAD

Lecture 8: Connecting TOAD to Oracle

Lecture 9: Installing Oracle SQL Developer

Lecture 10: Connecting SQL Developer to Oracle Database

Chapter 2: Anatomy of an Analytic and window function

Lecture 1: What are analytic functions

Lecture 2: What are windows functions

Lecture 3: The Syntax

Lecture 4: The PARTITION BY clause

Lecture 5: The ORDER BY clause

Chapter 3: Aggregate Functions

Lecture 1: MAX

Lecture 2: MIN

Lecture 3: COUNT

Lecture 4: SUM

Lecture 5: AVG

Chapter 4: Analytic Window Functions

Lecture 1: ROW NUMBER functions

Lecture 2: RANK functions

Lecture 3: DENSE RANK functions

Lecture 4: LEAD functions

Lecture 5: LAG functions

Lecture 6: FIRST and LAST functions

Lecture 7: LISTAGG functions

Chapter 5: How Windowing works

Lecture 1: Introduction

Lecture 2: Working with the default windowing clause

Lecture 3: ROWS and Windowing clause

Lecture 4: RANGE and Windowing clause

Lecture 5: BETWEEN and Windowing clause

Lecture 6: Using multiple Windows into your data

Lecture 7: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 2 votes
3 stars: 21 votes
4 stars: 46 votes
5 stars: 39 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