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 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.

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.