== PostGIS Tutorials some complete with data ==
[http://www.postgisonline.org 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. 

[http://s3.opengeo.org/postgis-power.pdf Tips for the PostGIS Power User] (FOSS4G 2010 - Paul Ramsey)

[http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Almost Idiot's Guide to PostGIS (last update for PostGIS 1.5)] (2010)

[http://workshops.opengeo.org/postgis-spatialdbtips/ Spatial database tips and tricks]  Covers PostGIS , SQL server 2008 Spatial and Oracle  but focus on PostGIS

'''PGDay Europe 2010 PostGIS Talks'''

[http://wiki.postgresql.org/images/3/31/Postgis_das_wo_in_der_datenbank_pgday_eu_2010.pdf  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 


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

This covered using [http://www.openlayers.org OpenLayers], [http://www.openstreetmap.org OpenStreetMap] Layers, brief intro to [http://geoext.org GeoExt], setting up [http://mapserver.org Mapserver] and [http://geoserver.org 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.
 * [http://www.postgis.us/downloads/pgconeast2010/pgconeast2010_postgiswebapps.pdf Integrating PostGIS in Web Applications slides] (2010)

PGCon 2009 Spatial Analysis PostGIS (2009)
  * [http://media.postgresql.org/pgcon2009/sessions/0521/pgcon2009-sessions-spatial.mov The movie (this is a big file QuickTime movie ~350MB)]  
  * [http://www.pgcon.org/2009/schedule/events/174.en.html Related documents and data] 

[http://workshops.opengeo.org/stack-intro/ OpenGeo GeoStack includes GeoServer starter guide and installing PostGIS] (2009)

[http://revenant.ca/www/postgis/workshop/ Introduction to PostGIS (2009)] (2009)

[http://2007.foss4g.org/workshops/W-04/ Foss4G 2007 Introduction to PostGIS] (2007)

== RASTER TUTORIALS (using new PostGIS raster datatype and functions) ==
 * [wiki:WKTRasterTutorial01 Tutorial 1 - Intersecting vector polygons with large raster coverage using PostGIS Raster]
 * [http://gis4free.wordpress.com/category/postgis-raster/ Jorge's PostGIS Raster tutorials and compare with Oracle GeoRaster]