Embedded Files
There is a need to develop a passion to work and experiment with the data specifically healthcare data.
I learned a lot from my coursework and gained skills to update myself to be competent in the world of data science.
Once you get an understanding of how the databases (DB) work, you will develop an addiction to working with the data.
SQL Project
Below are my SQL query skills. I was able to manipulate the fake healthcare data (Synthea)
I created a database on the demographics of the patients, their diseased conditions, their immunization status, providers' names, and the encounters of the patients from different tables and joined them as per the question
This SQL query is to get all the patient conditions where the patients are full-time employed. The number of patients' conditions selected >2000 and are ordered in descending trend.
This SQL query is to get all the patients where the patients are full-time employed. The number of patients selected is >2000 by count and is ordered in a descending trend.
This SQL query is to get all the patients with viral sinusitis who were encountered between 2018-01-01 and 2019-01-01.
These patients are from the category who are not in the labor force.
This SQL query is to get the counts of the different conditions that were present in the database. Listed in descending order.
This SQL query is to get the counts of the conditions excluding the stress condition from the database. Listed are the conditions < 1000 and are displayed in descending order.
This SQL query is to get the patient' name, birth date, place and who were vaccinated for only meningococcal between 2019/01/01/and 2019/12/31. The patients are displayed in a separate column ( menningococcal_MCV4P). of the conditions excluding the stress condition from the database. Listed are the conditions < 1000 and are displayed in descending order.
SQL query to select specific procedures from the database of patients from SyntheaTM is an open-source, synthetic patient generator that models the medical history of synthetic patients.
To have specific columns and rows: I used SELECT, CASE WHEN, JOIN, TIME CLAUSE AND USED ALSIAS
GROUP BY CLAUSE
JOIN CLAUSE
A longitudinal study on subcutaneous immunization-
Question about effects of pandemic on'Subcutaneous immunotherapy' The study might need additional data (timing and location, local outbreaks, healthcare policies, and patient behavior)
Page updated
Google Sites
Report abuse