Schedule - PGDay Chicago 2023

    Learning advanced SQL the weird (and hard) way

    Date: 2023-04-20
    Time: 15:55–16:45
    Room: Halsted Hub
    Level: Intermediate
    Feedback: Leave feedback

    Have you ever tried your hand at Advent of Code, the annual online coding challenge that takes place during the holiday season? It's a fun and challenging way to test your coding skills and get into the holiday spirit. But what if I told you that there were ways to solve the problems using only SQL?

    In this talk, I will explain my experience trying to solve advent of Code challenges with SQL only (Postgres flavor). My rules, what I learned, the hard parts, the easy parts, my tips and tricks (should you want to try it yourself) but overall how much it enlightened my use of Postgres and SQL.

    Whether you're a seasoned Advent of Code veteran or a newcomer to the challenge, whether your SQL skills are basic or advanced, I hope that you will come away with a newfound appreciation for the power and flexibility of SQL, as well as some ideas for how to incorporate it into your own coding practices.


    Lætitia Avrot