Data Carpentry SQL for Ecology

Data Carpentry’s aim is to teach researchers basic concepts, skills, and tools for working with data so that they can get more done in less time, and with less pain. The lessons below were designed for those interested in working with Ecology data in SQL.

Content Contributors: Ethan White, Greg Wilson, Josh Herr, Sophie Clayton, Tracy Teal, Aleksandra Pawlik

Lesson Maintainers: Paula Andrea Martinez, Timothée Poisot

Lesson status: Teaching


  1. Lesson 00 Introduction to SQL

  2. Lesson 01 Basic queries

  3. Lesson 02 Aggregation

  4. Lesson 03 Joins and aliases


Data files for the workshop are available here:


Data Carpentry's teaching is hands-on, so participants are encouraged to use their own computers to ensure the proper setup of tools for an efficient workflow. These lessons assume no prior knowledge of the skills or tools, but working through this lesson requires working copies of the software described below. To most effectively use these materials, please make sure to install everything before working through this lesson.


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 Firefox. If you don't have Firefox installed, you need to install it first and then you will be able to add the plugin.

Twitter: @datacarpentry