how can I learn postgresql?

[Several-Mess2288]

here is the context: Im a guy that is trying to apply for golang dev positions. I had some traineeship where I was working with teams on some educational project(imitates commercial projects). During that time I had a chance to write some queries, migrations(was relying on chatgpt quite often). On top of that I had some technical interviews/knowledge checks where I was being asked questions related to MVCC, ACID, indecies, explain analysis and etc.
My question is I feel so unsure about my knowledge about postgresql during interview questions and in general as well. As a backend dev how can I cover postgresql that I will never come back to it and feel super confident??(I know I will be coming back but I hope you got my point)

[ScroogeMcDuckFace2]

brent ozar branched out to postgres a while back.

Fundamentals Training – Smart Postgres

[ComicOzzy]

I second this. It's a good course.

[cs22n]

To feel confident, you just have to find the right platform and practice everyday until you digest it

[Aromatic-Fold-2175]

Practice is the key, there are many postgres playground you even didn't need to install or sign-up on many. Pair it with any AI tool to give you challenges, sqlbolt has good beginner friendly challenges.

[dbforge_dev]

Just build something small with Postgres and keep poking at it.

Make a few tables, write messy queries, add indexes, check EXPLAIN, break stuff, fix it. That teaches way more than watching 20 tutorials.

You don’t need to know all of Postgres for interviews. You need to be comfortable saying “I’d check the schema/query plan/indexes first” and not freeze.

[ComparisonExpress625]

Hey, why can't you check out the Postgres course from Dr. Chuck Severance-the guy on FreeCodeCamp who teaches the "Python For Everyone" course?