SQlTrainingDOH

Links and resources for the Project ECHO and DOH joint training sessions

Week 1 links:

SQLite Online- https://sqliteonline.com/

SQLite Online with Northwind DBs loaded- https://sqliteonline.com/#urldb=https://raw.githubusercontent.com/jpwhite3/northwind-SQLite3/master/dist/northwind.db

Northwind- https://en.wikiversity.org/wiki/Database_Examples/Northwind/

Week 2 Links:

SQLite Online with Northwind DBs loaded- https://sqliteonline.com/#urldb=https://raw.githubusercontent.com/jpwhite3/northwind-SQLite3/master/dist/northwind.db

Additonal resources:

[Book] H.Garcia-Molina, J.Ullman, and J.Widom, “Database Systems: The Complete Book”, 2nd Edition, Pearson, 2008.

First two chapters available: http://infolab.stanford.edu/~ullman/dscb.html

[IBM1] https://www.ibm.com/docs/en/zos-basic-skills?topic=zos-what-is-database-management-system

[IBM2] “What is a relational database?”, https://www.ibm.com/topics/relational-databases#:~:text=the%20next%20step-,What%20is%20a%20relational%20database%3F,key%20or%20a%20foreign%20key

[MongoDB] https://www.mongodb.com/basics/acid-transactions

[Wiki] https://en.wikiversity.org/wiki/Database_Examples/Northwind

If looking to manipulate your own data on your local: https://cran.r-project.org/bin/windows/base/ https://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html