The SQL Server 2000 Logical Data Model

Overview/Description
To describe SQL Server data entities and their normalization

Target Audience
Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one years experience administering SQL Server; at least one years experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
145 Minutes

Objectives:

The SQL Server 2000 Logical Data Model

  • describe the four types of data integrity.
  • normalize and denormalize a database.
  • define and use primary key constraints to ensure data integrity.
  • create, define, and use foreign key constraints to ensure data integrity.
  • define and use unique key constraints to ensure data integrity.
  • create primary, foreign, and unique key constraints.
  • create default constraints for data integrity.
  • describe and create check constraints and NULL values.
  • disable constraints, and use rules and defaults.
  • use defaults, check constraints, and NULL values in Query Analyzer.


    • Course Number: 31901_eng