The SQL Server 2000 Logical Data Model

This course is included in our On-demand training solution.

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?