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: 12/2/2024

Description: The Corporate Data Warehouse (CDW) is a national repository of data from VA’s electronic health record and several other VA clinical and administrative systems. In this cyberseminar, we will demonstrate how to conduct a simple study using CDW data. This session is geared toward beginner-level SQL programmers. Attendees who are new to the CDW are encouraged to watch the archived cyberseminar, VHA Corporate Data Warehouse (CDW): A Conceptual Overview, prior to attending.

Stay tuned! A follow-up to this cyberseminar for more advanced SQL programmers will be presented in June 2025. Register now VHA Corporate Data Warehouse (CDW): Using CDW Data to Conduct a Research Study for Intermediate SQL Users.

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 not yet available

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.