|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-461-session-6-querying-microsoft-sql-server-2012/
课程评论：没有评论
本课程是 Microsoft 认证 70-461：“查询 Microsoft SQL Server 2012/2014”的基础。虽然此认证已不再提供，但其考试要求仍能帮助您深入理解 T-SQL。 **课程内容概要：** * **子查询（Subqueries）：** 学习在 WHERE、FROM 和 SELECT 子句中创建子查询，包括相关子查询（其结果依赖于主查询）。 * **通用表表达式（Common Table Expressions, CTE）：** 使用 WITH 语句创建 CTE。 * **PIVOT 和 UNPIVOT：** 学习如何进行数据透视和逆透视操作，并运用所学知识解决实际业务问题。 * **函数（Functions）：** 掌握用户定义函数（UDF）的三种类型：标量函数、内联表值函数和多语句表值函数。 * **其他 T-SQL 特性：** 学习同义词（Synonyms）、动态 SQL（Dynamic SQL）、GUIDs 和序列（Sequences）。 * **数据操作：** 学习如何使用 XML 数据，包括解析（Shredding）和查询；如何操作 JSON 数据；以及如何探索时间序列数据（Temporal Data），以便查询表中旧版本的数据。 **前提知识：** 只需要掌握本系列课程前 5 次课的内容。 **学习成果：** 掌握子查询、函数、序列等 T-SQL 编程技巧，并显著扩展您对 T-SQL 的整体认知。课程中包含定期测验，以巩固学习效果。
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014". 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.Welcome to Session 6 of this T-SQL course.We'll start with creating sub-queries, in the WHERE, FROM and SELECT clause. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions (CTE) using the WITH statement and PIVOTting and UNPIVOTting, and we'll be using what we have learned to solve a common business problem.We'll be looking at functions, including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then look at synonyms, dynamic SQL, and GUIDs. We'll also look at sequences.Finally, we'll look at use XML data, shredding and querying it, manipulating JSON data, and exploring Temporal Data, so you can query data that used to be in your tables.No prior knowledge other than what we covered in Sessions 1 to 5 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 subqueries, functions, sequences and more, and we'll have expanded on our current knowledge of T-SQL.
