Databases tutorials(s)

[despo]

• relational vs nosql
• sql basics
• creating and managing DBs
• keep required setup minimum: use sqlite?

[jetaggart]

Are you a non-profit? Check out: https://github.com/gSchool/sql-query-exercise

[jkbits1]

The relational sql tutorials themselves look good, they start simply and then steadily become more complex. Also, it should be straightforward to convert them to environments other than psql, such as sqlite.

[despo]

@jetaggart yes we are. Thanks for pointing this out.
@jkbits1 sqlite makes sense as setting up PG can be a bit time consuming. It should be quite straightforward.

[jkbits1]

I'll try out installing the gSchool tables in sqlite, and create the answers to some of the exercises. I can create some headers for a tutorial, and write some instructions, but I'll welcome some assistance in making the text sound as friendly and interesting as the existing codebar tutorials!

[jetaggart]

Awesome, the only thing the license requires is attribution and non-commercial. If you guys fork, just include a NOTICE or a mention on the site :)

[jkbits1]

@jetaggart Thanks for clarifying this, I saw from the gSchool repo that it's licensed as creative commons.

[despo]

@jkbits1 I can help with that, just ping me or send me an email.

[janedallaway]

@jkbits1 also happy to help out with "plain english"ing tutorials

[jkbits1]

@despo That's great, thanks.
@janedallaway Thanks for the offer, it's much appreciated. Once the tutorial reaches some kind of steady state, it will definitely need a review from a variety of perspectives.

[jkbits1]

A draft tutorial has been created and raised as a PR in #129.

There is a little more about the file in the PR and some caveats about spending too much time on it right now. If more info is needed, just get in touch.