Independent Study 2016.

January 21, 2016

Russ Waitman, Aqeel Alenazi, Tamara McMahon?, Patti Kluding, Michael Prittie

  • Reference last year's course: HERONIndependentStudy will follow same general outline but hopefully improve.
  • Bring a laptop to class
  • Sponsorship for access
  • Lecture materials for today



January 28, 2016

  • did practice your cast by running queries osteoarthritis and diabetes.

February 11, 2016

Introduction to SQL

February 25, 2016

Query refinement with Patti Kluding

March 3, 2016

Refine your hypothesis, data and SQL

March 24, 2016

Review data sets from HERON

  • Lactic Acid/Sepsis? example on need to look at raw data for longitudinal analysis
  • Breast Cancer REDCap project for what can be analyzed in REDCap
  • SQLite example of Breast Cancer patient population -- Provided an overview of how to execute SQL statements in SQLite -- Introduced the Data, Code Info and Patient Views

DUA is submitted and awaiting approval. Next class (3/31) can focus on importing the HERON data into SQLite and running SQL on Aqeel's data set.


  • Aqeel to download and install SQLite
  • Determine parameters for analyzing data. (e.g., pain score and location time frame before and after diagnosis)

March 31, 2016

SQLite for HERON data instructions.

Last modified 2 years ago Last modified on Mar 31, 2016 6:47:00 PM