
This lecture provides an overview of what the course contains, who it was designed for, what our goals are and how we’ll accomplish them.
This lecture starts our SQL journey. After a brief background discussion, this lecture dives into setting up a MySQL Server and uploading our sample training database. I have provided several resources to download and reference to ensure you are able to get everything set up. Please message if you have any trouble getting through these resources.
In this lecture, we take our first dive into the sample training database. We won’t start writing SQL yet but will look to get initial comfort with our workspace in the MySQL workbench.
This is the first use case we get into – we will start talking about patient volumes and activity. In this video we even start writing our first SQL script!
This lecture dives into writing SQL to learn about who our patients are.
This lecture highlights the kinds of data and SQL we need to write to find ER throughput.
A critical thing to start learning is the cost of care. This video introduces the types of data we can look at that impacts our patient’s even after they come to our hospital.
This lecture covers using SQL to look into different procedures that are done to our patients.
This use case looks at hypertension management – a population health area of focus.
This is a quick wrap up that reviews what our goals were and what next steps for you look like. Please feel free to leave feedback or reach out to let me know how this course helped you!
SQL for Healthcare looks to provide students a single course to learn SQL and 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. I have 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.
This course was created by me - Mark Connolly, MEng. I'm currently a Business Intelligence Lead and co-lead for the virtual Tableau Healthcare User Group. I have almost 10 years of experience in the healthcare analytics space in general. I have used SQL heavily in my most recent role to answer many healthcare clinical analytics questions.
Beyond my experience working directly with SQL, I have also developed internal Tableau training programs and provided 100's (if not 1000's) of hours of training support to analysts both at his current organization and externally. I am also the creator for the strongly reviewed Tableau for Healthcare course on Udemy.
Please note that this course utilizes training data and is not reflective of any current or past performance or clinical data for any patient, health system, insurance provider, or any other entity. All data is fake and made available for educational purposes only.