Health Case Study Through SQL Intro

Health Case Study Through SQL

Learn the following SQL Concepts:

How to get N rows of data in SQL
How to use Aggregate Functions in SQL
- Count, Count Distinct, Sum, Maximum, Minimum etc.
How to deal with transposed datasets in SQL
How to filter out missing values in SQL
How to Sort data in SQL
- How to sort data from low to high (ascending) in SQL
- How to sort data from high to low (descending) in SQL
How to combine Sorting and Limiting to find Top N rows in SQL
What are the various types of Ranking methodologies in SQL
- How to rank based on a column where ranks are skipped in SQL using Rank Function
- How to rank based on a column where ranks are not skipped in SQL using Dense Rank Function
- How to generate serial rank based on a column in SQL using Row Number Function

Learn the following Concepts about Health Data Science:

Understand the various national health metrics
How to find total countries in international health datasets
How to find total indicators/metrics in international health datasets
How to generate the trend of health metrics in a specific country
How to analyze top and bottom N countries based on a health indicator
How to design and analyze your own ranking method based on health indicators
How to analyze the performance of individual countries on various health parameters