PostGIS Tutorials some complete with data

​Almost Idiot's Guide to PostGIS (last update for PostGIS 1.5) (2010)

Integrating PostGIS in Web Applications (PG Con East 2010)

This covered using ​OpenLayers, OpenStreetMap Layers, brief intro to ​GeoExt, setting up ​Mapserver and ​GeoServer as OGC WFS/WMS services. Reverse proxy for ASP.NET that can be used for any kind of WMS/WFS server (VB.NET, C#). Roll your own solution using PostGIS ST_AsKML, ST_AsGeoJSON functions.

• ​Inetgrating PostGIS in Web Applications slides (2010)

PGCon 2009 Spatial Analysis PostGIS (2009)

• ​The movie (this is a big file QuickTime movie ~350MB)
• ​Related documents and data

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

​Introduction to PostGIS (2009) (2009)

​Foss4G 2007 Introduction to PostGIS (2007)