Using Relational Databases
Adam Brazier
Cornell Center for Advanced Computing
8/2022 (original)
Relational databases do not exist in isolation, but are generally incorporated into workflows. In this topic, we examine how they can be used in practice, including some advice on constructing queries.
Objectives
After you complete this topic, you should be able to:
- Plan how to incorporate relational databases into your workflow
- Be confident in putting a query together to serve your workflow needs
- Improve performance on key database operations
Prerequisites
Getting the most out of this topic will require
- An understanding of basic SQL
- Experience with workflows