== PostGIS Tutorials some complete with data ==
[http://s3.opengeo.org/postgis-power.pdf PostGIS for Power Users slides][http://www.fosslc.org/drupal/content/tips-postgis-power-user video] Paul Ramsey -- FOSS4G2011

[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://workshops.opengeo.org/postgis-intro/ Introduction to PostGIS], [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 
[http://wiki.postgresql.org/images/2/2e/Postgis_vincent_picavet_pgdayEU2010.pdf 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 [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]

== Videos History of PostGIS and its feature set ==
 * [http://www.ustream.tv/recorded/10667125 Foss4G JP 2010 State of PostGIS video] by Paul Ramsey
 * [http://blip.tv/file/2788616/ Foss4G 2009 State of PostGIS video] by Paul Ramsey