sql-ecology-lesson icon indicating copy to clipboard operation
sql-ecology-lesson copied to clipboard

Potentially add a module on 'Using SQL with your own data'

Open tracykteal opened this issue 10 years ago • 3 comments

This module would be the last one and would discuss how to use SQL with your own data. It could

  • Emphasize that SQLite is fine for their own work
  • Give an overview of what they would do, i.e. import your own CSV files like we did here
  • List the potential limitations of SQLite
  • List other database types and some of their strengths/weaknesses (not overwhelmingly technical, more just like "handles databases up to 10GB well", "is good for multiple users", "need access to a Linux server to use and install", "command line interface only")
  • Discuss that once a database is created, you can connect to it through other languages like R or Python (and that we'll demonstrate that in the capstone)
  • Have some links to materials or info on good database design

tracykteal avatar Aug 20 '15 22:08 tracykteal

Could some it be done as a capstone on "From Excel to SQL"? I'll have to write that (tentatively) for a course I'm giving.

tpoisot avatar Mar 03 '16 20:03 tpoisot

:+1: @tpoisot if your doing this anyway and would like to contribute it I think that would be awesome!

ethanwhite avatar Mar 04 '16 13:03 ethanwhite

Right, I'll do, but it might take a while. I.e. until I start preparing this class of mine.

tpoisot avatar Mar 04 '16 19:03 tpoisot