Skip to content
Write a review
UdemyData AnalysisPaid courseAll LevelsCertificate

EssentialSQL: SQL Window Functions for Business Analytics (Udemy.com)

SQL Window Functions for SQL Server, MySQL, SQLite & PostgreSQL, for Data Analysis, Business Analytics and Intelligence

4.5
116 reviews

Created by: Kris Wenzel

Last updated February 2024

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

How it compares

Against the other 371 rated Udemy courses in Data Analysis on CourseDuck:

  • Rating4.5 out of 5higher than 49% of them
  • Reviews116#330 of 372 by number of reviews
  • Length3.6 hoursshorter than 58% of them
  • Last updatedFebruary 2024earlier than 68% of them

icon
Course Description

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.
Read More All Levels All Levels product length iconTime: 3.6h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Kris Wenzel

If you're interested in learning SQL, you're in the right place.

I'm here to help you build a strong foundation in all aspects of SQL: from the very first steps to complex data architectures and designs. Many people struggle with where to begin learning SQL, but you don’t have to!! Essential SQL is my platform for bringing all aspects of SQL to you.


With more than 30 years of experience in SQL and a degree in Computer Engineering from the University of Michigan, I am passionate about helping others learn this valuable skill. As a blogger, I share SQL tips and how-to articles with over a million readers each year on my blog, Essential SQL. In addition, I have been teaching online for over eight years to people from various industries, including accounting, purchasing, and human resources.


In my professional life, I work with large corporations to design data warehouses that support business intelligence and data science activities. I believe that SQL is a valuable skill that is within reach for anyone, and my courses are designed to help you learn and grow with the technology.


So, what will you get out of my courses?

Read More

icon
More courses by Kris Wenzel

$11.99

$74.99

$64.99

$54.99

All courses by Kris Wenzel

icon
More Data Analysis courses

Free

$79.99

$12.99

$74.99

$69.99

Free

All Data Analysis courses

icon
Reviews

4.5

116 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Shirisha Ganta on 2/3/2025

It was very simply explained in a way we can understand and the following problems to solve gives more confidence of understanding

By Colleta Wamalwa on 1/22/2025

It definitely was a good match for me. Previously, I had issues understanding Window functions , it has made me better understand them and their use cases which will help me write shorter and readable queries.

By Lavi on 12/25/2024

Explanations were clear and to the point, no time wasting and the user interface and documentation is great, already planning to use some more courses made by Kris

By Isaac Aktam on 8/5/2024

A lot of the provided examples (e.g., Teams table) have missing data. Therefore, please provide complete table creation code. Thanks.

By Matthieu Carlini on 7/8/2024

Un cours rapide, parfaitement détaillé permettant d'apprendre ou de revoir les fonctions de fenêtrage. Les exemples couvent plusieurs SGBD, c'est un plus. 5 étoiles. A quick course, with perfect details to learn or review window functions. the examples are taken on several database, it's clever. Five stars.

By Bday23 Bachmatiuk on 5/28/2024

It's amazing - Finally I can understand window functions and get my dream job because of this course! Wish me luck!

By Fabian Feijen on 5/3/2024

Zeer duidelijke uitleg door de docent (ondersteund door duidelijke afbeeldingen)! De 24 oefeningen dragen zeker bij aan een nog beter begrip (hetzelfde geldt overigens voor de artikelen uit sectie 8); er is voldoende aandacht voor het schakelen tussen window functions en andere oplossingen, ook als dat moet.

By Brandon Williams on 1/15/2024

Concise and easy to follow the course. Number of grammatical errors, but you can get through those to complete the course.

By Kaloyan Dzhondzhorov on 11/30/2023

Good course, keeps it simple and to the point, I like that it is mostly practical. Has some minor mistakes in exercises that need to be fixed - as an example Section 3 Coding Exercise 2 in the condition the required column alias was ProuctPurchased, but in the editor the check was for ProductSold. For me this is ok, but it could be confusing for beginners.

By Nikos Vaggalis on 5/13/2023

Great and detailed content. one thing that I'd like an example in is how row and range behaves with date values. The example show that with just LastName

Showing all 10 reviews on CourseDuck

Read all 116 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

EssentialSQL: SQL Window Functions for Business Analytics
Visit course on Udemy Write a review
  • Video Duration: icon 3.6h
  • Price: $54.99
  • Provider: icon Udemy
  • Updated: icon February 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com