COVID-19 Data Exploration in SQL

Data Exploration SQL Project Image

This project executes queries to explore COVID - 19 dataset in SQL Server.

You can find the code for this project on GitHub.

Data Exploration

You can check out the dataset in this link. It provides daily and cumulative figures on COVID-19, including the number of confirmed cases, deaths, and vaccinations, categorized by country.

I ran SQL queries to look into the following data:

  • Likelihood of dying from Covid in Bangladesh, i.e., Total Deaths vs Total Cases,
  • Percentage of population that got Covid in Bangladesh, i.e., Total Cases vs Population,
  • Countries with highest infection rate compared to population,
  • Countries with highest death count per population,
  • Continents with highest death count per population,
  • Global Numbers in terms of infected cases, confirmed deaths and vaccinations,
  • Cumulative count of people vaccinated against population by each country using PARTITION BY windows function,
  • Percentage of people vaccinated in each country using CTE,
  • Percentage of people vaccinated in each country using Temp Table.

A continuation of this project, where a Tableau dashboard was created using COVID-19 data fetched through these SQL queries, can be found at this link.