I found "The Art of PostgreSQL" quite helpful: https://theartofpostgresql.com/