315.727.81
Database Querying in Health
Course Status
Discontinued
Course Status
Discontinued
Location
Internet
Term
2nd Term
Department
Health Policy and Management
Credit(s)
3
Academic Year
2022 - 2023
Instruction Method
Asynchronous Online with Some Synchronous Online
Auditors Allowed
Yes, with instructor consent
Available to Undergraduate
No
Grading Restriction
Letter Grade or Pass/Fail
Contact Name
Frequency Schedule
Every Year
Resources
Introduces core concepts of relational databases using Structured Querying Language (SQL) along with terminologies related to clinical databases used in health information systems. Utilizes the Precision Medicine Analytics Platform with access to de-identified medical records of 70K patients with Diabetes with over 100 million data elements, including las, medications, encounters procedures, symptoms, and vitals. Focuses on answering clinical and research questions and discussion around effective data governance. Analyzes 3-yers of data to look for clinical and population-level management strategies for type 1 and type 2 diabetes. Includes analysis of a thorough data quality evaluation framework as well as identifying predictors for hospitalization and rehospitalization.
Learning Objectives
Upon successfully completing this course, students will be able to:
- Use introductory and intermediate level SQL to perform exploratory data analyses on electronic medical record (EMR) data, leveraging SQL Server Management Studio (SSMS)
- Evaluate the impacts of data governance in health informatics systems
- Hypothesize how changes to a patient’s behavior or clinical care would impact their EMR data, specific to Diabetes using clinical coding terminologies such as ICD10, LOINC, and CPT
Methods of Assessment
This course is evaluated as follows:
- 40% Assignments
- 15% Midterm
- 20% Participation
- 25% Final Project
Note, this course, based in the SOM, uses Blackboard, not CoursePlus. Same as SOM # 600.907