|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-461-session-3-querying-microsoft-sql-server-2012/
课程评论：没有评论
**课程名称：** 70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) **课程概述：** 本课程是微软 70-461 认证“查询 Microsoft SQL Server 2012/2014”的基础。尽管该认证已停产，但课程内容能帮助您深入理解 T-SQL。 课程将从创建视图开始，学习如何将 SELECT 查询保存以供将来使用，并添加安全性及创建索引视图。 随后，将学习创建 AFTER 和 INSTEAD OF 触发器，这些触发器可在 INSERT、DELETE 或 UPDATE 数据时自动运行代码，并探讨触发器触发触发器的情况以及如何处理一个会话中的多行数据。 课程还会回顾之前开发的数据库，识别其中存在的问题，并通过添加 UNIQUE, CHECK, PRIMARY KEY 和 FOREIGN KEY 等约束来解决这些问题，以防止错误数据的录入。 **先决条件：** * 除了 Session 1 和 Session 2 的内容外，无需其他先决知识。 * 具备 Excel 或 Access 的经验将有所帮助。 **课程特色：** * 包含定期测验，帮助巩固学习内容。 **学习目标：** 完成课程后，您将掌握如何编写触发器、视图和约束，并对 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.We'll start off by creating views, which enable us to store these SELECT queries for future use. We'll add security and create indexed views.We'll then create AFTER and INSTEAD OF triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data. We'll look at what happens when triggers run triggers, and how to handle multiple rows in a session.We'll look at the database that we previously developed, and see what is wrong with it. To solve these problems, we'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints. This will stop erroneous data from being added some data.No prior knowledge other than what we covered in Sessions 1 and 2 is required. However, prior experience with Excel or Access would be beneficial.There are regular quizzes to help you remember the information.Once finished, you will know what how to write triggers, views and constraints, and we'll have expanded on our current knowledge of T-SQL.
