Stanford Hands-on SQL Workshop: 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 the DB Browser for SQLite program, which is available for all major platforms.