SQL for Natural History Collection Data: Setup

Data

Download this data to your computer: http://dx.doi.org/10.6084/m9.figshare.1314459. Click on Download all to download the zip file. Unzip it to a location that you can easily find on your computer.

About the data

The data for this lesson is a part of the Data Carpentry Ecology workshop. It is a teaching version of the Portal Database data.

The data for this lesson and the workshop are in the Portal Project Teaching Database available on FigShare, with a CC-BY license available for reuse.

Software

SQL is a specialized programming language used with databases. We use a simple database manager called SQLite in our lessons.

We will use SQLite Manager plugin for the Firefox web browser. If you don’t have Firefox installed, you need to install it first and then you will be able to add the plugin.

Windows

Mac