search

data-lessons / library-sql-DEPRECATED

SQLite lesson for librarians NOW MOVED > https://github.com/LibraryCarpentry/lc-sql
https://github.com/LibraryCarpentry/lc-sql
Other
2 stars 16 forks source link

Put "Why use SQL?" section on top #31

Open steltenpower opened 7 years ago

steltenpower commented 7 years ago

Reader wants "is this for me?" answered asap or might leave before

ndalyrose commented 7 years ago

Agree. The way I would personally approach teaching 01-introduction to colleagues would be in this order:

  1. How/why do Librarians use SQL? Use Cases (http://ruthtillman.com/an-introduction-to-sql-for-librarians/)
  2. Databases: From .CSV to Relational (ie: https://otherlibrarian.wordpress.com/2008/10/23/what-is-a-database-really-data-storage-for-librarians/)
  3. What is SQL?
  4. Database Management Systems
  5. Things to consider when choosing database management systems
  6. Introduction to SQLite Manager

At British Library for instance we've got a ton of curators who are holding on to local databases either in .csv or software no longer supported (like ProCite) and they're always looking for information on how to migrate this content, so I'm keen to deliver this lesson onsite!