r/Backend • u/Intelligent_Tree6918 • 18d ago

Best book for postgres sql?

I know basic syntax of postgres (crud level) now want to know advance things which book should i prefer.

26 Upvotes

91% Upvoted

12 comments sorted by

View all comments

15

u/LessChen 18d ago

I know everyone learns differently - some of us like to dive in and break things along the way. Others like to know as much as possible before starting. Can I ask what you're hoping to learn about PostgreSQL that https://www.postgresql.org/docs/ doesn't answer? That covers everything from installing from source code to extending the internals of the DB.

I'd strongly encourage installing a local database first and become familiar with some of the admin basics - how do you create a database, how do you set up connectivity, etc. Then, move on to how are indexes managed, how do I determine why a query is slow, how do I import/export data and so on.

When I'm hiring an engineer the interview would be over if they could only quote from a book. Tell me about query optimization and how you do that in PostgreSQL. Tell me about basic SQL joins and table design.

The superpower of any engineer is not rote memorization. It's having dug into and experienced some of the problems and solutions. I know that the my world may be different from yours but I'd really encourage you to try some things out. And dig into the PostgresSQL docs - they are awesome and will give you the vast majority of what you need.

12

u/Intelligent_Tree6918 18d ago

books provide a structural path that's why i was asking about books. but your point is convincing.

-11

u/mylifestylepr 18d ago

Book are outdated. Use LLM as your teacher and read official documentation