Skip to content

Details

Agenda

18:30 - Welcome and introduction

18:45 - James McGillivray - Getting to grips with Windowing Functions

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.

20:00 - Closing and prize giving

Related topics

Events in Sandton
Microsoft Azure
SQL
Computer Programming
Open Source
Software Development

Sponsors

Cobalt Analytics

Cobalt Analytics

Cobalt Analytics have donated prizes to be given to a lucky attendee

Microsoft

Microsoft

Microsoft has sponsored the venue and snacks.

CyberLogic

CyberLogic

Cyberlogistics has come onboard as a sponsor of this event

You may also like