MP9004: Microsoft - Database Programming > SQL Server 2000 Database Design MCSE 70-229

This course shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming. 

Topics:
Introduction to stored procedures
Guidelines for creating stored procedures
Creating stored procedures
Modifying stored procedures
Working with stored procedures
Error handling within stored procedures
Introduction to triggers
Creating triggers
Using INSTEAD OF triggers
Modifying triggers
Introduction to functions and UDFs
Scalar-valued and table-valued UDFs
System UDFs and functions
Obtaining information about UDFs
Transactions
Transaction isolation levels
Cursors
Locks

Objectives:
Create, modify, and execute stored procedures
Create and modify triggers
Create and execute user-defined functions
Work with transactions, cursors, and locks

Duration:
4 Hours