The Magic of Window Functions in Postgres
EDB
0:00 / 0:00
The Magic of Window Functions in Postgres
4 036 просмотров · 6 лет назад
EDB
11,1 тыс. подписчиков
4 036 просмотров · 6 лет назад
For more Postgres webinars, visit: https://okt.to/1EMXGJ
-------------------------------------------------------------------------------
Window functions are often used to simplify complex queries and for data analytics. They allow analysis that is normally performed in client applications to be more efficiently processed by the database server.
This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.
In this webinar you will learn:
The basics of window functions
Window function syntax
Window syntax with generic aggregates
Window-specific functions
Window function examples
----------------------------------------------------------
For more #webinars, visit https://okt.to/wSA9p1
Download free #PostgreSQL whitepapers: https://okt.to/9SniZy
Read our #Postgres Blog https://okt.to/NSirVs
Follow us on Facebook at https://okt.to/CT4VsK
Follow us on Twitter at https://okt.to/S5JjWy
Follow us on LinkedIn at https://okt.to/ke2hC0
Reach us via email at marketing@enterprisedb.com