Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Delegates should be familiar with the Microsoft SQL Server SQL Language

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.

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