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