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

Getting the Information You Need From CDW: SQL Starter Language


by Margaret Gonsoulin, PhD
Seminar date: 1/26/2015

Description: Summary: This session is a continuation of VIReC’s Corporate Data Warehouse (CDW) cyberseminar series. It introduces new users to the most commonly used Structured Query Language (SQL) commands (e.g., SELECT, FROM, WHERE, GROUP BY and ORDER BY). These basic commands will be applied to a view in CDW production domains and then to an equivalent view in CDW’s raw domains. Prior to this session, new users are encouraged to review the previous CDW cyberseminars on HSR&D’s archive (VA Intranet only). Objectives: (1) Provide an introduction to the CDW server environment and (2) Provide new CDW users with a few basic SQL programming skills. Target audience: Principal Investigators, Data Managers, or Analysts who want to learn how to write a basic query in SQL.

We're sorry - this video format is no longer supported. You may still download the resources below.



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.