Skip to content

Latest commit

 

History

History
17 lines (14 loc) · 728 Bytes

README.md

File metadata and controls

17 lines (14 loc) · 728 Bytes

COVID-19 Data Analysis Project

In my SQL project, I conducted an exploratory analysis of Covid-19 deaths and vaccination data from March 2020 to June 2021 using MS-SQL Server. The raw dataset, sourced from Our World in Data, was imported into a SQL Database on my local machine. The analysis involved using various SQL skills, including Joins, CTEs, Temp Tables, Window Functions, Aggregate Functions, Creating Views, and Converting Data Types.

Skills Utilized:

  1. Joins
  2. Common Table Expressions (CTEs)
  3. Temporary Tables
  4. Window Functions
  5. Aggregate Functions
  6. Creating Views
  7. Converting Data Types

Data Source:

COVID-19 Deaths Dataset ( https://ourworldindata.org/covid-deaths )

Tools:

MS-SQL Server