tutorials icon indicating copy to clipboard operation
tutorials copied to clipboard

Databases tutorials(s)

Open despo opened this issue 11 years ago • 10 comments
trafficstars

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

despo avatar Jul 01 '14 12:07 despo

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

jetaggart avatar Jul 15 '14 03:07 jetaggart

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.

jkbits1 avatar Jul 15 '14 14:07 jkbits1

@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.

despo avatar Jul 17 '14 20:07 despo

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!

jkbits1 avatar Jul 19 '14 14:07 jkbits1

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 :)

jetaggart avatar Jul 19 '14 14:07 jetaggart

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

jkbits1 avatar Jul 19 '14 14:07 jkbits1

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

despo avatar Jul 19 '14 21:07 despo

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

janedallaway avatar Jul 22 '14 15:07 janedallaway

@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 avatar Jul 24 '14 21:07 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.

jkbits1 avatar Sep 14 '14 00:09 jkbits1