|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-461-session-5-querying-microsoft-sql-server-2012/
课程评论：没有评论
课程名称：70-461 Session 5: 查询 Microsoft SQL Server (T-SQL 代码) 课程概述： 本课程是 Microsoft 证书 70-461：“查询 Microsoft SQL Server 2012”的基础。请注意，此证书已不再提供。然而，考试要求使您能够对 T-SQL 有深入的了解。 课程将涵盖： * 创建聚合查询，使用 `OVER()` 子句，以及 `PARTITION BY` 和 `ORDER BY`。 * 比较和对比 `RANGE` 和 `ROWS`，以及它们如何与 `CURRENT ROW` 和 `UNBOUNDED` 一起工作。 * 复习排名函数：`ROW_NUMBER`、`RANK`、`DENSE_RANK` 和 `NTILE`。 * 了解 SQL Server 2012 新增的 8 个分析函数，如 `LAG`、`LEAD`、`FIRST_VALUE` 和 `LAST_VALUE`。 * 探索分组和添加总计的替代方法，使用 `ROLLUP`、`CUBE`、`GROUPING SETS` 和 `GROUPING_ID`。 * 学习几何和地理数据类型，在网格上绘制位置，并结合函数和聚合。 先决条件： 除前 4 个课程所涵盖内容外，无需任何先验知识。本课程建立在之前知识的基础上。 课程形式： 包含定期测验以帮助巩固学习。 学习成果： 完成课程后，您将能够： * 编写排名函数。 * 编写分析函数。 * 使用分组集。 * 执行空间聚合。 * 扩展 T-SQL 的现有知识。
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012". Please note - this certificate is no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL.We will now be creating aggregate queries, using the OVER() clause, together with PARTITION BY and ORDER BY. We'll also compare and contrast RANGE and ROWS, and how they work with CURRENT ROW and UNBOUNDED.We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions new to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. We'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.No prior knowledge other than what we covered in Sessions 1 to 4 is required. This course builds on the knowledge previously gained in those previous sessions.There are regular quizzes to help you remember the information.Once finished, you will know what how to write ranking functions, analytic functions, grouping sets and spatial aggregates, and we'll have expanded on our current knowledge of T-SQL.
