Talk to the Veterans Crisis Line now
U.S. flag
An official website of the United States government

Health Services Research & Development

Go to the ORD website
Go to the QUERI website

VIReC Corporate Data Warehouse

Data Management in SQL: Selected Intermediate SQL Skills


by Margaret Gonsoulin, PhD
Seminar date: 10/31/2016

Description: This talk is aimed at an audience that has been using SQL and the VHA’s Corporate Data Warehouse (CDW) for a couple of months and now wants to learn a few more SQL commands for data management. This talk covers the use of temporary tables, the process of recoding values found in a column and the use of partitions for dealing with multiple records. All examples are shown using CDW data.



DOWNLOAD: PDF handout | Audio only (mp3) | transcript


Questions about the HSR&D website? Email the Web Team.

Any health information on this website is strictly for informational purposes and is not intended as medical advice. It should not be used to diagnose or treat any condition.