Skip to content
Write a review
UdemyData AnalysisPaid courseIntermediate levelCertificate

Advanced T-SQL: Window Functions for Advanced Querying (Udemy.com)

Learn how to use Window Functions or Analytical Functions to perform data analysis in SQL Server

4.4
784 reviews

Created by: Rwynn Christian

Last updated September 2021

icon
What you will learn

  • The concept of looking at data through a window
  • The fundamentals of Window Functions
  • How Window Functions compare to the traditional way of grouping data
  • The different types of window functions available in SQL
  • How to implement Window Functions
  • Window Ranking Functions
  • Window Aggregate Functions
  • Window Offset Functions
  • Window Statistical Functions

How it compares

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

  • Rating4.4 out of 5higher than 35% of them
  • Reviews784#161 of 372 by number of reviews
  • Length1.7 hoursshorter than 86% of them
  • Last updatedSeptember 2021earlier than 82% of them

icon
Course Description

Unlock the Power of Data Analysis with Ease Using Window Functions!


Welcome to our self-paced course, where we'll take you on a journey to master the art of data analysis in SQL databases using the incredible capabilities of Window Functions.


Why Window Functions? Here's what you'll gain:

  • Explore the Core Concepts: We'll start with the basics and delve into the key principles behind Window Functions, making even complex data analysis seem like a breeze.

  • Diverse Window Functions: Discover a treasure trove of Window Functions at your fingertips. From ROW_NUMBER to LAG and LEAD, you'll have an arsenal of tools to solve diverse data challenges.

  • Crafting Your Own Functions: Learn how to design and tailor Window Functions to your specific analytical needs. Unlock the potential to extract valuable insights from your data like never before.

  • Practical Implementation: We won't just stop at theory. Our course provides hands-on experience, allowing you to apply these techniques in real-world scenarios.

This course offers a complete learning package:

  • Engaging Video Presentations: Our dynamic video lessons bring concepts to life, making learning enjoyable and accessible.

  • Comprehensive Resources: Access a wealth of resources, including reference links to text-based materials, ensuring you have all the support you need.

  • Universal Compatibility: Window Functions are part of the ANSI standard SQL specification, meaning you can apply these skills to any relational database management system supporting SQL.

Have questions or need assistance? Our Q&A section is your lifeline, connecting you with experts who are ready to help you conquer any challenges you encounter.

Plus, upon course completion, you'll receive a certificate, a testament to your proficiency in implementing Window Functions.

Don't wait any longer—seize this opportunity to supercharge your data analysis skills.

Enroll now and elevate your career to new heights!

Read More Intermediate Intermediate Level product length iconTime: 1.7h

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

Rwynn Christian

Hi, my name is Rwynn Christian. I have been working as a Software Engineer and a Data Analyst in various companies.

I mainly work in the Microsoft Development Environment, using C# in combination with WPF/Winforms to build Modern Desktop Business Solutions or ASP.NET MVC to build scalable Web Solutions. I have also gained experience working with Java EE and the Spring Boot Framework. As a Database Developer, I am also responsible for designing and Implementing SQL Server Databases.

I'm a Microsoft Certified Solutions Expert in Data Management and Analytics and also hold several MCSA certifications.

Read More

icon
More courses by Rwynn Christian

$64.99

All courses by Rwynn Christian

icon
More Data Analysis courses

Free

$79.99

$12.99

$74.99

$69.99

Free

All Data Analysis courses

icon
Reviews

4.4

784 ratings on Udemy

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

Write a review

By Shridhar Patil on 7/10/2026

Tutor needs to elaborate concepts first , before describing the examples

By Ashwin Jai on 2/5/2025

I've undertook various sql bootcamps but Rwynn was able to unleash the next thread of window function, not came across before. He is an gifted teacher with no bs and straight to the point. He's delivered multi-level advance topic in an easy going teaching in an short time. Rock on !

By Mc Gowda on 9/17/2024

1. Great Example 2. Method of explanation is really simple and easy to digest 3. Use cases is really good 4. Explained window by window 4. Explained clearly how row level windowing and partition is applied!

By Anonymized User on 2/16/2024

I found some of the topics to be a little rushed and difficult to follow, but generally a good introduction to the Windows functions.

By Anonymized User on 7/6/2023

Pros: very easy to understand voice, content was very helpful and relevant Cons: some of the captions are very off, and I wish there was a section describing the differences in the syntax between window functions in SSMS vs Teradata; because there wasn't, I might have a difficult time putting my learnings into practice.

By Trilok Nath on 10/27/2022

I found it very useful to understand the concept of window Frames and how to implement windows functions. It would be more interactive if the query typing should be there. Otherwise it is a great course for windows functions.

By Richard Pl on 5/31/2022

Straight to the point, with examples that can be used in the real world setting for most industries. Definitely could use more practice, but the course provided the knowledge necessary to practice within my own dataset...and provided what was advertised within the course description. Overall, I am happy with the value and knowledge received.

By Richard Ogoma on 3/31/2022

The course content is amazing, and the instructor had a command of the subject, he was amazing and practical in his approach. I learnt new things like the statistical window functions and better understood the concept of windowing data. This has unlocked new possibilities in my work place as a data analyst. Thank you Rwynn!

By Guadalupe Ayelén Lamas on 9/2/2021

It was great! I believe this is really useful and usually left out when you take sql courses. I just wished we could have the document with the queries so as to follow better and have that resource for later in case I want to check some syntax in particular while practicing.

By Jonas Hansson on 2/27/2021

Love how this course take you through the windows functions and then also gives meaningful examples. Thank you so much for this course! Makes life easier to help me out when I need to use different functions. Best regards Jonas, Gothenburg Sweden

Showing all 10 reviews on CourseDuck

Read all 784 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 : 88 / 100

Advanced T-SQL: Window Functions for Advanced Querying
Visit course on Udemy Write a review
  • Video Duration: icon 1.7h
  • Price: See price on Udemy
  • Provider: icon Udemy
  • Updated: icon September 2021
  • Level: Intermediate Intermediate
  • 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