06_resources.Rmd

# Resources

[DataLab's Spatial SQL Workshop](https://github.com/ucdavisdatalab/Spatial_SQL)

[W3Schools SQL Materials](https://www.w3schools.com/sql/default.asp) - This is an excellent reference for SQL syntax with a fun "try it yourself" feature.

[Sofware Carpentry's SQL Novice Workshop](http://swcarpentry.github.io/sql-novice-survey/)

[Clark Fitzgeralds & Nick Ulle's SQL Workshop](https://github.com/clarkfitzg/SQLworkshop)

[Clark Fitzgeralds & Nick Ulle's SQL Cheatsheet](https://github.com/clarkfitzg/SQLworkshop/blob/master/sql_cheatsheet.pdf)

[Lucidchart's Entity Relationship Diagrams Overview](https://www.lucidchart.com/pages/er-diagrams)


Working with SQL databases and queries in R:

* [RStudio's Database Queries with R](https://db.rstudio.com/getting-started/database-queries/)

* [University of Michigan's Stats 701 Class Notes](http://dept.stat.lsa.umich.edu/~jerrick/courses/stat701/notes/sql.html)