Postgres running local has good ROI. You can reuse that knowledge on a remote server. More than SQL you can learn about setting up databases and schemas etc.

Can you recommend any good book/resource to pick up PostgreSQL?

I'm familiar with MySQL/MariaDB, but have no experience with Postgres.

The best I've seen is The Art of PostgreSQL: https://theartofpostgresql.com/

Thank you, sir!

I always google what I need. I admit I haven’t gone deep into it. Just the basics for side projects.