SQL for Healthcare Analytics – My Learning Hub

My Personal Learning Hub & Notebook
This is my private space where I organize and document everything I’m learning about SQL — especially applied to healthcare analytics (Risk Adjustment, HCC Coding, Claims, Membership) while practicing on AdventureWorksDW2017.

Last Updated: June 18, 2026

---

🌳 Structured Learning Path

1. SQL Foundations

• SELECT, FROM, WHERE, ORDER BY, DISTINCT
• Basic SQL Examples for Healthcare Analytics
• SQL Practice -HealthCare
• SQL Study Notes: Recognizing Patterns Instead of Memorizing Syntax

2. Combining Healthcare Data (JOINs)

• Joins
• Why JOINs are Usually Preferable to Subqueries
• INNER JOIN, LEFT JOIN, and NOT EXISTS

3. Finding Missing Data & Gaps

• EXISTS vs JOIN
• LEFT JOIN + IS NULL

4. Summarizing & Aggregating Data

• GROUP BY + HAVING – Understanding & Practice

5. Business Logic & Advanced SQL

• Subqueries in Healthcare Analytics
• CTEs (Common Table Expressions)
• Window Functions
• UNION

6. Key Concepts & Utilities

• ProductKey vs ProductAlternateKey – Why Both Exist
• Finding Columns in Tables – Useful Query
• Date Functions in SQL
• SQL Data Cleaning Techniques

---

📌 Featured Posts

• GROUP BY + HAVING – Understanding & Practice
• INNER JOIN, LEFT JOIN, and NOT EXISTS

This page will grow daily as I continue my studies.