Bio

I've been doing PostgreSQL full time since 2013. I do consulting, training, and auditing out of Paris, France. I am also the co-founder and co-organizer of pgDay Paris.

Talk Description: What is a SELECT?

The SELECT statement is probably the most complex piece of all of SQL. Far beyond the simple "SELECT * FROM tablename", learning the full syntax can help you write cleaner, more efficient, and more easily maintainable code.

We will start with data sources which are varied and many, then move on to joining those sources together. Once this is understood we will cover manipulating our new dataset with various forms of filtering and grouping.

Then, we will look at the different ways of extracting our results into the form we want to return to the client. This includes bare columns, expressions, aggregates, and window functions.

Finally, we will look at how to compose queries with WITH-lists (also known as Common Table Expressions) and recursive queries.