Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
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.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Server
- SQL
Course programme
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
- Variables
- Control-Of-Flow Statements
- IF, WHILE, CASE, GOTO, RETURN
- Responding To Errors
- RAISERROR
- Introduction To Transactions
- Transaction Isolation Levels
- Deadlocks
- Transactional Error Handling
- Declaring Cursors
- OPEN, FETCH, CLOSE
- DEALLOCATE
- CURRENT OF
- Creating Stored Procedures
- Passing values into a Stored Procedure
- Returning Information From Stored Procedures
- Altering Stored Procedures
- Creating Triggers
- Transactional Error Handling
- Using Inserted and Deleted Tables
Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server Training Course