sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Data Management with SQL for Ecologists
Hi, I wasn't sure the best way to go about this, so I figured I would open an issue as a discussion around it. In lesson 3: Combining Data with...
A key question that comes up when I teach this lesson is when you would use a relational database and SQL versus something object-oriented. Since we are moving from an...
In preparation for taking this workshop, I tried to create a new directory and import the .csv files in DB Browser to make sure I had everything downloaded properly, but...
The times listed for the following episode are 15 and 10 minutes for teaching and exercise. [sql-ecology-lesson](https://github.com/datacarpentry/sql-ecology-lesson)/[_episodes](https://github.com/datacarpentry/sql-ecology-lesson/tree/gh-pages/_episodes)/03-sql-joins.md My guess is closer to 1-1.5 hours but I have yet to teach...
I'm a member of The Carpentries Core Team and I'm submitting this issue on behalf of another member of the community. In most cases, I won't be able to follow...
In the 'Questions' section the text states: > First, let’s download and look at some of the cleaned spreadsheets from the Portal Project dataset. > We’ll need the following three...
from the 2021-01-05 community discussion, these themes arose, which could be added to the instructor notes or the introductory episode. - important to get to joins - important to talk...
I'm a member of The Carpentries Core Team and I'm submitting this issue on behalf of another member of the community. In most cases, I won't be able to follow...
It would be useful to provide a table (in markdown for example) which provides descriptions about how each SQL query works (as a cheat sheet) for the learners. This will...
Make the table of data types MUCH shorter + sqlite specific and add links to a full sqlite definition and other standards.