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

Summary:
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:

After completing this course, students will be able to:
  • 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:
200MHz Pentium with 32MB Ram. 800 x 600 minimum screen resolution. Windows 98, NT, 2000, or XP. 56K minimum connection speed, broadband (256 kbps or greater) connection recommended. Internet Explorer 5.0 or higher required. Flash Player 7.0 or higher required. JavaScript must be enabled. Netscape, Firefox and AOL browsers not supported.

Copyright Information:
Product names mentioned in this catalog may be trademarks/servicemarks or registered trademarks/servicemarks of their respective companies and are hereby acknowledged. All product names that are known to be trademarks or service marks have been appropriately capitalized. Use of a name in this catalog is for identification purposes only, and should not be regarded as affecting the validity of any trademark or service mark, or as suggesting any affiliation between MindLeaders.com, Inc. and the trademark/servicemark proprietor.

Terms of Use:
Copyright © 2006 Learn It Online. All rights reserved.
Online Computer Courses | Privacy Policy | Terms Of Use | MCDST Training | MCSA Training | MCSE Training | MCDBA Training | MCAD Training | MCSD Training | CCNA Training | CCNP Training | CCDA Training | A+ Training | Network+ Training | Server+ Training | Security+ Training | MOS Training | ECDL Training | ICDL Training | Novell Training | Oracle Training|