CourseForMe

AdvancedSQL,Stored Procedures and Triggers for MicrosoftSQLServe

NobleProgUS
NobleProgUS

Detailed information

Type:Courses
Method:Onsite
Duration:14 Hour
Total hours of lesson:7
Requirements:Delegates should be familiar with the Microsoft SQL Server SQL Language
Students per class:6

Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to register, enrollment limit, availability and more.

Request information

Course program

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

Course location

Search similar to Other Database

Sponsored links