This project uses SQL to analyze hospital patient data from relational tables, focusing on patient demographics, medical diagnoses, admission patterns, and doctor specializations. It involves advanced SQL techniques like JOINs, filtering, aggregations, and CASE statements.
From the README
Medical Data History Analysis 🏥 📌 Project Overview This project analyzes hospital patient data using SQL by interacting with relational tables including patients, admissions, doctors, and provincenames. It focuses on extracting actionable insights related to patient demographics, medical diagnoses, admission patterns, and doctor specializations. --- 🎯 Objectives • Analyze healthcare and hospital patient records using SQL. • Extract key insights from patient, admission, and doctor entities. • Practice advanced SQL concepts including JOINs, filtering, aggregations, and CASE statements. • Establish data modeling relationships across healthcare entities for Power BI...