Alidzhon Aminov

SQL Analysis of COVID-19 Data

Project Summary

This project used SQL to explore COVID-19 data and understand how the pandemic affected different countries and continents. The analysis looked at infection rates, deaths, and vaccination progress, while also building views and a stored procedure to make it easier to pull insights quickly.

Highlights:

• Calculated daily infection rates as a percentage of the population per country
• Identified countries with the highest infection rates and death counts
• Measured lethality by comparing death percentages among infected populations
• Analyzed vaccination progress using daily and cumulative data
• Created SQL views to summarize key metrics for easier access
• Developed a stored procedure to retrieve cases, deaths, and vaccination data for any country

Outcome:

• Produced clear insights into infection, death, and vaccination patterns
• Improved accessibility of COVID-19 data through views and stored procedures