As the adoption of relational and deeply curated ‘omics databases increases, creating SQL queries has become a mandatory skill rather than a desirable one. For part 1 of this series, we will equip you with the know-how and best practices around designing SQL queries – no prior experience required.
While we will use QIAGEN biomedical databases, the knowledge you acquire can be easily applied to other databases. We will cover:
- SQL basics
- A brief overview of the knowledge databases to be used
- How to design queries to help you answer scientific questions, e.g. related to disease pathology, MOA, drug response, gene signatures and more
- Some applications and frequently asked questions
- Resources