If you write SELECT statements in SQL Server, you need to know about Windowing Functions. Whether you are an application developer, a data analyst, a DBA, or an ETL developer, Windowing Functions can help make your queries faster, cleaner, and more valuable to both you and your end-users.

In this session, we will UNDERSTAND the theory, VISUALISE the process, and DEMONSTRATE the output. From simple ROW_NUMBER and RANKing functions through to LEAD and LAG, we'll move quickly through the gears to make you a Windowing Functions Pro.

Attend this session, and learn how to add totals, sub-totals, variances, rolling moving averages, and other useful skills to your toolbelt.

So whether it’s tracking a value against the previous row, creating running totals, or a rolling sum, when you walk out of this session, you’ll be able to write a windowing function to make it happen.