PostgreSQL Tutorial in docs The PostgreSQL docs are a great place to learn about Postgres, and the PostgreSQL Tutorial is the place to start.
Postgresql tutorial site General introduction to PostgreSQL for beginners
Postgres guide Covers fundamentals of setup, general SQL, backups, common tools, and Postgres specific tips. Also covers advanced features like HStore, arrays, JSON, and understanding performance.
- PostgreSQL Tutorial in detail
- Part 1: Getting Started With PostGIS: An almost Idiot's Guide: Walks you thru how to configure PostGIS, Load data, and do common spatial queries.
- Crunchy Data Postgres tutorials: Variety of topics from getting started to functions, CTEs, window functions. All tutorials runs in a local web browser.