swc-sql.git
10 years agoInstructor's guide for SQL
Greg Wilson [Fri, 29 Nov 2013 19:53:36 +0000 (14:53 -0500)]
Instructor's guide for SQL

10 years agoUpdating index files
Greg Wilson [Fri, 29 Nov 2013 15:15:17 +0000 (10:15 -0500)]
Updating index files

W. Trevor King: I removed everything except the sql/novice changes
from the original b23e277 [1].

[1]: https://github.com/swcarpentry/bc/commit/b23e2772153844b1d8e1ee09b439653847a05ede

10 years agoModfiying links to glossary in notebook files
Greg Wilson [Fri, 22 Nov 2013 15:09:43 +0000 (10:09 -0500)]
Modfiying links to glossary in notebook files

W. Trevor King: I removed the python/ changes from the original
bac4388 [1] as I try to isolate the SQL section.

[1]: https://github.com/swcarpentry/bc/commit/bac43889abf296672bb1dc018bcd8b53eb18dc9f

10 years agoCleaning up before submitting pull request
Greg Wilson [Sun, 10 Nov 2013 14:17:00 +0000 (09:17 -0500)]
Cleaning up before submitting pull request

10 years ago1. Filled in 'group by'.
Greg Wilson [Sun, 10 Nov 2013 13:18:08 +0000 (08:18 -0500)]
1. Filled in 'group by'.
2. Put data hygiene in discussion of joins.
3. Got rid of 'next steps' sections.

10 years agoMore database lessons for novices. To do:
Greg Wilson [Sun, 10 Nov 2013 10:30:52 +0000 (05:30 -0500)]
More database lessons for novices.  To do:
*   `group by` in aggregation
*   data hygiene
*   explain the `%%sqlite` magic

10 years agoFirst three lessons on SQL for beginners
Greg Wilson [Sat, 9 Nov 2013 16:43:13 +0000 (11:43 -0500)]
First three lessons on SQL for beginners