SQL Server 2000 Database Design MCSE 70-229

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Database Objects shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

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

Time
3 hours

Product Code: SQL202

SQL Server 2000 Database Design MCSE 70-229: Database Objects covers the following topics:

Creating and altering database objects

Tables and data types

Creating tables

Modifying and deleting tables

System-supplied data types

User-defined data types

Designing attribute integrity

Cascading referential integrity/disabling constraints

Replication and data types

Generating column values

Creating DEFAULT and RULE objects

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)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.