sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Data Management with SQL for Ecologists
I'm interested in how people have taught the first episode of this lesson and how it's gone. Does the order make sense? Are learners bored out of their minds? What...
I suggest to split the **COUNT and GROUP BY** section. When I did the lesson, I was a confused because there is `GROUP BY` in the title, and the first...
In 03-sql-joins, I am confused by the inclusion of the the challenge within the JOINING episode: > Count the number of records in the surveys table that have a NULL...
https://twitter.com/b0rk/status/1179449535938076673?s=21 Might be a good comic to reference depending on the license.
1. **Suggestion to change** > In particular, we want to use a tool where it’s easy to repeat our analysis in case our data changes. into > In particular, we...
In episode 02, the section introducing HAVING starts using COUNT(species_id) instead of COUNT( * ), but the distinction between those two forms (how they treat NULL) is only explained later...
This is referring to the material in Episode 3 (https://datacarpentry.org/sql-ecology-lesson/03-sql-joins/index.html). In my experience with SQL it seems that the logical progression to introduce JOINs is to first introduce SELECT statements...
It would be helpful to add a quick description of some of the statements used. Mainly the select statement since I know when I first started I had concerns on...
In the **Getting started** box, I suggest to reorganize the sentences a bit to fluidify the text: # Prerequisites This lesson requires a working copy of **DB Browser for SQLite...
When learning to write my first queries, I was missing a couple of information, which are given in later. 1. **The ";"** I would be good to explain what is...