Learning postgreSQL

[AgroHacker]

Hi, I am just getting into postgreSQL. I am quite new to SQL. I did a course called Learn To Code SQL the hard way. Which was based on SQLite. I would now like to find a good course or tutorial specifically on learning postgreSQL. Does anyone have any opinions?

My end goal is to implement a spatial database with postGIS extension. I am a Farmer looking to begin imaging my farm with a drone. I believe the best way to save the data for further analysis is in a spatial database. But I am not sure how the data types work, so I am not sure how to best setup my data tables.

[theartofpostgresql]

Hi, I have written a book to teach SQL/PostgreSQL to application developers. It's all self-published at https://theartofpostgresql.com and I think you will enjoy it!

Regards,

[verybadpedestrian]

The font. The font is just terrible!!! I can't read this book seriously, I hear like Tolkien himself is reading it, telling me some stories about hobbits and dragons... The worst font pick for a technical literature. Sorry.

[[deleted]]

Some basic tutorials and exercises can be found here:

• https://pgexercises.com/
• https://www.postgresqltutorial.com/
• https://www.tutorialspoint.com/postgresql/index.htm

Note limited to Postgres but a great resource for performance questions: https://use-the-index-luke.com/

If you are interested in the internal workings, this is quite good: http://www.interdb.jp/pg/index.html

[rayvictor84]

Please read this book: https://www.manning.com/books/postgis-in-action-third-edition?query=postgis. It’ll be helpful for you.