Course 10366: Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2

Introduction 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.

Objectives At the end of the course, students will be able to:

• 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.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2 Module Overview Introduction to Stored Procedures and Triggers Introduction to Stored Procedures and Triggers Stored Procedures and Triggers Types of Stored Procedures DML Triggers DDL Triggers Benefits of Stored Procedures and Triggers Self Test Creating and Managing Stored Procedures Creating and Managing Stored Procedures Syntax for Stored Procedures Syntax for Altering and Dropping Stored Procedures Parameterized Stored Procedures Working with Input Parameters Using Table-Valued Parameters Working with Output Parameters Self Test Creating and Managing Triggers Creating and Managing Triggers Syntax for DML Triggers Create After Triggers Create Instead Of Triggers Nested and Recursive Triggers Syntax for DDL Triggers Create a DDL Trigger Self Test Handling Errors in Operations Handling Errors in Operations Handling Errors Structured Error Handling Using Error Handling Techniques Error Handling Guidelines Self Test Controlling Execution Context Controlling Execution Context What is Execution Context? EXECUTE AS Clause Scenarios for Using EXECUTE AS Clause Using the EXECUTE AS Clause Self Test Best Practices Best Practices Lab: Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2 Lab: Implementing Stored Procedures and Triggers in Microsoft SQL Server 2008 R2 Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled