👉 SQL Basics with Healthcare Data | 1 Hour
Learn the basics of SQL in this 1 hour tutorial! We will be using a modified version of Synthea, a synthetic patient database. We will also be using a free type of SQL called PostgreSQL to learn how to upload, and query patient data.
Update: the header option 16:57 is going to be frozen when you import the txt files. You do not need to click on the header. It will be 'off' by default.
💻 This link for the github SQL script you will need: https://github.com/Data-Wizardry/SQL-...
📁 Click here to obtain the data for this tutorial: https://datawizardry.academy/sql-basi...
You will have to provide an email; then you'll be sent 2 emails. The first confirms that you're not a bot, the second contains the lesson files. Check your spam folder if you don't see anything.
💊 Become a Clinical Data Analyst! My course teaches you everything you need to know in just 10-12 weeks: https://datawizardry.academy/clinical...
🎙️ FREE WEBINAR!
In this 1-hour webinar, I lay out a roadmap for you to learn how to become a data analyst, and gain healthcare domain knowledge:
https://datawizardry.easywebinar.live...
00:00 Intro
01:34 Why SQL?
04:08 Installing PostgreSQL on PC
06:10 Installing PostgreSQL on Mac
10:05 Loading Data into SQL
Synthea: 17:32
SQL Intro: 20:09
What are Patient Encounters: 24:16
WHERE CLAUSE: 27:54
GROUP BY: 38:02
ORDER BY: 40:14
HAVING: 42:00
Practice Questions 45:20
Intro to Joins: 55:00
#sql #postgresql #sqltutorial #dataanalytics #healthcaretechnology