PostGIS Tutorials some complete with data

 PostGIS for Power Users slides video Paul Ramsey -- FOSS4G2011

 PostGIS database sandbox and tutorials Provides step by step interactive tutorial for experimenting with PostGIS Spatial SQL in a database sandbox. You can also type in spatial SQL statements you find in the PostGIS manual and see them rendered on a map.

 Introduction to PostGIS,  Tips for the PostGIS Power User (FOSS4G 2010 - Paul Ramsey)

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

 Spatial database tips and tricks Covers PostGIS , SQL server 2008 Spatial and Oracle but focus on PostGIS

PGDay Europe 2010 PostGIS Talks

 PostGIS - das Wo? in der Datenbank Talk by Stefan Kellar showing use of OpenStreetMap in a Box and some samplings of PostGIS queries, new PostGIS Raster support, and using PostGIS with GeoServer? and OpenLayers?  PostGIS, a PostgreSQL module for spatial data Talk by Vincent Picavet provides some examples of outputting geometries in KML, WKT of different geometry types supported in PostGIS 2.0 including Polyhedral Surfaces, history of PostGIS

Integrating PostGIS in Web Applications (PG Con East 2010 - Leo hsu and Regina Obe)

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.

PGCon 2009 Spatial Analysis PostGIS (2009)

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

 Introduction to PostGIS (2009) (2009)

 Foss4G 2007 Introduction to PostGIS (2007)

RASTER TUTORIALS (using new PostGIS raster datatype and functions)

Videos History of PostGIS and its feature set

Web Mapping, Road Routing and other use case examples