Data Management with SQL for Ecologists

Databases are useful for both storing and using data effectively. Using a relational database serves several purposes.

This lesson will teach you what relational databases are, how you can load data into them and how you can query databases to extract just the information that you need.

Getting Started

Data Carpentry’s teaching is hands-on, so participants are encouraged to use their own computers to insure the proper setup of tools for an efficient workflow.
These lessons assume no prior knowledge of the skills or tools.

To get started, follow the directions in the “Setup” tab to download data to your computer and follow any installation instructions.

Prerequisites

This lesson requires a working copy of DB Browser for SQLite for SQL.
To most effectively use these materials, please make sure to install everything before working through this lesson.

For Instructors

If you are teaching this lesson in a workshop, please see the Instructor notes.

Schedule

Setup Download files required for the lesson
00:00 1. Introducing Databases and SQL What is a relational database and why should I use it?
What is SQL?
01:05 2. Accessing Data With Queries How do I write a basic query in SQL?
01:40 3. Aggregating and Grouping Data How can I summarize my data by aggregating, filtering, or ordering query results?
How can I make sure column names from my queries make sense and aren’t too long?
02:40 4. Combining Data With Joins How do I bring data together from separate tables?
03:05 Finish

The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.