|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-advanced-t-sql-for-sql-server-administrator/
课程评论：没有评论
课程名称：学习高级T-SQL以供SQL Server管理员使用 课程概述：本课程将带领学生深入学习存储过程、条件语句（If Else）、循环（While Loop）、游标、派生表、公共表表达式（CTEs）、存储过程权限、临时表、存储过程参数等多个重要主题。课程结束时，学生将获得关于存储过程的重要知识，学习如何在生产环境中阅读和使用存储过程。此外，课程还将提供块语句、事务命令、递归CTE、错误处理、变量等示例。该课程特别适合希望理解如何阅读、修改和执行简单至复杂存储过程的学生。通过创建存储过程，开发人员可以更好地控制SQL命令的执行、权限以及在更新存储过程时的灵活性。
The student will learn about stored procedures, If Else, While Loop, cursors, derived tables, CTEs, sproc permissions, temp tables, sproc parameters and much more. The student at the end of this course will gain valuable information about sprocs and how to read and follow them in the production environment. In addition, the student will be given examples of block statements, transactions commands, recursive CTEs, error handling, variables, and much more. This course will greatly help those students that want to understand how to read, modify, and execute from simple to complex stored procedures. By creating stored procedures, the developer has greater control in the execution of SQL commands, permissions, and greater flexibility in updating the sproc.
