MP9004: Microsoft - Database Objects > SQL Server 2000 Database Design MCSE 70-229

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

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

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

Duration:
2 Hours