Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Course Code: advsqlpt

Duration: 14 hours

Prerequisites:

代表應熟悉 Microsoft SQL 伺服器 SQL 語言

Overview:

本課程的目的是清楚地瞭解 Microsoft SQL Server 的（SQL）的高級使用以及 Transact-SQL 的高級使用。如需更深入地瞭解主題，本課程可以作為為期三天的課程進行。

Course Outline:

結構化查詢語言綜述

DQL、DML、DDL
GROUP BY， HAVING 子句
子查詢和相關子查詢
高級更新和刪除語句
子查詢
相關子查詢

程式 Programming

變數
Control-of-Flow 語句
IF、WHILE、CASE、GOTO、RETURN

管理錯誤

回應錯誤
RAISERROR的
列印

使用事務

交易簡介
事務隔離級別
僵局
事務性錯誤處理

實現游標

聲明游標
打開、獲取、關閉
解除分配
電流

存儲過程

創建存儲過程
將值傳遞到存儲過程中
從存儲過程返回資訊
更改存儲過程

觸發器

創建觸發器
事務性錯誤處理
使用插入的表和已刪除的表

Sites Published:

United Arab Emirates - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Qatar - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Egypt - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Saudi Arabia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

South Africa - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Brasil - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Canada - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

中国 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

香港 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

澳門 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

台灣 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

USA - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Österreich - SQL für Fortgeschrittene, gespeicherte Verfahrensweise und Auslöser für Microsoft SQL Server

Schweiz - SQL für Fortgeschrittene, gespeicherte Verfahrensweise und Auslöser für Microsoft SQL Server

Deutschland - SQL für Fortgeschrittene, gespeicherte Verfahrensweise und Auslöser für Microsoft SQL Server

Czech Republic - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Denmark - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Estonia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Finland - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Greece - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Magyarország - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Ireland - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Luxembourg - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Latvia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

España - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Italia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Lithuania - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Nederland - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Norway - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Portugal - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

România - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Sverige - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Türkiye - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Malta - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Belgique - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

France - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

日本 - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Australia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Malaysia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

New Zealand - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Philippines - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Singapore - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Thailand - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Vietnam - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

India - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Argentina - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Chile - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Costa Rica - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Ecuador - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Guatemala - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Colombia - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

México - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Panama - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Peru - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Uruguay - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Venezuela - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Polska - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

United Kingdom - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

South Korea - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Pakistan - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Sri Lanka - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Bulgaria - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Bolivia - SQL (lenguaje de consulta estructurada) Avanzado, Procedimientos Almacenados y Disparadores para Microsoft SQL Server

Indonesia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Kazakhstan - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Moldova - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Morocco - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Tunisia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Kuwait - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Oman - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Slovakia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Kenya - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Nigeria - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Botswana - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Slovenia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Croatia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Serbia - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Bhutan - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Nepal - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Uzbekistan - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server