Ethan White

Add exercises on Googling for Help

6

* Reinforce the skills * Identify issues with material Suggested by @TrashBirdEcology

Create a data or spreadsheet language

10

Some topics really are just about data related things, not SQL. Either rename to "spreadsheets" or the like or just use "Data"

There's a lot of content so it would be good to make it easier for folks to find topics of interest.

Improve discussion of primary keys

2

Primary keys are always a big question. We should modify the lecture material to include clear (but short) explanation of why they are important and emphasize that every table should...

E.g., https://blog.rstudio.org/2017/06/27/dbplyr-1-1-0/

Add detailed docs on contributing upstream

1

See #619 and #620 for motivation and draft of language/approach.

I added this to r-functions this year not remembering that it was being used in r-iteration-1. It should be moved back at the end of this semester.

This will make setup easy for folks for either teachers using a managed environment or students working in a non-managed environment and will achieve some of the same educational benefits...

Installation failing on Python 3.12 due to removal of imp package

2

```sh conda create -n retriever-test python=3 conda activate retriever-test pip install retriever retriever ls ``` ``` Traceback (most recent call last): File "/home/ethan/miniconda3/envs/retriever-test/bin/retriever", line 5, in from retriever.__main__ import main...