Kaystack/Covid-19-Project

This project is a data exploration of Covid-19 statistics in Nigeria. It utilizes SQL to extract and analyze data on infections, deaths, and vaccinations. The goal of the project is to provide insights into the impact of the pandemic on Nigeria's population and to identify trends in the country's response. # My Portfolio # Introduction This project explores COVID-19 data in Nigeria, utilizing a variety of SQL skills such as joins, CTEs, temp tables, window and aggregate functions, and view creation. Through a series of queries and analyses, the project presents insights into the likelihood of dying from COVID-19 in Nigeria, what percentage of the population has been infected, and the countries with the highest infection and death rates. It also breaks down data by continent and presents global statistics. Finally, the project visualizes the percentage of the population that has received at least one COVID-19 vaccine in Nigeria. By demonstrating a range of SQL techniques and providing valuable insights into a current global crisis, this project showcases my data analysis skills and ability to extract meaningful information from complex datasets. # Technologies SQL GitHub # Usage To run this project, you will need a SQL database containing Covid-19 statistics for Nigeria. The project code is available on GitHub and can be executed by running the SQL queries in a SQL client such as Microsoft SQL Server Management Studio. # Data Sources The data used in this project was obtained from public sources, including the World Health Organization and the Nigeria Centre for Disease Control. # Credits If you have any questions or comments, please feel free to contact me at kosydorise@gmail.com.