PostGIS Tutorials some complete with data

 Almost Idiot's Guide to PostGIS (last update for PostGIS 1.4) (2009)

PGCon 2009 Spatial Analysis PostGIS  The movie (this is a big file QuickTime movie ~350MB)  Related documents and data (2009)

 OpenGeo GeoStack includes GeoServer starter guide and installing PostGIS (2009)

 Introduction to PostGIS (2009) (2009)

 Foss4G 2007 Introduction to PostGIS (2007)