sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Data Management with SQL for Ecologists
### What is the problem? In the [Database Design](https://datacarpentry.org/sql-ecology-lesson/discuss.html#proposed-episode-on-database-design) section, it looks like the sections "Naming conventions are important because" and "Names should adhere to certain standards" should have indented...
### How could the content be improved? A `SELECT` query never modifies the source table. [In this lesson](https://datacarpentry.org/sql-ecology-lesson/01-sql-basic-queries.html#calculated-values) we say "When we run the query, the expression weight / 1000...
### How could the content be improved? In the [installation instructions](https://datacarpentry.org/sql-ecology-lesson/#software) we note there are several options for Windows installation and we make a recommendation for what should work for...
### How could the content be improved? In this section we say to click on the "Open Database" button but we don't say this is in DB Browser for SQLite....
Based on the nice suggested change of @chbrandt in #353, since the block on "relational database" is somewhat vague and confusing. --------- Co-authored-by: Carlos H Brandt
Hi, I thoroughly enjoyed the lesson on left join and inner join. It provided a clear understanding of these concepts. However, I would love to see the `right join` and...
Hi! I wanted to make a suggestion for the https://datacarpentry.org/sql-ecology-lesson/03-sql-joins/index.html Combining Data with Joins episode. In the first part of this lesson https://datacarpentry.org/sql-ecology-lesson/00-sql-introduction/index.html , there is some mention of primary...
The Learner Profiles link in the top bar of the lesson currently resolves to a placeholder file. The [definition for the placeholder file](https://carpentries.github.io/sandpaper-docs/editing.html#profiles) is not very informative, but here are...