Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course

Duration

14 hours (usually 2 days including breaks)

Requirements

Delegates should be familiar with the Microsoft SQL Server SQL Language

Overview

The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day course.

Course Outline

Review of Structured Query Language

DQL, DML, DDL
The GROUP BY, HAVING Clause
Sub-queries and Correlated Sub-queries
Advanced Update & Delete Statements
Sub-queries
Correlated Sub-queries

Procedural Programming

Variables
Control-Of-Flow Statements
IF, WHILE, CASE, GOTO, RETURN

Managing Errors

Responding To Errors
RAISERROR
PRINT

Using Transactions

Introduction To Transactions
Transaction Isolation Levels
Deadlocks
Transactional Error Handling

Implementing Cursors

Declaring Cursors
OPEN, FETCH, CLOSE
DEALLOCATE
CURRENT OF

Stored Procedures

Creating Stored Procedures
Passing values into a Stored Procedure
Returning Information From Stored Procedures
Altering Stored Procedures

Triggers

Creating Triggers
Transactional Error Handling
Using Inserted and Deleted Tables