sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Data Management with SQL for Ecologists
I'm a member of The Carpentries staff and I'm submitting this issue on behalf of another member of the community. In most cases, I won't be able to follow up...
Past - [x] Coordinate w/ maintainers to see if anyone else wants to tackle a specific project - no replies, so will continue onward for now. - [x] Host 1-2...
Hi all! Please let us know if you are teaching this lesson by copying the info below and replying to this issue. > Name: > Institution: > Date Taught: >...
Are you interested in contributing to this lesson? See some of the suggestions below for where to get started, depending on your interest. Have you taught this lesson recently? *...
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:...
It could be useful to add diagrams for WHERE and JOIN statements. For WHERE we can have boxes that show the selection of subsets of the data. For JOIN there...
* views * aliases * IFNULL
This is referring to the material in Episode 2 http://datacarpentry.org/sql-ecology-lesson/01-sql-basic-queries/index.html Problem - For this chapter - Basic Queries, its objectives (including the title) do not match the content therein. There...
Especially in the aggregation section, but maybe also in basic queries.
- [ ] episode 1 - [ ] episode 2 - [ ] episode 3 - [ ] episode 4