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-06-05 09:30 | London, Westbourne Grove | From 1110 to 1590 GBP Check! | ||
| 2012-06-19 09:30 | Manchester | From 1110 to 1590 GBP Check! | ||
| 2012-07-04 09:30 | London, Westbourne Grove | From 1110 to 1590 GBP Check! | ||
| 2012-07-05 09:30 | Manchester | From 1110 to 1590 GBP Check! | ||
| 2012-07-17 09:30 | Bristol, Temple Gate | From 1110 to 1590 GBP Check! | ||
| 2012-07-30 09:30 | Bristol, Temple Gate | From 999 to 1431 GBP Check! | ||
| 2012-08-14 09:30 | Manchester | From 999 to 1431 GBP Check! | ||
| 2012-08-29 09:30 | London, Westbourne Grove | From 999 to 1431 GBP Check! | ||
| 2012-09-03 09:30 | Manchester | From 999 to 1431 GBP Check! | ||
| 2012-09-04 09:30 | London, Westbourne Grove | From 999 to 1431 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
