Conclusion
We covered a wide variety of SQL processes you might need in setting up a database and querying data. Did we cover everything you might need to know? Of course not. It’s only a 3 hour workshop and SQL is a big language. I highly encourage you to look at the resources below to learn more and expand your SQL skills. I also welcome pull requests and submitting issues for typo fixes or ideas for additional content.
Resources
W3Schools SQL Materials - This is an excellent reference for SQL syntax with a fun “try it yourself” feature.
Sofware Carpentry’s SQL Novice Workshop
Clark Fitzgeralds & Nick Ulle’s SQL Workshop
Clark Fitzgeralds & Nick Ulle’s SQL Cheatsheet
Michele Tobias’ Spatial SQL Workshop
Lucidchart’s Entity Relationship Diagrams Overview
Diversify Data Science’s Library Checkout Database - v0.1.0-alpha
Working with SQL databases and queries in R: