Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Feb 15, 2011
Language:English
Audiences:Developer
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

This two-hour course provides you with the knowledge and skills required to implement stored procedures and triggers in Microsoft SQL Server 2008 R2.

This course covers the following topics.
Describing stored procedures and triggers
Creating and managing stored procedures
Creating and managing triggers
Using error handling techniques
Controlling execution context
Best practices for implementing stored procedures and triggers

This course helps you prepare for Exam 70-433: Microsoft SQL Server 2008, Database Development.

The prerequisites for this course are as follows:
A good general knowledge of database concepts.
Experience working with Windows and programming concepts.
Understanding of server management concepts such as roles and tracing.
A basic understanding of XML.

Objective: 

Describe stored procedures and triggers.
Create and Manage stored procedures.
Create and Manage triggers.
Use error handling techniques.
Control Execution context.
Describe best practices for implementing stored procedures and triggers..

Prerequisites: 

None

For more information on Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2 (E-Learning) please feel free to contact us online or call us at 416-513-1535.