SQL for Healthcare Professionals

2h 11mIntermediate2024-08-19

Authors

Thais Cooke

Course details

In this course, healthcare data analyst Thais Cooke shows you how to integrate SQL in the field of healthcare. With the use of electronic records and the integration required to treat an individual as a whole, a strong understanding of computer languages, combined with an awareness of the challenges in healthcare, can help create better outcomes for patients, as well as solutions for problems within the industry. The data is already being generated; it just needs people who know how to use it. Learn how to apply SQL to patient care management, population care management, clinical research, and healthcare administration. Plus, complete in-course challenges and a final project to help you practice and solidify what you learn. Learning SQL enables healthcare professionals to augment their work by improving patients outcomes and operational efficiency.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - SQL for healthcare - Transforming data into insights
02 - What you need to know
03 - Installing the SQL exercise files

1. A Brief Overview of SQL

04 - Why use SQL in healthcare
05 - How to gather data for analysis using SQL
06 - Using aggregate functions to manipulate the data
07 - Using a CASE statement for data classification
08 - Date manipulation in SQL
09 - What are relational databases
10 - How to gather data from different tables using JOINS

2. Patient Care Management

11 - How SQL is used in patient care management
12 - Using SQL to recommend individualized treatment
13 - Patient safety monitoring

3. Population Health Management

14 - How to use SQL to manage population health
15 - Risk stratification in SQL
16 - Predictive analytics in population health
17 - Social determinants of health (SDOH) and SQL
18 - Challenge - Risk stratification
19 - Solution - Risk stratification

4. Clinical Research

20 - Using SQL in clinical research
21 - Cohort identification using SQL
22 - Descriptive analytics using SQL in clinical research
23 - Outcome analysis techniques with SQL

5. Healthcare Administration

24 - How to use SQL to analyze workflow
25 - Data exchange using SQL
26 - Quality improvement initiatives
27 - Challenge - Appointment analysis
28 - Solution - Appointment analysis

6. Final Project - Healthcare Analytics

29 - Assignment - Healthcare analytics scenario
30 - Walkthrough - Demographics scenario
31 - Walkthrough - Demographics and diagnosis scenario
32 - Walkthrough - Appointments scenario
33 - Walkthrough - Laboratory scenario
34 - Walkthrough - Laboratory with risk scenario
35 - Walkthrough - Risk scenario
36 - Walkthrough - Readmission scenario

Conclusion

37 - Next steps