Advanced TSQL Window Functions for Advanced Querying

Learn how to use Window Functions or Analytical Functions to perform data analysis in SQL Server
Advanced TSQL Window Functions for Advanced Querying
File Size :
636.33 MB
Total length :
1h 42m



Rwynn Christian


Last update




Advanced TSQL Window Functions for Advanced Querying

What you’ll 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

Advanced TSQL Window Functions for Advanced Querying


SQL Server 2012+
Experience writing and Tuning (Transact) SQL Queries


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!


Section 1: Introduction

Lecture 1 Welcome to this Course!

Lecture 2 Course Introduction

Lecture 3 Setting up your environment

Lecture 4 Setting up your environment – Restoring the Database

Lecture 5 Introduction to Window Functions

Section 2: Ranking Window Functions

Lecture 6 ROW_NUMBER


Lecture 8 NTILE

Section 3: Window Aggregate Functions

Lecture 9 Types of Window Aggregate Functions

Lecture 10 Using Window Aggregate Functions

Lecture 11 Introduction to Framing

Lecture 12 Using Window Aggregate Functions with Frames

Section 4: Window Offset Functions

Lecture 13 LAG & LEAD


Section 5: Window Statistical Functions



Section 6: Course Summary and Final Considerations

Lecture 17 Course Summary

Data Analysts,Database Developers,Database Administrators,Anyone who wants to learn the art of writing Window Functions to analyze their data,Anyone who wants to refresh their knowledge on Window Functions

Course Information:

Udemy | English | 1h 42m | 636.33 MB
Created by: Rwynn Christian

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top