|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-461-session-7-querying-microsoft-sql-server-t-sql/
课程评论：没有评论
**课程总结：70-461 Session 7: 微软 SQL Server 查询 (T-SQL 代码)** 本课程是 Microsoft 认证 70-461：“查询 Microsoft SQL Server 2012/2014” 的基础。虽然此认证已不再提供，但其考试要求能帮助您深入理解 T-SQL。 **本课程涵盖以下内容：** * **事务处理：** 学习如何显式开始和结束事务，以及它们如何阻塞其他用户。 * **索引优化：** 了解并创建聚集索引、非聚集索引和堆，以及它们在查询优化中的作用。 * **动态管理视图 (DMV)：** 使用 DMV 查看并改进索引使用效率。 * **游标：** 学习如何编写游标，以及何时使用这种基于行的操作。 * **标量用户自定义函数 (UDF)：** 了解标量 UDF 的影响。 **前提条件：** 仅需具备 Sessions 1 至 6 的知识。本课程将在此基础上进行扩展。 **课程成果：** 完成本课程后，您将掌握如何创建事务、索引、游标、处理 XML 数据等，并大幅扩展您现有的 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 7 of this T-SQL course. In this session:We will be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to create clustered and non-clustered indexes and heaps, and their role in optimising queries. We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and The impact of using scalar UDFs.No prior knowledge other than what we covered in Sessions 1 to 6 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 create transactions, indexes, cursors, XML data and more, and we'll have expanded on our current knowledge of T-SQL.
