links to investigate later

[ChristinaLK]

Database Amanda mentioned - ITIS?

• ITIS: Database of all species in North America (emphasis on United States). https://itis.gov/
• Database download files: https://itis.gov/downloads/index.html
• Very well documented data model: https://itis.gov/pdf/ITIS_ConceptualModelEntityDefinition.pdf
• As an example, each taxon is stored as a record in the database, and the actual scientific names are stored in a separate table (similarly to the ecology dataset). If you want to get the actual names of the species, you have to know how to join tables.

SQL styles: https://www.sqlstyle.guide/ - I try to remember to mention this everytime I teach!

W3 Schools: https://www.w3schools.com/sql/default.asp - this is how I originally learned SQL and always found the W3 Schools SQL information easy to navigate through and learn from

https://blog.jupyter.org/a-jupyter-kernel-for-sqlite-9549c5dcf551