SQL for Ecology

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. 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. 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. If you are teaching this lesson in a workshop, please see the
Instructor notes.

Remote updated date: 2017-10-09

SQL for Ecology https://tess.elixir-europe.org/materials/data-carpentry-sql-for-ecology 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. 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. 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. If you are teaching this lesson in a workshop, please see the Instructor notes. 2017-10-09