|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-with-postgresql-analytic-aggregate-functions/
课程评论：没有评论
**课程名称：** 使用 PostgreSQL 进行数据分析：分析聚合函数 **课程概述：** 随着数据量不断增长，能够分析日常应用程序（如 Facebook、Instagram、银行应用程序等）中使用和依赖的海量数据的专业人士的需求也日益增长。本课程将重点介绍 PostgreSQL 数据库中的聚合函数和分析函数。 * **聚合函数**：对一组值执行计算并返回单个值。 * **分析函数**：基于一组值计算聚合值，与聚合函数不同，它可以为每组值返回多行。 课程将深入探讨聚合函数和分析函数在查询和分析数据时的区别和应用场景。 **核心内容：** * 了解聚合函数的基本用法，以及与 `GROUP BY` 子句的结合使用。 * 学习分析函数如何为数据集中的每个输入行返回一个值，从而提高查询效率并降低复杂性。 * 掌握分析函数在金融、科学等领域中用于趋势分析、异常值检测和分箱分析的实际应用。 * 通过在 PostgreSQL 数据库中进行实际操作，运用聚合函数和分析函数进行数据查询和分析。 **学习目标：** 通过本课程的学习，学员将能够： * 熟练运用 PostgreSQL 中的聚合函数和分析函数。 * 理解聚合函数和分析函数的内在区别及其适用场景。 * 能够编写更高效、更复杂的 SQL 查询来分析大规模数据集。 * 将所学知识应用于实际数据分析任务。
Due to the ever increasing reliance and growth of data there is even a greater demand for professionals who can help analyse these large volume of data that is used daily in applications that we use and rely on daily like Facebook, Instagram,bank apps etc. Aggregate functions perform a calculation on a set of values and return a single value. Analytic functions compute an aggregate value based on a set of values, and, unlike aggregate functions, can return multiple rows for each set of values. If you want to run a query using only aggregate functions, the query will return one row with a column for each field. If you want to run a query using an aggregate function in conjunction with the GROUP BY function, the query will return one row for each value found in the grouped field. If you want to run a query using an analytic function, the query will return one row for each field in the defined range of fields used to perform the calculations.If you use an aggregate function with any other function in a query, one field in the query must contain the GROUP BY function. Analytic functions are frequently used in fields such as finance and science to provide trend, outlier, and bucketed analysis for large data sets Unlike traditional aggregation functions, which return only a single value for each group defined in the query, Analytic functions return a single value for each input row.They increase the efficiency and reduce the complexity of queries that analyse partitions (windows) of a data set. This course will use aggregate and analytic functions to query and analyse data from a PostgreSQL database.
