Competency information
Details
Identify a database containing health or exposure data and extract the relevant fields from multiple tables within the database to answer a specific question using Structured Query Language (SQL).
Considerations
- Common identifiers and fields to link data sets.
- Relational databases.
- Principles of database structure and formats.
- How to write a script using a common programming language.
- Import and Export Wizard, SQL.
- Table relationships/joins (covered by selecting from multiple tables).
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 2 | Outcome Extract, import and manipulate data within a data set. |