swc-sql.git
10 years agoFilling in another 40-odd glossary entries
Greg Wilson [Tue, 3 Dec 2013 14:06:32 +0000 (09:06 -0500)]
Filling in another 40-odd glossary entries

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

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

10 years agoFilling in glossary entries
Greg Wilson [Mon, 2 Dec 2013 21:03:39 +0000 (16:03 -0500)]
Filling in glossary entries

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

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

10 years agoSQL reference sheet
Greg Wilson [Sat, 30 Nov 2013 17:07:50 +0000 (12:07 -0500)]
SQL reference sheet

10 years agoUpdating SQL notes and guide
Greg Wilson [Fri, 29 Nov 2013 20:21:39 +0000 (15:21 -0500)]
Updating SQL notes and guide

10 years agoInstructor's guide for Python
Greg Wilson [Fri, 29 Nov 2013 20:04:47 +0000 (15:04 -0500)]
Instructor's guide for Python

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

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

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