Continuing on from Steve's recommendations, I'd say install two instances so that you can practise replication and manage it through pgadmin. No need for two machines. Just get them running off different ports. It helped me a good deal when I sat for my certification.
On Tue, 2024-12-03 at 11:30 -0800, Steve Midgley wrote:
Dear PostgreSQL Experts,
I hope this email finds you well. My name is [Your Name], and I am currently working as a PostgreSQL Database Administrator at a company developing financial software.
As part of my professional development, I am committed to mastering PostgreSQL in all its intricacies. I would be deeply grateful if you could share any resources, documentation, or recommendations that might help deepen my understanding and skills with PostgreSQL.
If there are specific guides, best practices, or advanced topics you believe would be particularly useful for someone in my field, I would be thrilled to receive your suggestions.
Thank you in advance for your time and assistance. I truly appreciate the wealth of knowledge shared by the PostgreSQL community and hope to contribute back in the future.
Best regards,
Suat MOLLASALİHOĞLU
My input for how to move forward with learning Pg:
- Download the server and install it.
- Pick some interesting data projects that you want to solve
- Work through the docs to get your orientation
- Use GPT4-o (or Claude 3.5 Sonnet) and Stackoverflow to help you figure out any details that you get stuck on
- Use this list to get help when you can't move forward
