Data Management with SQL for Ecologists: Setup


Download this data to your computer: 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.


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

We will use the DB Browser for SQLite program, which is available for all major platforms.