|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/writing-advanced-sql-queries-on-postgresql/
课程评论：没有评论
**课程名称：** PostgreSQL 高级SQL查询 **课程概述：** 本课程旨在帮助数据科学家和分析师掌握 PostgreSQL 数据库的高级查询技巧。随着企业越来越多地使用 SQL 数据库存储交易数据和商业智能数据，理解和操作关系型数据存储变得至关重要。 **课程内容：** * **PostgreSQL 安装与基础查询：** 学习如何下载、安装 PostgreSQL，并进行基本的表查询。 * **聚合函数：** 深入了解 AVG, COUNT, SUM, MIN, MAX 等聚合函数，并学习如何运用它们进行数据汇总。 * **分析函数：** 学习使用各种分析函数，包括行号函数，以进行更复杂的数据分析。 * **操作符与连接：** 掌握各种 SQL 操作符，并学习如何使用不同类型的表连接（INNER JOIN, FULL OUTER JOIN, CROSS JOIN, NATURAL JOIN, LEFT JOIN）从多个表中检索数据。 * **窗口函数：** 学习使用窗口函数处理有序数据集，实现更高级的数据分析。 **学习目标：** 通过本课程，您将能够： * 熟练使用 PostgreSQL 进行数据聚合。 * 有效地分析数据。 * 通过表连接从多个表中检索数据。 * 编写更高级、更复杂的 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 advanced queries using various analytic and aggregate functions. What you will learn includes:Downloading and installing PostgreSQLQuerying tables Introduction to Aggregate FunctionsWriting queries to perform various aggregate functions like: AVG, COUNT, SUM, MIN,MAXIntroduction 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 setsPostgresql INNER JOINRetrieving all Data from TablePostgreSQL FULL OUTER JOINPostgreSQL CROSS JOINPostgreSQL NATURAL JOIN PostgreSQL Left Join The course will teach you how to aggregate data,analyse data ,retrieve data from multiple tables using table joins and write more advanced queries.
