SQL Server 2000 Database Design MCSE 70-229: Database Objects

Products

Resources

Specials

Summary:

This training course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

Objectives:

After completing this training course , students will be able to:

Create and alter database objects
Create and alter tables
Design and create constraints
Alter database objects to support replication

Outline:

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

Features:

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

Applicability:

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

Prerequisites:

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

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

Terms of Use:

None