|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-transact-sql-t-sql-window-functions/
课程评论：没有评论
**课程名称:** Microsoft SQL Server Transact-SQL (T-SQL) 窗口函数 **课程概述:** 本课程专为初次接触窗口函数，并希望超越传统查询方法，利用强大的窗口函数更高效地表达集合计算的 Transact-SQL (T-SQL) 开发人员设计。课程将从零开始教授窗口函数，帮助您理解窗口函数为 SQL 语言带来的新维度。 **学习目标:** * 理解窗口函数的概念和实际应用，包括： * 窗口函数的背景（描述、集合计算 vs. 迭代/游标编程） * 窗口函数的组成要素（分区 Partitioning, 排序 Ordering, 框架 Framing） * 支持窗口函数的查询元素（逻辑查询处理、支持窗口函数的子句、克服限制） * 聚合窗口函数（描述、支持的窗口要素） * 偏移窗口函数（支持的窗口要素、LAG 和 LEAD 函数、FIRST\_VALUE 和 LAST\_VALUE 函数） * 能够使用窗口函数将涉及 JOIN 和子查询的复杂、冗长的代码替换为几行简洁的代码。 * 弥合迭代/游标编程与集合计算编程之间的技能差距。 * 利用窗口函数为复杂的数据分析任务提供优雅的解决方案。 **先修要求:** * 具备中级到高级 T-SQL 查询技能。 * 熟悉以下内容： * 使用 JOIN、子查询、派生表和表表达式（例如，通用表表达式 CTEs）从多个表中提取数据。 * （熟悉 CTEs 将是优势）课程将教授如何将窗口函数与 CTEs 结合，以克服复杂的数据分析任务。 **教学方式:** * 视频课程，采用交互式、动画化的自定义用户界面（由 VBA 提供支持）。 * 通过动画、分步过程进行分析，以清晰地解释概念。 **课程资源:** * 课程结束时提供所有必需资源的下载： * AcotexDB.sql（可在 SSMS 中打开并运行以创建示例数据库） * 测验 * 编码练习（由 VBA 提供支持的交互式练习，提供独特的学习体验） * 编码练习的解决方案（包含所有编码练习解决方案的 Word 文档）
This course is designed and intended for Transact-SQL (T-SQL) developers who are new to window functions and wish to go beyond the traditional query approaches to express set calculations more efficiently using the powerful window functions. Students are not expected to have and knowledge of window functions. The primary purpose of the course is to teach window functions from scratch. This course is designed to bring an understanding of the new dimension that window functions bring to the SQL language.At the end of the course you will understand the concepts and practical applications of window functions including:Background of window functions (description of window functions, set-based vs. iterative/cursor programming)Elements of window functions (Partitioning, Ordering, Framing)Query elements supporting window functions (logical query processing, clauses supporting window functions, circumventing the limitations)Aggregate window functions (description of aggregate window functions, supported windowing elements)Offset window functions (supported window elements, LAG and LEAD functions, FIRST_VALUE and LAST_VALUE functions)Students are expected to have intermediate to advanced T-SQL querying skills and comfortable with:Extracting data from multiple tables with joins, subqueries, derived tables, and table expressions (e.g. Common Table Expressions CTEs).A good understanding of Common Table Expressions (CTEs) will be advantageous. Where window functions on their own cannot achieve a task, we teach how to combine window functions with CTEs to overcome complex data analysis tasks.At the end of the course, you will be able to:Replace any existing complex and lengthy codes involving joins and subqueries with a few lines of code using window functionsBridge the skill gap between iterative/cursor programming and set-based programmingUse window functions to achieve elegant solutions to complex data analysis tasksThe course is video-based using an interactive and animated, custom designed user interface powered by VBA. Analysis are performed using animated, step-by-step processes to explain conceptsAll resources needed for the course are included in the last lesson for download:AcotexDB.sql (open and run in SSMS to create the sample database)QuizzesCoding Exercises - Interactive exercises powered by VBA to provide you with a unique learning experienceSolutions to coding exercises - Word document containing the solutions for all the coding exercises
