👉 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-Webinar-1 📁 Click here to obtain the data for this tutorial: https://datawizardry.academy/sql-basics-healthcare/ 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_analytics_accelerator/ 🎙️ 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/event-registration 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