Resources - Links and Literature

Collection of links and resources for individual study

E-Learning

Introduction to Database Systems
Structured Query Language SQL
Database Systems: Concepts and Architectures
The relational database model
Spatial Queries

Links

Online SQL Tutorials

Wikibooks SQL resource
Learn SQL online with a game
Tutorial from Jürgen Auer (in German)
Another source of SQL recipes
And another online resource... with online executable editor

PostgreSQL

PostgreSQL DBMS Documentation (see Part II "The SQL Language")
All PostgreSQL SQL commands
Type conversion and date time formatting

PostGIS

PostGIS DBMS Documentation
Tutorial: Introduction to PostGIS (spatial database, highly recommended)

Well Known Text Format (WKT)

Tool to convert WKB to WKT to GeoJSON
Visualizing WKT

Clients for PostgreSQL

DBeaver Community (open source, free, nice, intuitive tool; even more database types supported)
pgAdmin for PostgreSQL (open source)

Indices

Animations of many basic (mostly non-spatial) algorithms, including B and B+ trees.

Literature

• Fundamentals of Database Systems, 7th edition (2016)
  R. Elmasri and S. Navathe, Pearson, pp. 1081
  ISBN 978-1-292-02560-5
• PostGIS in Action, Third Edition (2021) (highly recommended)
  Regina O. Obe and Leo S. Hsu, Manning Publications, pp. 600
  ISBN 9780133971118; https://www.manning.com/books/postgis-in-action-third-edition
• GIS: a computing perspective (2004)
  M. F. Worboys and M. Duckham. CRC press, 2nd edition. pp. 431.
  ISBN 978-0415283755
• Spatial Database Systems:
  Design, Implementation and Project Management (2007)
  Albert K.W. Yeung, G. Brent Hall, Springer, New York, pp. 554.
  ISBN 1402053916, Softcover $ 98.00
• Spatial databases a tour (2003)
  S. Shekhar and S. Chawla, Prentice Hall, Upper Saddle River, pp. 262.
  ISBN 0-13-017480-7, CHF 80.00
• Geographical information systems and computer cartography (1997)
  C. B. Jones, Longman, Harlow, pp. 319.
  ISBN 0-582-04439-1
• Spatial databases: with application to GIS (2002)
  P. Rigaux, M. O. Scholl and A. Voisard, Morgan Kaufmann Publishers, San Francisco, pp. xxix, 410 p.
  ISBN 1558605886, CHF 108.00
• Entity relationship modelling (1991)
  R. Barker, Addison-Wesley etc., Wokingham, England etc., ed. Third printing.
  ISBN 0-201-41696-4
• Modeling our world the ESRI guide to geodatabase design (1999)
  M. Zeiler, ESRI Press, Redlands, California, pp. 199.
  ISBN 1-879102-62-5
• Designing Geodatabases (2004)
  D. Arctur, ESRI Press, Redlands, California, pp. 199.
  ISBN 1-58948-021-X