Databases are becoming increasingly important to research projects in the humanities. From storing to structuring to analyzing our digitized corpuses and data sets, databases provide humanists with a powerful tool to ask new questions and to discover new answers to old questions. But, where does the scholar who is new to databases begin?
This workshop will introduce you to the basics of database design for humanities research. You will learn on SQLite (http://sqlite.org), a flexible and versatile open source database engine that is the most widely deployed SQL database engine in the world.
What will you learn in this workshop
- Database concepts
- How common data manipulation/cleaning tasks can be accomplished in SQLite
- How to import vast amounts of data in SQLite
- How to query data from SQLite
- How to use SQLite’s full feature set (e.g. full-text search and geospatial data store) to simplify analysis
What will you need?
- A personal laptop with internet connection
- Data used for the demonstration will be provided. You are welcome to bring your own data sets