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: [ Ссылка ]
📁 Click here to obtain the data for this tutorial: [ Ссылка ]

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: [ Ссылка ]

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

свернуть