This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2016

Becoming a SQL Guru

Date: 2016-11-02
Time: 12:10–13:00
Room: Omega
Level: Beginner

When it comes to data, SQL is a vast and powerful language. That being said, it is difficult to know and properly utilize all of its functionality, especially considering that each RDBMS has its own dialect and feature set. In this talk, we will review the advanced SQL functionality available for you within PostgreSQL, enabling you to become the SQL guru of your team. We will explore examples and use cases for Common Table Expressions(including recursive queries), Correlated and Uncorrelated Subqueries, Analytical Window Functions(ie: Percentile, Running Aggregates, Rank), Lateral, and other less commonly known, but incredibly useful, features supported by PostgreSQL. This talk will provide you with the tools you need to write (or rewrite) performant, readable, and efficient queries, solve complex analytical questions, and make large data sets and complex data/analysis requests more manageable.


Stella Nisenbaum