SQL Joins Made VERY SIMPLE!

Показать описание

Whether you're a data analyst, data scientist, or data engineer, it's vital to understand how joins work in SQL, as it's foundational to how databases work!

Watch this video as I explain the core concepts using healthcare data! Part 1 in a series of 3 videos:

Video 1: SQL Joins
Video 2: SQL Cardinality
Video 3: SQL + Tableau Portfolio Project

If you would like to follow along using the fake patient data I'm using,

2. Find SQL Basics in Healthcare
3. Fill out info to get an email of the files

I have a previous video where I walk you through how to Install SQL, and import those files:

// BECOME A CLINICAL DATA ANALYST!
My course teaches you everything you need to know in just 10-12 weeks:

// 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:

#dataanalyst #sql #dataanalytics #data #healthcaretechnology

Data Wizardry

Рекомендации по теме

Комментарии

Wow! this looks like a great project! Especially being able to combine sql with a viz tool.

joeltorres

Absolutely Awesome tutorial on join operations extended to filter.
Thank you for highlighting the impact of cardinality on the size of the result set.
I am left to understand the case use or when to decide to change the cardinality when performing the join, as displayed with the cte on the data wizardry web site under the sql basics healthcare

osoriomatucurane

First of all, this video and your previous 60 min. video were amazing! The explanations are concise and the examples are easy to follow! I had a question regarding your example of including the "pat.first = 'Adelina'" in the inner join statement. I tried using "where pat.first = 'Adelina' " after the join statement and I got the same result of 34 rows returned. Do you think one approach is better than the other, or would it just be a preference?

Thank you for all of your work in making videos!

xavierwood

What was tripping me up was that patients table has only one Adelina Simonis for example and yet with left join on immunizations table I'm getting 10 instances of Adelina Simonis. Is this what you mean by a one to many? Bc there's many rows of that matching ID in immunizations table. It was a great lesson. And I like how you give a quick intro into what's next.

joeltorres

Hi, I am a pediatric Anesthesiologist .
I have a lot of questions - can I have ur email id so that I can connnect with u.
Thanks

karthikswamy

SQL Joins Made VERY SIMPLE!

SQL Joins Explained |¦| Joins in SQL |¦| SQL Tutorial

6 SQL Joins you MUST know! (Animated + Practice)

SQL Joins - Beginner to PRO Masterclass with 10 Examples

JOINS IN SQL (with example )

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1

SQL Tutorial - 29: SQL JOINS

Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

SQL JOINS Interview Question | What does different SQL Joins return?

21. RIGHT JOIN and UNION in SQL | SQL Course for Beginners

HOW TO JOIN 3 OR MORE TABLES IN SQL | TWO WAYS

Learn SQL Joins

5 Basic Sql Joins - Every data beginner should know !

#10 SQL Joins in Telugu| SQL Full Course in Telugu | Joins in SQL Telugu | SQL JOINS TELUGU

SQL Joins: A Guide and Examples

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

SQL JOINS Explained - SQL Tutorial for Beginners with Examples - Inner, Left, Right, Full

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

Inner Join, Left Join, Right Join and Full Outer Join in SQL Server | SQL Server Joins

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases

SQL Explained in 100 Seconds

SQL JOIN tutorial 2024: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, join more than 2 tables

Joins in SQL | Joins in SQL with Example | SQL Tutorial for Beginners | Edureka

Joins - Inner, Left, Right and Cross | Union | Mysql| SQL in Tamil | Logic First Tamil