Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

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 year?s experience administering SQL Server; at least one year?s 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

Course Aim

This learning path describes in detail the new features, tools, and best practices for designing and implementing databases using Microsoft SQL Server 2000.

Learning Objectives

To describe SQL Server data entities and their normalization

Topics Covered

SQL Server 2000 entities and normalization SQL Server 2000 data integrity Normalizing and denormalizing SQL Server 2000 databases SQL Server 2000 entity keys SQL Server 2000 primary key constraints SQL Server 2000 foreign key constraints SQL Server 200 unique key constraints Creating SQL Server 2000 key constraints SQL Server 2000 domain integrity SQL Server 2000 default constraints SQL Server 2000 check constraints and NULL SQL Server 2000 constraints, rules, and defaults Enforcing SQL Server 2000 data integrity

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.