|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hands-on-sql-for-data-analysts/
课程评论：没有评论
课程名称：SQL 数据分析，掌握行业分析师的实用技能 课程概述：SQL 是数据分析的核心语言。本课程将教授您在行业中最实用的查询技术。与其他课程不同，本课程将以行业风格的数据进行教学。掌握 SQL 的使用，可以让您查询组织数据库中的数据，从而回答您作为数据和商业专业人士所关心的问题。这是数据专业人士使用了几十年的“基本技能”，如今在云计算时代依然备受需求。本课程将我在日常工作中教授的所有实用主题整理成一个便捷的课程，适合想要进入数据分析或数据科学领域的任何人。如果您仅仅使用过电子表格，或依赖他人查询数据，本课程将帮助您掌握最有用的 SQL 功能，提升您的工作能力，即使您没有编程经验。一旦您掌握了独立查询数据的技能，便能够有效提取和分析数据，深入理解组织数据库中的信息。 本课程将提供一个基于保险索赔模型的金融数据库（易于理解），您将学习如何查询并提升技能。所有课程和练习都基于此数据库，您将有机会探索和研究数据之间的关系，这是其他课程通常无法提供的。同时，您将获得教师使用的所有代码，方便您跟进学习，并有练习的解决方案帮助您巩固技能。此外，您还可以通过问答环节与我直接互动！ 您学习的技术适用于多个平台，无论是使用 PostgreSQL、MySQL、AWS Athena，还是任何其他需要 SQL 查询的环境。一旦开始，您将能够快速将所学应用于任何地方。我们将从基础知识讲起，一直到行业中常用的高级功能，而不仅仅是您在其他课程中看到的基础内容。您很快就会成为 SQL 大师。那么，您还在等什么呢？
SQL really is the language of Data Analysis. This course will teach you the most useful querying techniques for industry.Unlike other courses you'll be taught with industry-style data.Learning to use SQL well, allows you to query the data in your organisation's databases so that you can answer the questions you have as a data and business professional. It is the "bread and butter" skill that data professionals have used for decades and it's as in-demand today as its ever been - especially on the cloud!. I've put together all of the useful topics I already teach in my day-job, into one convenient course for you!For anyone wanting to move into the field of Data Analysis or Data Science, or those who have only worked with spreadsheets, or relied on others to query the data for them, this course will help you grasp the most useful SQL functionality and enable you to grow in your role.. even if you have no programming experience. Once you have that skill to query data in different ways and without reliance on others, you'll be able to find useful ways to extract it and analyse it. It's only then that you gain insight into what organisational databases hold. This course comes with a financial database based upon an insurance claims model (something easily understood) which you'll learn to query and build your skills with. All the lessons and exercises will be based on this database so you'll have the freedom to explore and investigate relationships in the data that other courses aren't usually able to offer. You'll have access to all of the code used by the instructor so you can follow along, as well as the solution to exercises that you'll use to shore-up your skills. You'll also have access to me through Q & A of-course!The techniques you learn can be applied on multiple platforms. Whether you are using PostgreSQL, MySQL, AWS Athena, or any other environment that requires SQL for querying. Once you get started, you'll quickly be able to adapt what you learn for use anywhere.We'll take you through from the very basics, through to advanced functionality most commonly used in industry and not just the vanilla content you'll see in most other courses. You'll soon be a SQL hero. So what are you waiting for?
