|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-advanced-sql-queries-and-data-analysis/
课程评论：没有评论
coursera 课程 **PostgreSQL: Advanced SQL Queries and Data Analysis** **课程概述:** 本课程是关于 PostgreSQL（也称为 Postgres）这一开源数据库的进阶 SQL 查询与数据分析。随着数据量的不断增长，数据科学家和分析师掌握关系型数据存储的需求日益迫切。企业长期以来一直使用 SQL 数据库存储交易数据和商业智能相关数据。本课程将帮助您学习如何在关系型数据库中执行常见的数据科学任务，包括编写高级查询、数据分析、数据查找、探索和提取。 **您将学到:** * **PostgreSQL 触发器:** 介绍、创建、管理触发器。 * **视图 (Views):** 介绍、创建、修改和删除视图，以及可更新视图的创建。 * **物化视图 (Materialized Views):** 介绍和创建物化视图。 * **存储过程 (Stored Procedures):** 基础介绍。 * **聚合函数 (Aggregate Functions):** 介绍各种类型的聚合函数。 * **分析函数 (Analytic Functions):** 介绍各种类型的分析函数，包括行号函数。 * **运算符 (Operators):** 介绍各种类型的运算符。 * **表连接 (Table Joins):** 介绍各种类型的表连接，包括 INNER JOIN, NATURAL JOIN, FULL OUTER JOIN, CROSS JOIN, LEFT JOIN，以及如何结合 AND 和 OR 运算符。 * **PostgreSQL 特有运算符:** LIKE, OR, UNION, UNION ALL, EXCEPT, INTERSECT, IN。 * **窗口函数 (Windowing Functions):** 用于处理有序数据集。 * **PostgreSQL 安装与验证:** 学习如何安装 PostgreSQL 并验证安装。 * **数据库对象:** 了解 Server service, Sequences, Schema。 * **数据检索与加载:** 如何从表中检索所有数据，以及如何加载示例数据库。 * **数据类型转换 (Cast):** 学习使用 Cast 和运算符。 **核心内容:** 课程将教授您如何聚合数据、分析数据、使用表连接从多个表中检索数据，以及编写更高级的 SQL 查询。
PostgreSQL is commonly known as Postgres and it is also open source database. There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common relational database and data science tasks, including writing advanced queries,data analysis , finding, exploration, and extraction within relational databases. What you will learn includes:Introduction PostgreSQL TriggersCreating TriggersManaging TriggersIntroduction to ViewsHow to create viewsModifying and Removing ViewsIntroduction to Updatable ViewsCreating Updatable ViewsIntroduction to Materialized ViewsCreating Materialized ViewsIntroduction to Stored ProceduresIntroduction to Aggregate FunctionsIllustrating various types of Aggregate functionsIntroduction to Analytic FunctionsIllustrating various Analytic functionsRow Number FunctionsUsing various types of OperatorsIntroduction to Table JoinsUsing various types of joinsWindowing functions for working with ordered data setsInstalling PostgreSQLVerify postgresql installationPostgresql INNER JOINPostgres LIKE OperatorPostgresql OR OperatorServer serviceSequencesSchemaRetrieving all Data from TableLoading sample databasePostgresql UNION OperatorPostgreSQL UNION ALL OperatorPostgreSQL FULL OUTER JOINPostgreSQL CROSS JOINPostgreSQL combining AND OR OperatorPostgreSQL AND OperatorPostgreSQL NATURAL JOIN OperatorPostgreSQL EXCEPT OperatorPostgreSQL INTERSECT OperatorPostgreSQL Left JoinPostgreSQL IN OperatorCast and Operators The course will teach you how to aggregate data,analyse data ,retrieve data from multiple tables using table joins and write more advanced queries.
