Published On Jun 26, 2023
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.
💊 Check out this link to learn more about my upcoming healthcare analytics accelerator class: https://datawizardry.academy/accelera...
Did you like the course and want to help spread the word? Now you can submit a testimonial! It only takes a couple minutes and would really help my channel grow a lot: https://testimonial.to/sql-basics-hea...
Thank you so much!
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