Where to learn PostgreSQL
Published on October 04, 2022 by Stefanie Janine Stölting
PostgreSQL postgres Learning
2 min READ
There are tons of blogs about PostgreSQL available on the web, including this one. There are some good opportunities, where you can learn PostgreSQL as a developer or DBA, but a good starting point is always the original PostgreSQL Documentation.
If you are not sure about something, for example the parameters of a function, or tools like psql, the documentation almost always has the answer.
There are some websites available, where you can learn PostgreSQL for free. There is a list available on postgresql.org.
It’s perfect to either, walk through the lessons one by one, or just learn something, that you needs right now.
Everything there is shown and explained with examples.
This is done by Crunchy Data, one of the bigger players in the PostgreSQL ecosystem.
It is not just another tutorial, it is a PostgreSQL shell in a browser. You will learn by following the tutorial and by testing everything right in a web-browser, solving the problem, to first install PostgreSQL somewhere local.
At Udemy you pay for video courses, some of them are really good. If your employer does not already have an account at Udemy enabling you to learn for free, they have special offers very regularly.
Here is a list of PostgreSQL courses at Udemy.
There are some really good books around PostgreSQL on the market. An overview of books can be found on postgresql.org.
When I am giving trainings, the following ones are always on my list.
Even if it is not covering actual PosgreSQL versions, PostgreSQL: Up and Running book by Regina Obe and Leo Hsu is still a very good book for beginners. It is already the third edition.
Regina Obe is also very well known in the PostgreSQL community for her engagement into PostGIS.
PostgreSQL 14 Administration Cookbook by Simon Riggs and Gianny Ciolly, both very well known persons in the PostgreSQL community, is offering several good recipes, that can be used without hesitation.
This is the latest version of the cookbook, new versions are usually published some time after new PostgreSQL versions have been released.
In contrast to the other two books, The Art of PostgreSQL by Dimitri Fontaine covers the needs of developers with a lot of practical solutions in SQL. The author is also very well known in the PostgreSQL community.
Learn to handle query data with A Curious Moon by Rob Conery. This is not directly about PostgreSQL, but it uses it throughout showing you, how to work with data using SQL.
There are some resources, where you might get a good support, if you stumble upon any problems.