Level III · Module 11
SQL for Research Data
The query skills to build and audit point-in-time research datasets: joins, window functions, as-of joins and reproducibility.
This module is locked
Level III enrollment is open to Level II students, or with the complete three-level program.
Explore the module outline below, or start with the free orientation and Module 1.
Read the free orientation and Module 1Module outline
- Keys, NULLs and joins
- Window functions
- As-of joins and reproducible queries
Intended learning outcome: Write a leak-free, reproducible SQL query that builds a point-in-time research dataset.