HOT
blank

EssentialSQL: SQL Window Functions for Business Analytics

Development

EssentialSQL: SQL Window Functions for Business Analytics, available at $54.99, has an average rating of 4.85, with 41 lectures, 24 quizzes, based on 53 reviews, and has 348 subscribers.

Rating4.9
Enroll Now

You will learn about Learn how to incorporate window functions into your SQL queries. Understand how partitions and windows work together within a query. Apply window functions so you can avoid using cursors in your SQL. Understand the difference between window function mechanics and GROUB BY summaries. Create complex queries involving joins using window functions. Apply aggregate, analytic, and ranking functions to perform common business tasks such as calculating running totals or comparing one row’s value to the next. Create queries using either MySQL, PostgreSQL, or SQL Server. This course is ideal for individuals who are Advanced Beginner to Intermediate SQL query authors curious about window functions. or If you're having a hard time understanding the ins and outs of window functions, then this course is for you as I explain it to you in simple to understand English. or Business analysts looking more ways to write queries. or Data Engineers needing more tools to deal with dirty data, such as an easy means to deduplicate incoming rows. or Recent college graduates looking to hone their SQL skills. or Job applicants looking for that extra edge with their next interview! It is particularly useful for Advanced Beginner to Intermediate SQL query authors curious about window functions. or If you're having a hard time understanding the ins and outs of window functions, then this course is for you as I explain it to you in simple to understand English. or Business analysts looking more ways to write queries. or Data Engineers needing more tools to deal with dirty data, such as an easy means to deduplicate incoming rows. or Recent college graduates looking to hone their SQL skills. or Job applicants looking for that extra edge with their next interview!.

Enroll now: EssentialSQL: SQL Window Functions for Business Analytics

Summary

Title: EssentialSQL: SQL Window Functions for Business Analytics

Price: $54.99

Average Rating: 4.85

Number of Lectures: 41

Number of Quizzes: 24

Number of Published Lectures: 41

Number of Published Quizzes: 24

Number of Curriculum Items: 67

Number of Published Curriculum Objects: 67

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

  • Learn how to incorporate window functions into your SQL queries.
  • Understand how partitions and windows work together within a query.
  • Apply window functions so you can avoid using cursors in your SQL.
  • Understand the difference between window function mechanics and GROUB BY summaries.
  • Create complex queries involving joins using window functions.
  • Apply aggregate, analytic, and ranking functions to perform common business tasks such as calculating running totals or comparing one row’s value to the next.
  • Create queries using either MySQL, PostgreSQL, or SQL Server.

Who Should Attend

  • Advanced Beginner to Intermediate SQL query authors curious about window functions.
  • If you're having a hard time understanding the ins and outs of window functions, then this course is for you as I explain it to you in simple to understand English.
  • Business analysts looking more ways to write queries.
  • Data Engineers needing more tools to deal with dirty data, such as an easy means to deduplicate incoming rows.
  • Recent college graduates looking to hone their SQL skills.
  • Job applicants looking for that extra edge with their next interview!

Target Audiences

  • Advanced Beginner to Intermediate SQL query authors curious about window functions.
  • If you're having a hard time understanding the ins and outs of window functions, then this course is for you as I explain it to you in simple to understand English.
  • Business analysts looking more ways to write queries.
  • Data Engineers needing more tools to deal with dirty data, such as an easy means to deduplicate incoming rows.
  • Recent college graduates looking to hone their SQL skills.
  • Job applicants looking for that extra edge with their next interview!

In this Course you will Learn to:

  • Write simpler queries using window functions.

  • Know how window functions work with partition and other clauses to help you form running totals or compare values from one row to the next.

  • Create complex queries involving joins using window functions.

  • Learn how to use LEAD and LAG to avoid using cursors in your SQL scripts.

  • Write window functions using MySQL, PostgreSQL, SQLite, or SQL Server – your choice!  I’m sure they will work with Oracle, I just haven’t tested…  🙂

  • Understand how to set up a window frame and their affect on the window function.

  • Know the difference between window functions and classing GROUP BY results.

  • Work with multiple window functions within a query.

  • Who to use results from a window functions within the same query.

  • Learn to us the three classes of functions: Aggregate, Ranking, and Analytic functions.

Nothing is worse than

  • Being excited to learn something new but not knowing where to start.

  • Wasting time learning the wrong features.

  • You being overwhelmed with options and not knowing which to use.

Imagine Having…

  • Knowledge – Knowing how to quickly use window functions to take your SQL to the next level.

  • Confidence – Feeling good that you’re on the right track.

  • Accomplishment – Having a sense of accomplishment that you’ve learned something most cannot.

By the time you’ve completed this course you’ll have an appreciation of window functions, overcome your fear, and able to use them to simplify some of your very complex queries.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course

Lecture 2: Why You Should Learn Windows Functions

Lecture 3: What Flavor of SQL Should I Choose?

Lecture 4: How to Take the Course

Lecture 5: Tools Used and Database Setup

Chapter 2: Warmup

Lecture 1: What is a Window Function?

Lecture 2: GROUP BY versus Window Function Results

Lecture 3: Create Running Totals using SQL Joins versus Window Functions

Chapter 3: Windows and Partitions

Lecture 1: Introduction

Lecture 2: Window Function Order of Operations

Lecture 3: Using OVER to create a window

Lecture 4: Using PARTITION BY to group rows

Lecture 5: Overcome Window Function Limitations

Chapter 4: Defining Window Function Frames with ROW and RANGE

Lecture 1: Introduction to Window Frames

Lecture 2: Using Over and Order by with Window Functions

Lecture 3: Introduction to Defining Window Frames using ROWS and RANGES

Lecture 4: Using ROWS to Define the Window Frame.

Lecture 5: Demonstration on Using ROWS to Define the Window Frame

Lecture 6: Using RANGE to define the Window Frame

Lecture 7: Demonstration on Using RANGE to Define a Windows Frame

Chapter 5: Aggregate Functions

Lecture 1: Introduction to Aggregate Functions with OVER

Lecture 2: Commonly Used Aggregate Functions

Lecture 3: Uncommonly Used Aggregate Functions

Lecture 4: Coding Exercise – Aggregate Functions and OVER()

Chapter 6: Ranking Functions

Lecture 1: Introduction and Review of Functions

Lecture 2: Comparison of Ranking Functions

Lecture 3: Using the WINDOWS clause.

Chapter 7: Analytic Functions

Lecture 1: Introduction to Analytic Functions

Lecture 2: Comparison of LEAD, LAG, FIRST_ROW and LAST_ROW functions

Lecture 3: LEAD and LAG Demo

Lecture 4: FIRST_VALUE and LAST_VALUE Demo

Lecture 5: Calculating Percentiles using Window Functions

Chapter 8: Window Function Recipies

Lecture 1: How Do I Calculate a Running Total Using SQL?

Lecture 2: How Do I Calculate a Moving Average using SQL?

Lecture 3: How Do I Find Duplicates Using Windows Functions

Lecture 4: How Do I Remove Duplicates Using ROW_NUMBER?

Lecture 5: How Do I Calculate the Median value using SQL?

Lecture 6: Calculate the Percentage Change from One Value to the Next

Lecture 7: How to Compare Two Moving Averages

Lecture 8: How to Add a Unique ID to a Query Result

Chapter 9: Bounus

Lecture 1: Bonus Lecture

Instructors

  • Kris Wenzel
    Kris Wenzel
    Let me teach you SQL using simple to understand English.
  • Essential Sql
    Essential Sql
    Learn everything you need to use SQL in your next project

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 0 votes
  • 3 stars: 8 votes
  • 4 stars: 11 votes
  • 5 stars: 34 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!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024