In addition to the videos linked in the last post I have found the following to help me along the way to learning SQL.

About.com has a good resource of SQL articles

 

This website looks useful – http://beginner-sql-tutorial.com/sql-delete-statement.htm

Some lecture slides on databases and SQL for GIS. An interesting summary with a link at the end to a tutorial website – http://atlantic.evsc.virginia.edu/~jhp7e/advgis/local/2007/Data_model_SQLIntro07.pdf

I found this online book about learning SQL  – http://sql.learncodethehardway.org/book/ – it looks like it is aimed at an advanced beginner with some previous knowledge. There is a similar book in the series which covers the language Python which is also used by ArcGIS – http://learnpythonthehardway.org/book/

The book recommends the SQLite database software for learning SQL with. So that’s what I will be working with. Hopefully it will teach me general database skills and I can still apply the SQL back to GIS. http://sqlite.org

Advertisements