Data Management in SQL: Selected Intermediate SQL Skills
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.