Postgres Pro
Downloads
Home   >   mailing lists

Thread: Request for PostgreSQL Resources and Documentation

Request for PostgreSQL Resources and Documentation

From
Suat Mollasalihoglu
Date:

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

Re: Request for PostgreSQL Resources and Documentation

From
Steve Midgley
Date:


On Tue, Dec 3, 2024 at 11:21 AM Suat Mollasalihoglu <mollasalihoglusuat@gmail.com> 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

The documentation on the main site is spectacularly good, in my opinion: https://www.postgresql.org/docs/current/index.html

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

Re: Request for PostgreSQL Resources and Documentation

From
Andrew Cilia
Date:
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:


On Tue, Dec 3, 2024 at 11:21 AM Suat Mollasalihoglu <mollasalihoglusuat@gmail.com> 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


The documentation on the main site is spectacularly good, in my opinion: https://www.postgresql.org/docs/current/index.html

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


Re: Request for PostgreSQL Resources and Documentation

From
Suat Mollasalihoglu
Date:
Dear Steve and Andrew,

Thank you both for your detailed and insightful responses. I truly appreciate the time you took to share your recommendations.

Your guidance is invaluable, and I’m excited to apply these suggestions to deepen my PostgreSQL knowledge and skills.

Best regards,
Suat MOLLASALİHOĞLU

Re: Request for PostgreSQL Resources and Documentation

From
shammat@gmx.net
Date:
Suat Mollasalihoglu schrieb am 04.12.2024 um 09:04:
> Dear Steve and Andrew,
>
> Thank you both for your detailed and insightful responses. I truly appreciate the time you took to share your
recommendations.
>
> Your guidance is invaluable, and I’m excited to apply these suggestions to deepen my PostgreSQL knowledge and skills.
>

The Postgres website also lists books and tutorials that are not part of the project itself:

https://www.postgresql.org/docs/books/
https://www.postgresql.org/docs/online-resources/