Skip Navigation

Course Directory

315.727.81
Database Querying in Health

Location:
Internet
Term:
2nd term
Department:
Health Policy and Management
Credits:
3 credits
Academic Year:
2021 - 2022
Instruction Method:
Asynchronous Online with Some Synchronous Online
Auditors Allowed:
No
Grading Restriction:
Letter Grade or Pass/Fail
Contact:
Mary Sewell
Resources:
Prerequisite:

Introduction to Online Learning is required prior to participating in any of the School's Internet-based courses.

Description:

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:

  1. Use introductory and intermediate level SQL to perform exploratory data analyses on electronic medical record (EMR) data, leveraging SQL Server Management Studio (SSMS)
  2. Evaluate the impacts of data governance in health informatics systems
  3. 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

Instructor Consent:

Consent required for all students

Consent Note:

Students not matriculated in the DHSI formal degree or certificate programs must seek the instructor’s permission to register

For consent, contact:

marysewell@jhu.edu

Special Comments:

Note, this course, based in the SOM, uses Blackboard, not CoursePlus. Same as SOM # 600.907