|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-punk-analytics/
课程评论：没有评论
课程名称：SQL 数据分析大师班 课程概述： 本课程旨在帮助学习者掌握使用 SQL 进行数据分析的技能。随着越来越多的数据存储在 SQL 数据库中，如何有效获取和分析这些数据成为了一项重要任务。无论使用的是 SQL Server、Oracle 还是其他数据库产品，编写 SQL 代码进行数据分析的过程可能会令人生畏且复杂，因此我们开发了本课程。 在本课程中，我将教您如何编写 SQL 代码来进行数据分析，从而解答您在工作中可能遇到的复杂问题。您是否了解 SQL 查询中可以应用的所有表连接类型？您是否使用过既简单又强大的 OUTER APPLY？您能否用一行 SQL 写出运行总和？ROLLUP 语句该如何使用，它的作用是什么？什么是 LAG()？如果您无法回答这些简单问题，那么本课程将大大改变您的理解与能力。 为了帮助您更好地掌握这些知识，课程提供了丰富的学习材料，包括示例数据库（包含真实数据）、代码脚本、实践练习和测验。同时，课程还提供30天退款保证，确保您如未能获得预期效果，可以申请退款。 诚挚问候， Paul 数据分析师和可视化工程师
Greetings,With so much data stored in SQL databases, how can we get at it ?You use SQL to get at this data, no matter what the SQL Database product is (e.g SQL Server, Oracle and many more). Coding SQL to analyse data can be a daunting and complex task, hence the reason for building this course.In this course I will teach you how code SQL to perform data analysis in order to answer complex questions that you will encounter daily in your job. Ask yourself these simple questions...Do you know all of the TABLE JOIN types that can be applied in a SQL query ? Have you ever used OUTER APPLY, which is so easy and powerful to use ?Can you write a running total in a single line of SQL ? Where do you use a ROLLUP statement and why would you use it ? What is LAG() ?If you could not answer these simple questions then this course will definitely change all of that for you.You definitely should know all of this to survive the SQL environment you work in! All course materials are provided e.g. Sample databases (with real data), code scripts, practice exercises and quizzes.Don't forget, there is a 30 Day money back guarantee if this course does not deliver what you expected.Best RegardsPaulData Analyst and Visualisation Engineer
