Project: SQL Databases
Topic: Malaysia COVID-19 Data Analysis using SQL
Keywords: COVID-19, Data Analysis, SQL, Malaysia
- Analyze and explore the Malaysia COVID-19 dataset to identify the outbreak's status from March 2020 to November 2022.
- Dataset can be obtained using Our World In Data.
- Present the trends and impacts of the pandemic in Malaysia using various visual representations and data analysis techniques.
- Utilize SQL schema languages to query the dataset and derive meaningful metrics related to deaths and vaccinations.
- To provide awareness and understanding of the COVID-19 disease, especially in the context of its impact in Malaysia.
- To identify the research areas related to COVID-19 and contribute to the overall knowledge around the pandemic.
- Aim:
- To analyze and understand the Malaysia COVID-19 dataset for a comprehensive view of the outbreak's status from March 2020 to November 2022.
- Objectives:
- Calculate metrics and describe the trends related to deaths and vaccinations due to COVID-19 in Malaysia.
- Provide insights into the death rates, infection rates, and vaccination statuses over the period, supporting public health decisions and strategies.
- Utilize SQL schema languages for data extraction and analysis, emphasizing the application of data modeling in understanding real-world challenges.
(1) CovidDeaths.csv
- Dataset Containing COVID-19 deaths and information in Malaysia in CSV format.
- Dataset Containing COVID-19 vaccinations and information in Malaysia in CSV format.
(3) Malaysia_Covid19_SQL_Results Folder
- Contains the main SQL file with implementation codes, results, and discussion for the project.
- None (for now)
- Took inspiration from Kaggle and Our World In Data.