SQL Server 2000 Database Design MCSE 70-229

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.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.