Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages.
The features introduced in PostgreSQL complete the implementation according to the SQL:2011 standard, adding capabilities such as range frames, GROUPS mode, and exclusions.
As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Business Intelligence with Window Functions in PostgreSQL, which gave an overview of Window Functions, how to use them in PostgreSQL, their impact on business intelligence along with discussing specific features and detailed examples.
The topics covered in the webinar were:
– Introduction to Window Functions in PostgreSQL
– How to use Window Functions for business intelligence
– Capabilities such as range frames, GROUPS mode and exclusions
– Illustration of Window Functions specific features with detailed examples
The webinar was presented by Gianni Ciolli, Head of Professional Services at 2ndQuadrant.
You can now watch the full webinar, first held on 28 August 2019.
To stay updated on upcoming weekly webinars by 2ndQuadrant, you can visit our Webinars page.
For any questions, comments, or feedback, please visit our website or send an email to [email protected].