sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Data Management with SQL for Ecologists
I was confused by the example on aliasing at the end of **03-sql-joins**. I don't think that changing all by-now remembered tables and field names is making the query _clearer_,...
Re: https://datacarpentry.org/sql-ecology-lesson/00-sql-introduction/index.html The lesson includes two Objectives: * Select, group, add to, an analyze subsets of data, and * Combine data across multiple tables; which are not covered in this...
This issue springs from discussion of pull request #99 in which @heereman wrote a definition of a relational database, and @orchid00 and I thought it might be a good idea...
It could be useful to add three or more tables join example in the lesson. e.g The query performs two JOIN operations with 3 tables.
This module would be the last one and would discuss how to use SQL with your own data. It could - Emphasize that SQLite is fine for their own work...
This refers to lesson: http://www.datacarpentry.org/sql-ecology-lesson/03-sql-joins/ When I teach SQL, one thing I try to emphasize soon after introducing the INNER JOIN syntax is to tie back to a more familiar...
In the lesson on aggregation (http://www.datacarpentry.org/sql-ecology-lesson/02-sql-aggregation/), the GROUP BY syntax is introduced so that students can learn how to apply aggregate functions, not to an entire result set (the default...
_If this pull request addresses an open issue on the repository, please add 'Closes #NN' below, where NN is the issue number._ - Closes #370 - Closes #372 - Closes...
:robot: This is an automated build Update Workflows from sandpaper version 0.16.9 -> 0.16.12 - Auto-generated by [create-pull-request][1] on 2025-05-13T00:32+00:00 [1]: https://github.com/carpentries/create-pull-request/tree/main
_If this pull request addresses an open issue on the repository, please add 'Closes #NN' below, where NN is the issue number._ Closes #316 _Please briefly summarise the changes made...
