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.
Objectives:
Create, modify, and execute stored procedures
Create and modify triggers
Create and execute user-defined functions
Work with transactions, cursors, and locks
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
