United Kingdom [select]
Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course
Node ID: 9372
Duration
14 hours
Requirements
Delegates should be familiar with the Microsoft SQL Server SQL Language
Public Course Dates
Can't find a course date that suits your needs below?
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
Then just submit a public course date request now!
And we will organize the training at a location and date to suit you.
Request Public Course Date >>
| Date | Venue | Price | ||
|---|---|---|---|---|
| 2012-02-29 09:30 | London, Westbourne Grove | From 970 to 1390 GBP Check! | ||
| 2012-03-06 09:30 | Bristol, Temple Gate | From 970 to 1390 GBP Check! | ||
| 2012-03-08 09:30 | Manchester | From 970 to 1390 GBP Check! | ||
| 2012-03-29 09:30 | Bristol, Temple Gate | From 970 to 1390 GBP Check! | ||
| 2012-04-02 09:30 | London, Westbourne Grove | From 970 to 1390 GBP Check! | ||
| 2012-04-11 09:30 | Manchester | From 873 to 1251 GBP Check! | ||
| 2012-04-25 09:30 | Bristol, Temple Gate | From 873 to 1251 GBP Check! | ||
| 2012-04-25 09:30 | Manchester | From 873 to 1251 GBP Check! | ||
| 2012-05-08 09:30 | London, Westbourne Grove | From 873 to 1251 GBP Check! | ||
| 2012-05-21 09:30 | Bristol, Temple Gate | From 873 to 1251 GBP Check! |
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.
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
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
