Tutorials and Resources

Postgres/SQL

Postgres(PostgreSQL) is an open-source relational database. GeoDeepDive uses it for managing input data for applications, and it is highly recommended, but not required, for application users.

• W3 Schools SQL tutorial - a nice introduction to the SQL language used in Postgres
• Offical PostgreSQL tutorial - A comprehensive tutorial of SQL as well as specific features of Postgres
• A beginner's guide to SQL - A friendly introduction to SQL
• Postgres.app - The easiest way to install Postgres on OS X
• Postico - A graphical client for Postgres on OS X
• Codecademy SQL course - A free three hour course that introduces SQL

git

git is an open-source distributed system for managing code versioning. Github is a hosted graphical interface for git repositories. GeoDeepDive uses git and Github for managing all code and also as a collaboration and communication tool.

• Git Basics - Official git introduction
• A Non-Programmer's Introduction to Git
• Think like a git - a tutorial for advanced beginners still getting started with git
• Try git - an interactive tutorial for git
• Github Hello World - quick introduction to using git with github
• Introduction to git and github - A tutorial written by Andrew Zaffos for the Paleobiology class at the University of Wisconsin
• Codecademy git course - a free two hour introduction to using git

NLP

NLP, or Natural Language Processing, is the automated processing and parsing of raw text into structured data. GeoDeepDive uses various versions of Stanford CoreNLP to parse all input texts.

• About Stanford CoreNLP - General information about Stanford CoreNLP
• CoreNLP demo - interactive web application that demonstrates the parsing of user-defined input