Covid-19 Data Exploration with SQL

• View Project

Aim: To study the data using SQL and answers questions about the death rates, vaccination trends across the globe, etc.

Skills used: Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types.

Learnings:

1. Clean semi-structured data present in Excel and load it in Azure data studio.
2. Load and preview the data.
3. Data pre-processing. Convert datatypes of columns.
4. Exploratory data analysis