Course not currently available
Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server
Training
In City Of London ()
Description
-
Type
Training
-
Level
Advanced
-
Class hours
21h
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. Suitable for: Delegates should be familiar with the Microsoft SQL Server SQL Language.
Reviews
Subjects
- Transactions
- Database Design
- Microsoft Certifications
- Server
- SQL
- Database Administration
- Database training
- Programming
- IT
- IT Development
Course programme
Course review:
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
Advanced SQL, Stored Procedures & Triggers for Microsoft SQL Server