Recommended Tutorials

SQL

Socratica - Friendly video introduction to SQL (and it’s space themed!)

PostGIS Official Tutorial - The official guide to PostGIS, the spatial extension for Postgres (note, if you are a data team member, the example data sets are already loaded in the public schema of the Postgres Database.

Regular Expressions

Codecademy - Interactive, one-hour tutorial

regular-expressions.info - Old-school website, but super-detailed and complete

Linux Command Line AKA Bash AKA Shell

Ubuntu - A good intro to the very basics

Tip: Use RStudio on your computer to approximate the Linux command line for practicing the basics if you don’t have access to a Linux machine.

O’Reilly “Efficient Linux at the Command Line” - An advanced deep-dive (use your UW login to access for free)

Data Science at the Command Line - Another EBook that spends a lot of time using command line to enhance R & Python data science workflows.

Git

Git Access Guide - Authentication guide for our group

Git Workflow Guide - Branching guide for our group

R

GIS

sf Cheat Sheet - How to use package sf for plotting maps

Geocomputation with R - Ebook about GIS wit raster & vector data in R

R Markdown

kableExtra package - Nice-looking tables in R markdown

R Markdown Cookbook - Complete guide to R markdown

Arranging Plots/Images with Cowplot