This project explores and analyzes COVID-19 data, focusing on various aspects such as total cases, total deaths, infection rates, and vaccination progress. The analysis is performed using SQL queries on a dataset named Covid Deaths and Covid Vaccinations, which includes information on COVID-19 cases, deaths, and vaccinations across different locations and continents.
- Evaluates the likelihood of death if one contracts COVID-19 in a specific country.
- Examines the relationship between total cases and the population of a specific country.
- Identifies countries with the highest infection rates relative to their population.
- Lists countries with the highest death count per population.
- Highlights continents with the highest death count per population.
- Provides global statistics on total cases, total deaths, and the death percentage.
- Combines COVID-19 deaths and vaccination data based on location and date.
- Analyzes the relationship between total population and new vaccinations.
- Calculates the percentage of the population vaccinated over time for each country.
- Defines a view named "VaccinationPercentage" to simplify the analysis of vaccination progress.
- Clone the repository:
git clone https://github.com/SaiSurajMatta/Covid-19-Data-Exploration-Project.git - Import the provided dataset into your SQL environment.
- Execute the SQL queries in the specified order to analyze different aspects of COVID-19 data.
- Explore the results and gain insights into the pandemic's impact and vaccination progress.
Feel free to contribute, suggest improvements, or use the analysis for further research.
Dataset Link - https://ourworldindata.org/covid-deaths The project utilizes the dataset, including COVID-19 cases, deaths, and vaccination information.
Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types