COVID-19 DATA EXPLORATION

A SQL-based data exploration project analyzing COVID-19 cases, deaths, infection rates and vaccination progress across countries and continents.

PROJECT OVERVIEW

This project explores COVID-19 data using SQL to identify trends in cases, deaths, infection rates and vaccination progress. The analysis works with COVID deaths and vaccination datasets and develops queries for country-level, continent-level and global analysis.

KEY ANALYSIS

The analysis examines total cases versus deaths, percentage of the population infected, countries with the highest infection rates, countries with the highest death counts, continental death counts, global COVID-19 numbers and vaccination progress.

TOOLS & TECHNOLOGIES

SQL   |   Joins   |   CTEs   | Temp Tables   |   Window Functions   | Aggregate Functions   |   Views   | Data Type Conversion

SQL ANALYSIS OVERVIEW

The SQL analysis progresses from exploratory queries to more advanced techniques, including joins, common table expressions, temporary tables, window functions and a view created to support later visualizations.

KEY SQL TECHNIQUES

Python is the most popular programming language among respondents, while Data Scientists have the highest average salary. Work/life balance received an average rating of 5.74/10, while salary satisfaction was rated 4.27/10.

Joins: Combined COVID-19 deaths and vaccination data using location and date.

Window Functions: Calculated rolling vaccination totals by location over time.

CTEs: Structured intermediate calculations for vaccination analysis.

Temporary Tables: Stored intermediate vaccination calculations for further analysis.

Views: Created a reusable view for later visualization and analysis.

PROJECT REPOSITORY

The complete project, including analysis and supporting files, is available on GitHub.