最新消息:请大家多多支持

Analyze COVID-19 Data with SQL and SQLite

其他教程 dsgsd 242浏览 0评论

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 22 lectures (4h 40m) | Size: 1.74 GB

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


What you’ll 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

Requirements
students should be comfortable using computers and be able to navigate folders and directories

Description
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?

Who this course is for
interest in understanding the spatial and temporal patterns of COVID-19
those interested in learning technology and how to include SQL within your skillset


Password/解压密码www.tbtos.com

Download rapidgator
https://rapidgator.net/file/7a47779efe64013b9ecab5cb813ec13b/0923_31.z01.html
https://rapidgator.net/file/9834f4d737d6e2122f65e8289758b095/0923_31.zip.html

Download nitroflare
https://nitro.download/view/A6BA90CA08CACF1/0923_31.z01
https://nitro.download/view/9773C030E043F59/0923_31.zip

资源下载此资源仅限VIP下载,请先

转载请注明:0daytown » Analyze COVID-19 Data with SQL and SQLite

您必须 登录 才能发表评论!