Data that we need to utilize and query is often stored in data sources such as databases or data warehouses. In this course, you will learn how to connect and query databases using Structured Query Language (SQL). In particular, we will focus on querying data in a commonly used data model for storing patient data called OMOP. By the end of this course, you will be prepared to construct complex queries to retrieve large data sets.
Quarters Offered: Fall 2025, Winter 2026
Dates: Winter 2026: Feb 6, 13, 27, March 6
Time: Fridays Noon - 1:30pm PT
Time commitment: 4 weeks of 1.5 hour classes and 1-2 hours of practice outside class.
Audience: Researchers and clinical staff who need to work with large databases to extract data for analysis.
Prerequisites: None
Followed by: None
Explain data sources such as Databases and how to connect to them
Query data sources using database engines and Structured Query Language (SQL) to filter, join, and aggregate data
Construct and calculate new fields using SELECT or CASE WHEN
Read and explain a sample OMOP query
This class is offered twice a year (currently fall and spring quarters). Check the schedule to see when it will next be offered.
Yes, you can access the course materials on your own any time.
You need to complete the live class to get a badge.
The class is open to members of the Cancer Consortium including Fred Hutch, the University of Washington, and Seattle Children’s Hospital.
You can, but each class takes up a few hours of attention a week to absorb the material. We recommend taking one class at a time for full-time employees.
You can sign up more than once, but be aware that there is tyspically a waitlist. We will prioritize students who have not taken the class. If there is room you are welcome to take it again.