Comprehensive PostgreSQL tutorial: setup, psql, data types, queries, JSON, views and administration.
PostgreSQL from zero: install, psql, tables, queries, JSON, views, functions and administration.