search

swcarpentry / DEPRECATED-bc

DEPRECATED: This repository is now frozen - please see individual lesson repositories.
Other
299 stars 382 forks source link

Feedback to be incorporated into novice SQL lesson #332

Closed gvwilson closed 8 years ago

gvwilson commented 10 years ago
  1. The concepts of keys and relationships between tables is introduced far too late in the materials. There is also very little explanation on what a database is, why there would be multiple tables.
  2. This way, by the time we got to 'Combining data', learners won't be introduced to a whole new abstract concept on data organization and a new command. They already had this concept in their minds as they used and explored the tables for other exercises. Learning JOIN just showed them how to use this relationship in a query.
  3. The idea of keys/multiple tables really sets apart databases from a simple spreadsheet and can be a good motivation to keep learning. Introducing this earlier also gave us a chance to revisit this important concept again when we got to 'Combining data'.
gvwilson commented 10 years ago

All of this needs to be checked against the lessons, as the feedback came in several months ago.

MjStrwy commented 10 years ago

Jeremiah Lant and I are interested in tackling this issue for the Software Carpentry Instructor Course.