Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
課程簡介
結構化查詢語言綜述
- 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
Course - 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
Course - 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.
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Open, frank and knowledgeable
Shiva Wagle - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
It is interactive
Syed Muhammad Mehdi - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The content of the training
Kyvin Aw - Asure Quality LTD
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The range of topics and challenging challenges
