Selection of Advanced SQL topics discussed in depth
PostgreSQL is renowned for its advanced features, excellent support of the ISO SQL standards, and deeply rooted extensibility.
Stephen Frost, a PostgreSQL major contributor, is coming up from D.C. to enlighten us on the vast array of powerful capabilities available through standard, albeit advanced, SQL. We will delve into examples such as recursive and writable common table expressions (WITH queries), moving window aggregates, LATERAL, and other less commonly known SQL language features supported by PostgreSQL.
SQL: Window Functions, FDW, Full Text Search, visões materializadas (materialized views), etc