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

VA Health Systems Research

Go to the VA ORD website
Go to the QUERI website

VIReC Database and Methods Seminar

VHA Corporate Data Warehouse (CDW): Using CDW Data to Conduct a Research Study for SQL Beginners


by Anne Hines,
Seminar date: 6/3/2024

Description: This seminar demonstrates conducting a simple study in the CDW using VA data, focusing on attendees who consider themselves to be beginner-level SQL programmers. Attendees who are new to the CDW are encouraged to watch the archived cyberseminar, VHA Corporate Data Warehouse (CDW): Using CDW Data to Conduct a Research Study. The last third has been rewritten for an audience of beginner-level SQL programmers.
Objectives:
• Review important CDW concepts
• Describe aims of example study
• Identify procedures associated with the study aim
• Determine CDW tables of interest
• Prepare beginner-level SQL code to pull the study data

View archived session video:



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.