感谢您发送咨询！我们的团队成员将很快与您联系。
感谢您发送预订！我们的团队成员将很快与您联系。
课程大纲
结构化查询语言综述
- DQL、DML、DDL
- GROUP BY， HAVING 子句
- 子查询和相关子查询
- 高级更新和删除语句
- 子查询
- 相关子查询
程序 Programming
- 变量
- Control-of-Flow 语句
- IF、WHILE、CASE、GOTO、RETURN
管理错误
- 响应错误
- RAISERROR的
- 打印
使用事务
- 交易简介
- 事务隔离级别
- 僵局
- 事务性错误处理
实现游标
- 声明游标
- 打开、获取、关闭
- 解除分配
- 电流
存储过程
- 创建存储过程
- 将值传递到存储过程中
- 从存储过程返回信息
- 更改存储过程
触发器
- 创建触发器
- 事务性错误处理
- 使用插入的表和已删除的表
要求
代表应熟悉 Microsoft SQL 服务器 SQL 语言
14 小时
客户评论 (7)
Lot of content and exactly the requested one.
Pascal - Diehl
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
There were a lot of exercises really good exercises and the trainer passed on his knowledge well.
Zsolt - Diehl
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Communicative, big knowledge and well presented material
Filip Gotowicki - EY GDS (CS) POLAND SP. Z O.O.
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Open, frank and knowledgeable
Shiva Wagle - Mosaic Primary Care Network
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
It is interactive
Syed Muhammad Mehdi - Mosaic Primary Care Network
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The content of the training
Kyvin Aw - Asure Quality LTD
课程 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The range of topics and challenging challenges
