This page lists the presentations we have given on the topic of PostGIS as well as the associated media.
Basics of OGC WMS/WFS services. Various open source mapping servers out there that support PostGIS. Proximity queries with PostGIS geography. Using OpenLayers and GeoExt. Using Mapserver. Using GeoServer. Using OpenStreetMap as a base layer in OpenLayers.
An intro course to PostGIS covered loading data with pgsql2shp, loading CSV data using PostgreSQL Copy command, PgRouting, viewing PostGIS data with OpenJump and QuantumGIS. Leo was very brave and did a live demonstration of everything sans slides. So unfortunately no slides for this you just had to be there. We'll have the code examples here in a bit.