Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Database Programming shows users how to create and use stored procedures, triggers, functions, user-defined functions (UDFs), transactions, cursors, and locks in database application programming.

Audience
This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Time
4 hours

Product Code: SQL205
SQL Server 2000 Database Design MCSE 70-229: Database Programming covers the following 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

This course has the following features:

Exercises that allow users to practice course techniques
A file containing the text of the exercises
Activities that allow users to apply course concepts in an interactive questioning environment
A glossary
A Skill Assessment

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation (SQL201)
SQL Server 2000 Database Design MCSE 70-229: Database Objects (SQL202)
SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data (SQL203)
SQL Server 2000 Database Design MCSE 70-229: Indexes and Views (SQL204)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.