Schedule - FOSDEM PGDay 2024

Advanced SQL- Do you know all SQL can do?

Date: 2024-02-02
Time: 14:20–15:10
Room: Ballroom

This talk will cover various advanced SQL topics at a depth appropriate for the individuals in the room- we'll dive in where it's clear there is need, and skim parts that are well known.

Are you familiar with simple selects, inserts, updates, and deletes? What about joins? Inner, Outer, Left, Right joins? Sub-selects? EXISTS? How about UNIONs (what's a UNION ALL?)?, What database implements MINUS (part of the SQL standard)?, Ever considered an UPDATE which has a FROM clause?, Heard of CTEs (but what are wCTEs?)?, Recursive queries?, What about Windowing functions?

We'll touch on it all, but our direction and focus will be driven by you!


Stephen Frost