SQL Server 2000 Database Design MCSE 70-229 Series: Database Programming
Product Code: sql205 Time: 4.0 hour(s) CEUs: Available


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.


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


  • 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 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright © 2008 MindLeaders. All rights reserved.