Exploring SQL Server Window Functions
Windows Functions first emerged with the 2005 release – and were enhanced in 2012. They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may – at first – seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.
Join usPresenter: Martin Catherall
About the presenter:
About the presenter:
Martin is a Consultant with SQL Masters Consulting in Brisbane, with close to 20 years of experience on the SQL Server Platform. He volunteers as a PASS Regional Mentor and speaks at many SQL Saturday events around Australia and New Zealand.
Martin started his IT career as a software developer, later becoming a database developer, a DBA and more recently working across the entire Microsoft Data Platform
Location:
Online event (link visible for attendees)
Date & Time:
Wednesday, 3rd June 2020, 5:00PM to 7:00PM AEST.
Register now!