Construct intermediate SQL lesson.

[gvwilson]

Construct lesson on SQL for intermediates in sql/intermediate.

[wking]

Dup of #129 (also Construct intermediate SQL lesson).

[wking]

On Sat, Nov 02, 2013 at 09:31:52AM -0700, W. Trevor King wrote:

Dup of #129 (also Construct intermediate SQL lesson).

Never mind, looks like Python got inserted as #128, and my following
along via email didn't pick up on the change.

[ethanwhite]

Do we want an intermediate SQL lesson and what would it contain?

As with the idea of the intermediate shell lesson (#126) it's not clear to me whether or not we really need an intermediate SQL lesson. It's easy to get through all of the basics including filtering, sorting, aggregation, joins, etc. in a short afternoon with compete novices, so I guess the next step would either be 1) teaching nested queries or 2) showing students how to interact with SQL from inside Python/R (this is definitely something I get asked about a lot when teaching SQL at bootcamps). The question is whether either of these is in scope and something that a decent number of learners would want in a bootcamp.

[1] http://software-carpentry.org/blog/2013/11/scope.html

[gvwilson]

On 2013-11-13 4:35 PM, Ethan White wrote:

Do we want an intermediate SQL lesson and what would it contain?

I would like more material on how to design a database, i.e., how to
decide what tables to have, what fields and relationships they should
embody, etc. We get asked for this pretty often...

[ethanwhite]

Oooh, yes, database structure. That would definitely be a good thing
to have as the core of an intermediate lecture. Good call Greg!

[ethanwhite]

Material to include for Intermediate SQL:

1. Database structure
2. Nested queries
3. Interacting with databases from inside Python/R

What else should be in here?

[wking]

On Tue, Jan 14, 2014 at 01:47:26PM -0800, Ethan White wrote:

What else should be in here?

Migrations?