|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analytics-intro-to-sql-using-healthcare-data-ssms/
课程评论：没有评论
**课程名称：** 数据分析：医疗健康数据入门 SQL **课程概述：** 本课程是 SQL 的全面入门介绍，适合所有人群。尽管我们将使用 Microsoft SQL Server Management Studio 来学习 SQL，但在此课程中学到的技能可以轻松迁移到其他数据库语言（如 MySQL）和数据库管理系统（如 Postgres、Oracle 等）上。 本课程旨在帮助您舒适地处理复杂数据，编写 SQL 脚本，并熟悉医疗健康数据。无论您是否从事医疗健康行业，课程中的示例都将助您学习 SQL。掌握 SQL 的人需求量很大，美国劳工统计局报告称，许多 SQL 专家年收入超过 10 万美元！数据分析是一个不断发展的领域，理解 SQL 是成为数据分析专家的关键。 **课程内容亮点：** * 学习 SQL 和 Microsoft SQL Server Management Studio 的基础知识。 * 编写复杂的 SQL 语法，从基础入手。 * 创建数据库并插入大量数值。 * 分析大量真实世界医疗健康数据。 * 为 PowerBI、Tableau 等可视化工具准备数据。 * 设计实体关系图。 * 使用 SQL 运算符和函数进行数据聚合、格式化和修改。 * 获得处理大数据和利用数据解决复杂问题的经验。 * 学习 SQL JOIN，处理多表和多数据库。 * 大量的实践练习。 * 还有更多内容！ **课程特色：** 讲师非常重视学生反馈，并根据反馈补充内容，以帮助学生更好地理解新概念。欢迎加入我们的学习之旅！
This course is a comprehensive introduction to SQL. This course is for everyone! Although we will be learning SQL using Microsoft SQL Server Management Studio the skills learned in this course will easily transfer to other database languages (MySQL) and database management systems (Postgres, Oracle, etc.). The purpose of this course is to help you feel comfortable working with complex data and writing SQL scripts while becoming familiar with healthcare data.It doesn't matter whether you work in healthcare or not, the examples in this course will help you learn SQL. Individuals who know SQL are in high demand. In fact, the U.S. Bureau of Labor Statistics reported that many SQL experts make over $100,000 per year! Data analytics is a growing field and understanding SQL is essential to becoming an analytics expert.During this course we will:Learn the basics to SQL and Microsoft SQL Server Management StudioWrite complex SQL syntax - Starting with the basicsCreate Databases and inserting thousands of valuesAnalyze thousands of rows of data - real world healthcare dataPrepare data for visualizations such as PowerBI, Tableau, etc.Design Entity Relationship DiagramsAggregate, format, and modify data using SQL operators and functionsGain experience with Big Data and solving complex questions using dataLearn SQL Joins - working with multiple tables and databasesPractice, Practice, Practice.And much more!Feedback from students is very important to me. I take this feedback and add content to help students understand new concepts. Can't wait to have you join us.
