Introduction to SQL and Geospatial Data Processing

These lessons are based on the templates used in Data Carpentry and Software Carpentry workshops.

Schedule

Setup Download files required for the lesson
09:00 Initial Exercise What tools would you use to solve some typical data queries?
09:15 Introduction to Databases What is a database?
How are data structured within a database?
What are the advantages of working with data in a database?
09:30 Database Connection How do I connect to a cloud-based relational database?
09:45 SQL Queries How do I extract information from a table in a database?
How can I create summary statistics of a data set?
How can I combine information from several tables?
10:45 Geospatial Queries What are the various ways that we can represent geospatial information?
How does a database store spatial information?
11:30 Mapping How do I plot the results of spatial queries on a map?
12:00 Scripting database connections in Python/R How do we issue database queries from a Python or R script?
12:30 Advanced Geospatial Queries
13:30 Finish