|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-sql-window-functions/
课程评论：没有评论
课程名称：SQL窗口函数入门 课程概述： 本课程旨在深入介绍SQL窗口函数（也称为windowing functions, OVER functions, 或 analytic functions），这些函数对于构建复杂的聚合操作极具价值，能够极大地简化数据分析过程。通过分步教学，本课程将帮助您轻松掌握窗口函数，并自信地在SQL数据库中应用它们。 课程内容将涵盖如何将常见的业务问题，如月度营收增长、累计营收、数据重复性检查、每月订单排名、复购行为分析等，转化为SQL查询。您将学习窗口函数的语法和语义，理解其强大之处，掌握典型的应用场景，以及如何使用`ORDER BY`和`PARTITION BY`子句来定义窗口函数的计算范围。此外，课程还将区分`ROWS`和`RANGE`子句的用法。 课程主题包括： * Oracle数据库的安装 * TOAD和SQL Developer的安装 * TOAD和SQL Developer连接Oracle数据库 * 分析型窗口函数的结构 * 聚合函数 * 分析函数 * 窗口函数的工作原理 通过本课程，您将学会： * 计算运行总计和运行平均值 * 进行排名（包括使用`DENSE_RANK`） * 查找首尾值 * 使用`OVER`子句 * 使用`PARTITION BY`子句 * 使用`ORDER BY`子句 * 使用窗口子句 您还将对SQL的聚合函数和分析函数有更深入的理解。 目标学员： * 初级数据库分析师 * 希望保持SQL知识更新的开发人员 * 学习关系型数据库的学生 * 任何希望学习SQL窗口函数的个人
SQL window functions -also known as windowing functions, OVER functions, or analytic functions - are tremendously useful. These functions make building complex aggregations much simpler. In this step-by-step course , I will lead you through SQL window functions. At its end, you'll embrace this topic with ease and feel comfortable using window functions in SQL databases. The most popular business problems can be solved with SQL. What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions have to be translated from business language to programming language. This course covers the syntax and semantics of SQL window functions. It shows how powerful they are, what the typical use cases are, and how to use ORDER BY and PARTITION BY to set up a frame for window functions. You'll also learn the difference between ROWS and RANGE clauses. Topics covered includes: Installing Oracle databaseInstalling TOADInstalling SQL developerConnecting TOAD and SQL Developer to Oracle DatabaseAnatomy of Analytic Window functionsAggregate functionsAnalytic functionsHow windowing worksWhat Am I Going To Get from This SQL Window functions Course?You'll discover how window functions can be used to:Compute running totals and running averagesBuild rankingsUse DENSE RANKFind first and last valuesUse OVER clauseUse Partition By clauseUse Order By clauseUse Windowing clauseYou'll also get a deeper understanding of SQL aggregate and analytic functions. Who Should Take This Course? Beginning database analystsDevelopers who want to keep their knowledge of SQL currentStudents taking classes in relational databasesAnyone who wants to learn SQL window functions
