|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-mastery-for-data-science/
课程评论：没有评论
**SQL Mastery For Data Science 课程总结** 本课程专注于培养数据科学和分析领域至关重要的 SQL 技能。通过实践操作，您将学会如何从关系型数据库中加载、提取和处理数据。您还可以按照自己的节奏学习，不断提升 SQL 能力。 课程内容涵盖了数据科学与分析中最常见的问题，例如： * 找出每个类别的热门产品 * 按月计算活跃员工数量 * 计算销售额的滚动平均值 课程将从使用 SQL Server 和 AdventureWorks 检索数据开始，逐步深入讲解如何聚合、连接（join）和过滤数据以构建分析的上下文。此外，您还将学习如何使用排名（ranking）、移动平均（moving averages）和窗口函数（window functions）来解答更复杂的分析问题。 具体学习内容包括： * 数据检索 * 表连接（Joining Tables） * 滚动平均值和排名的计算 * 日期和时间数据的处理 * 窗口函数的使用 * 数据聚合与过滤 SQL 是数据科学领域需求最旺盛的技能之一。本课程非常适合任何希望提升自身技能并达到新高度的学习者。通过本课程，您将掌握结构化查询语言（SQL），能够有效地提取和分析存储在数据库中的数据。课程初期将教授基础的数据提取、表连接和聚合操作，随后会深入讲解如何利用子查询（subqueries）和窗口函数进行更复杂的数据分析和处理。 学完本课程后，您将能够编写高效的 SQL 查询，成功应对各种数据分析任务。
Gain the career-building SQL skills you need with this course. Through hands-on learning you'll load, extract, and manipulate data from relational databases. Study at your own pace and grow your SQL skills.In this course, we'll go over the most common data science and analytics questions that you'll receive, such as how to find the top products per category, how to find active employee counts by month, how to calculate rolling average of sales and much more. We'll start by showing you how to retrieve data from a database using SQL Server and AdventureWorks, then show you how to aggregate, join, and filter your results to create context for your analysis. We'll also get into answering more complex questions with ranking, moving averages, and window functions. Learn how to retrieve data, join tables, calculate rolling averages and rankings, work with dates and times, use window functions, aggregate and filter data, and much more. SQL is one of the most requested skills in Data Science. This course is great for anyone looking to build their skills and take it to the next level. Learn to use Structured Query Language (SQL) to extract and analyze data stored in databases. You'll first learn to extract data, join tables together, and perform aggregations. Then you'll learn to do more complex analysis and manipulations using subqueries, and window functions. By the end of the course, you'll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.
