SQL for Healthcare

Overview

SQLfor Healthcare looks to provide students a single course to learn SQLand United States Healthcare concepts together. Through the use of MySQL (an open source and free tool) we will explore various use cases like patient volumes, emergency room throughput, and procedures to learn new SQL and healthcare analytics skills.

I will be taking an approach of presenting healthcare topics briefly before diving into working examples using SQL. My intent is to help us apply technical concepts of the SQL language while at the same time learning new healthcare knowledge.

Following each lecture, there will be an assignment for students to really apply and grow beyond what we cover over video content. Ihave found this approach really helps with long term retainment of skills.

This course is great for anyone new to healthcare and/or SQL and is meant to help others jump start a career in healthcare analytics.

Syllabus

• Introduction to SQL and Healthcare
Overview of SQL
Introduction to the US Healthcare System
Course objectives and structure
• Setting Up the MySQL Environment
Installing MySQL
Basic MySQL operations
Introduction to MySQL Workbench
• Basic SQL Syntax and Queries
SELECT statements
Filtering with WHERE
Sorting results with ORDER BY
• Healthcare Data Models
Understanding patient data structures
Overview of healthcare databases
Exploring sample healthcare datasets
• SQL Functions and Aggregations
Using COUNT, SUM, AVG
GROUP BY and HAVING clauses
Practical examples using patient volume data
• Working with Multiple Tables
Introduction to JOIN operations
INNER JOIN, OUTER JOIN use cases in healthcare
Analyzing patient admissions and discharge data
• Advanced SQL Concepts
Subqueries and nested SELECTs
Common Table Expressions (CTEs)
Window functions applied to healthcare analytics
• Case Studies: Emergency Room Throughput
Key performance indicators for ERs
Analyzing ER data using SQL
Real-world application of SQL queries
• Procedures and Functions in MySQL
Writing and executing stored procedures
Creating custom functions for healthcare scenarios
Automation of complex queries
• Introduction to Healthcare Analytics
Key concepts and tools in healthcare analytics
Role of SQL in healthcare data analysis
Case examples of effective healthcare analytics
• Final Project and Review
Applying SQL skills to a healthcare analytics project
Presentation of student projects
Review of key concepts and preparation for future learning
• Additional Resources and Next Steps
Recommended readings and online resources
Career paths in healthcare analytics
Future learning opportunities in SQL and data analytics

Taught by

Mark Connolly

Subjects

Programming