Talk to the Veterans Crisis Line now
U.S. flag
An official website of the United States government
Veterans Benefits and Health Care About VA Find a VA Location

VA Health Systems Research

Go to the VA 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 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.