|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-managers-products-and-business-leaders/
课程评论：没有评论
**课程名称：** SQL for managers, products and business leaders **课程概述：** 这门课程旨在帮助您掌握基础的SQL技能，从而无需依赖IT或分析师，即可独立从数据库中提取和处理数据，显著提升工作效率。课程将聚焦于数据提取和基本数据操作所需的SQL知识，避免不必要的编程细节。 **课程内容：** * SQL基础概念：了解SQL的作用和基本查询。 * SQL环境介绍：熟悉SQL的常见应用场景，特别是Google BigQuery云数据库。 * 数据提取与操作：学习如何使用SQL提取、连接（left, right, full join）和聚合数据。 * 核心SQL语句：重点讲解 `WHERE` 子句的逻辑，以及别名（Aliases）的使用。 * 常见错误与解决：识别并学习如何解决SQL查询中常见的错误。 * 进阶概念：理解 `HAVING` 和 `WHERE` 的区别，以及常用函数。 * 代码风格与实践：讨论良好的SQL代码风格，并通过实际的分析任务进行练习。 **目标学员：** * 希望独立获取和分析数据的管理者、产品经理和业务负责人。 * 希望打下坚实SQL基础的初级分析师。 **教师背景：** 拥有8年以上数据分析经验，精通SQL、R、Python、Excel和BI工具。曾负责新分析师的入职培训和组织内部的数据素养提升工作。
Have you ever had a need for getting data and been stuck with your IT or analyst who needs time to process your request? Well, you need no more. You can drastically increase your productivity and shorten waiting time if you could write simple SQL for yourself!This course is designed to give you an easy introduction to SQL which allows you to get value from databases right after the course. No unnecessary programming details, just what you need to extract and work with data.We are going to talk about SQL basics which are useful for data extraction and main manipulations. If you are an analyst yourself this course will be useful for you because this will give a nice and meaningful start in your journey into the depth of SQL. You could practice them on the platform or ask for access from me to practice on my Google Big Query demo server to get a hand on a real databaseWe are going to talk not only about code but also about the SQL environment, where exactly you can encounter it. I will familiarise you with one of the most popular cloud-based databases Google Big Query. This experience will allow you to understand intuition and reuse this knowledge in different databases and SQL dialects. Then we will discuss the code and practice it on some analytic-related tasks. We are going to find out how to extract, join, and aggregate data. Then we are going to discuss important concepts of code style and typical errors.In this course:- What is SQL- SQL environment- Basic SQL query- Logic behind filtering (where)- Aliases- Typical errors and how to resolve them- Join (left, right, full) and aggregations- Functions- Difference between HAVING and WHEREI am an 8+ year expert in Data analytics and work a lot with SQL, R, Python, Excel, and BI tools. Also, I am a team lead and responsible to onboard new analysts and teaching people across my organization to be more data savvy. Now I can help you to be more data-savvy!
