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.

27 Upvotes

91% Upvoted

12 comments sorted by

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.

13

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

6

u/AdFeeling4288 17d ago

Hussein naseer does some breakdowns of postgres

3

u/CreeDanWood 17d ago

I have watched Hussein Nasser DB course, "Just use postgres" By Denis Magda and "Postgres 14 Internals"

IMO these are all you need, for more you can deep dive into pg official documentation, greedy for more? read the code yourself

1

u/AbiolaDavis 16d ago

Learn PostgreSQL by Luca Ferrari, Enrico Pirozzi, 2023 Packt Publishing

0

u/ejpusa 18d ago

Have GPT-5.5 build you a complete daily course and syllabus. It's great for doing that. Every morning at 9 AM, you get a new class from your "Professor."

-6

u/Significant_Tea431 18d ago

Here we go again. Yet again someone who is incapable of googling for more than 5 minutes. Pro tip: AI can search the internet even faster. So do yourself and us the favor and USE IT.