W33: Analysis of Electronic Health Records – Day 2

UCLA Health serves well over half a million patients annually, and as a result, UCLA possesses a vast database of Electronic Health Records (EHR). The stemming Discovery Data Repository (DDR) serves as an invaluable resource for researchers. This introductory workshop will cover the basics of writing queries to extract the relevant datasets for EHR-related research projects – from a simple list of patient visits to generating feature sets for complex phenotypes. Topics covered include introductory SQL, medical record concepts and organization, and best practices. Additionally, an entire day is dedicated for the UCLA ATLAS Precision Health Biobank which integrates genetic information and de-identified medical records to enable precision health research.