Analyze COVID-19 Data with SQL and SQLite

how data analytics, data science, and GIS technology can help us understand the COVID-19 pandemic

5.00 (4 reviews)

Udemy

platform

English

language

Other

What you will learn

find, download, and consume COVID-19 data for analysis

issue basic and sophisticated SQL statements to analyze COVID-19

integrate SQL database queries with geographic information system technology to visualize the results of your analysis

perform spatial analysis on COVID-19 data using the spatial constructs in SQL

visualize analysis of your COVID-19 data using charts,graphs, and other techniques

Why take this course?

COVID-19 has changed our world. It's frightened us, inspired us, isolated us, and drawn us closer. Obviously, the effects of the pandemic have affected us in different ways. But one thing is certain, we've all looked at COVID-19 data and wondered what's happening, and how is it affecting me?

In this workshop you will learn how to access, analyze, and interpret for yourself, the different data associated with COVID-19. We'll use all free software that can run directly off a thumb drive, so you don't have to install anything: just download the associated .zip file, and start working.

The course will teach you how to use SQL with the free and open source database, SQLite, to answer an almost unlimited number of questions related to COVID-19 at the National, State, County, and regional levels. We'll also analyze the geographic distribution of COVID-19 using the spatial mapping extension for SQLite, SpatiaLite.

With these tools, you'll be able to analyze the temporal and spatial characteristics of COVID-19. And, with the extensive SQL training in the workshop, you'll be able to come up with your own questions to analyze the data.

Finally, we'll prepare the data for statistical analysis, asking questions like:

are there regional differences in COVID cases, hospitalizations, and deaths throughout the United States?
how have cases, hospitalizations, and deaths changed over time?
what are the patterns and trends in my county, and how does that compare to the State or National numbers?

Content

Introduction

Pre-workshop set up

Workshop set up

Break Glass if all else fails....

Digging deeper into the set-up scripts

Installing QGIS 3.8

Workshop Day 1

Basic SQL - the SELECT statement

Assess your learning in basic SQL

Basic SQL - Calculations in queries

Test your knowledge of calculations in SQL queries

Basic SQL - Aggregation functions in queries

Basic SQL - tying everything together with county-wide data

Basic SQL - Homework preparation

Workshop Day 2 - Intermediate SQL

Intermediate SQL - Joining tables with themselves

Intermediate SQL - Joining multiple tables

Intermediate SQL - exploring some controversial issues with COVID-19

Intermediate SQL - Visualizing spatial data by joining tables

ATTENTION Esri Users - Visualizing Query Results in Esri products

Day 3 - Advanced SQL with spatial constructs

Basic Spatial Operations with SQL

Speeding up analysis by changing formats, coordinate systems, and adding indexes

Finding COVID-19 Deaths by Metropolitan Area

Create a distance decay model for COVID-19 data

Time-series analysis of COVID-19 data

Continue learning spatial SQL

User Questions: Adding data to SQLite, working with 3rd party applications

Bonus Lecture: How to keep learning about Geoanalytics

Screenshots

Analyze COVID-19 Data with SQL and SQLite - Screenshot_01

Analyze COVID-19 Data with SQL and SQLite - Screenshot_02

Analyze COVID-19 Data with SQL and SQLite - Screenshot_03

Analyze COVID-19 Data with SQL and SQLite - Screenshot_04

Reviews

rnottinger

April 24, 2021

Introduction...Hello I'm a programmer with mysql experience and was interested in getting some sqlite experience which I can use with my mobile Flutter apps and learn how to pass data between mysql and sqlite. I don't have any GIS software experience but it is on the hit list. I found this course on udemy while searching for sqlite and looks like I can pick up a several skills with this course..GIScience, Data Analytics, GeoAnalytics, SQLite, Spatialite GUI, covid-19 analysis. I've got the software and data installed and ran a few basic queries in Spatialite GUI. I'm looking forward to completing this course and learning more about GIS. Thank you for creating this course!

Carl

April 13, 2021

Dr. Lembo's course on data analysis, exploration and exploitation with SQLite is fantastic. The barrier of entry is low considering the use of FOSS free open-source software and there should be zero excuses for someone to not learn new or expand on existing skill sets.

Charts

Price

Rating

Enrollment distribution

Analyze COVID-19 Data with SQL and SQLite - Distribution chart