|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/70-461-session-4-querying-microsoft-sql-server-2012/
课程评论：没有评论
课程名称：70-461 Session 4: 查询 Microsoft SQL Server (T-SQL 代码) 课程概述： 本课程是 Microsoft 证书 70-461：“查询 Microsoft SQL Server 2012/2014” 的基础。虽然该证书已不再提供，但考试要求使您能够深入理解 T-SQL。 在本课程中，您将学习： * **创建存储过程**：通过创建存储过程来封装例程，从而仅用一条语句执行带参数的命令。 * **添加错误处理**：使用 TRY、CATCH 和 THROW 来处理错误。 * **组合和比较数据集**： * 使用 UNION 和 UNION ALL 组合数据集。 * 使用 INTERSECT 和 EXCEPT 比较数据集。 * 使用强大的 MERGE 语句进行条件插入、更新和删除。 * **创建条件逻辑**： * 使用 CASE 语句（相当于 Excel 中的 IF 语句）。 * 使用 ISNULL 和 COALESCE 替换 NULL 值。 先修要求： 除课程 Sessions 1 至 3 的内容外，无需其他先修知识。具有 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.Welcome to Session 4 of this T-SQL course. In this course:We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement.We'll add some error handling with TRY, CATCH and THROW. We'll also combine datasets together and compare them, by looking atUNION and UNION ALL, which allows us to combine sets, INTERSECT and EXCEPT, which compares datasets, and the mighty MERGE statement, which allows for conditional INSERT, UPDATE and DELETEs.We'll also create conditional logic:CASE, the equivalent of the IF statement in Excel, ISNULL and Coalesce, which replaces NULLs,No prior knowledge other than what we covered in Sessions 1 to 3 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 procedures, add error handling, and combine datasets together and compare them, and we'll have expanded on our current knowledge of T-SQL.
