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.
Sign up to stay up to date with news, special announcements and educational content.
Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.
Summit video library