|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/analyze_covid19/
课程评论:没有评论
课程名称:使用SQL和SQLite分析COVID-19数据 课程概述: 本课程旨在教授学员如何使用SQL和SQLite来访问、分析和解读COVID-19相关数据。通过课程,您将学习如何利用免费且无需安装的软件,直接从U盘运行,高效地处理和分析病毒数据。 课程内容: * **数据访问与分析:** 学习使用SQL与免费开源数据库SQLite,针对国家、州、县以及区域层面的COVID-19数据提出并回答各式各样的问题。 * **空间数据分析:** 利用SQLite的空间映射扩展SpatiaLite,分析COVID-19的地理分布特征。 * **时间与空间特征分析:** 深入探究COVID-19的时间和空间演变规律。 * **SQL进阶训练:** 通过详尽的SQL培训,培养学员自主提出问题并进行数据分析的能力。 * **数据准备与统计分析:** 学习为统计分析准备数据,并解答诸如以下问题: * 美国各地区在COVID-19病例、住院和死亡人数上是否存在差异? * 病例、住院和死亡人数如何随时间变化? * 您所在县的病例模式和趋势如何?与州或国家/地区的数字相比如何? 通过本课程,学员将掌握强大的数据分析技能,能够独立探索和理解COVID-19带来的影响。
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?