MCDBA - MCAD - MCSE - 70-229 - Microsoft SQL Server 2000 Database Design And Implementation.pdf - Certyfikaty MS - SacrA

PUBLISHED BY

Microsoft Press

A Division of Microsoft Corporation

One Microsoft Way

Redmond, Washington 98052-6399

by any means without the written permission of the publisher.

Library of Congress Cataloging-in-Publication Data pending.

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWT 8 7 6 5 4 3

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further informa-

tion about international editions, contact your local Microsoft Corporation office or contact Microsoft

Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send

comments to tkinput@microsoft.com .

Active Directory, Microsoft, Microsoft Press, Windows, and Windows NT are either registered trademarks

or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and

company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people,

places, and events depicted herein are fictitious. No association with any real company, organiza-

tion, product, domain name, e-mail address, logo, person, place, or event is intended or should be

inferred.

Acquisitions Editor: Kathy Harding

Project Editor: Valerie Woolley

Body Part No. X09-59427

xxv

About This Book

Welcome to MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL

Server 2000 Database Design and Implementation, Exam 70-229, Second Edition .

This training kit introduces you to SQL Server 2000 and provides detailed informa-

tion about how to design and implement a SQL Server database. The training kit

takes you through the steps of how to plan and implement a database, create and

maintain database objects, and implement data integrity. You will also be intro-

duced to Transact-SQL, and you will learn how to use Transact-SQL to query a

SQL Server database and manage and manipulate data stored in that database.

Finally, the training kit describes how to manage SQL Server security and how to

maintain and optimize a SQL Server database.

Note For more information on becoming a Microsoft Certified Systems Engineer,

see the section titled “The Microsoft Certified Professional Program” later in this

chapter.

Before You Begin Part 1

Each chapter in Part 1 is divided into lessons. Most lessons include hands-on pro-

cedures that allow you to practice or demonstrate a particular concept or skill. Each

lesson ends with a short summary of the information presented in that lesson, and

each chapter ends with a set of review questions to test your knowledge of the

chapter material.

The “Getting Started” section of this chapter provides important setup instructions

that describe the hardware and software requirements to complete the procedures

in this course. Read through this section thoroughly before you start the lessons.

Intended Audience

This book was developed for information technology (IT) professionals who need

to design, plan, implement, and support Microsoft SQL Server 2000 or who plan to

take the related Microsoft Certified Professional exam 70-229: Designing and

Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

xxvi

Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229

Prerequisites

This course requires that students meet the following prerequisites:

■

Working knowledge of the Windows interface is required.

■

Understanding of basic Microsoft network functions and terminology is

required.

■

One year of experience with relational databases is recommended. You should

have supported or designed a relational database and you should understand the

fundamental concepts of relational database design.

■

Three to six months of SQL Server experience is recommended. You should

have installed SQL Server and worked with SQL Server client tools.

Reference Materials

You might find the following reference materials useful:

■

Designing Relational Database Systems , Rebecca M. Riordan, Microsoft

Press, 1999

■

Inside SQL Server 2000 , Kalen Delaney (based on the first edition by Ron

Soukup), Microsoft Press, 2000

■

Microsoft TechNet, available online at http://www.microsoft.com/technet/

■

MSDN Online, available at http://msdn.microsoft.com/sqlserver/

■

SQL Server Books Online, available on the product CD-ROM

■

SQL Server Magazine (Information about the magazine is available at

http://www.sqlmag.com/ .)

■

Technical and product information available online at http://www.microsoft.com

/sql/

About the CD-ROM

This book contains both a Supplemental Course Materials CD-ROM and a 120-day

Evaluation Edition of Microsoft SQL Server 2000.

The Supplemental Course Materials CD-ROM contains files required to perform the

hands-on procedures, as well as information designed to supplement the lesson

material. These files can be used directly from the CD-ROM or copied onto your

hard disk by using the setup program. For more information regarding the contents

of this CD-ROM, see the section titled “Getting Started” later in this introduction.

A complete version of this book is also available online with a variety of viewing

options available. For information about using the online book, see the section,

“About the eBook,” later in this introduction.

About This Book

xxvii

Features of This Book

Each chapter opens with a “Before You Begin” section, which prepares you for

completing the chapter.

The chapters are then broken into lessons. Whenever possible, lessons contain

practices that give you an opportunity to use the skills being presented or to

explore the part of the application being described. All practices offer step-by-step

procedures that are identified with a bullet symbol like the one to the left of this

paragraph.

The “Review” section at the end of the chapter allows you to test what you have

learned in the chapter’s lessons.

The Appendix, “Questions and Answers,” contains all of the book’s questions and

corresponding answers.

Notes

Several types of Notes appear throughout the lessons.

■

Notes marked Tip contain explanations of possible results or alternative

methods.

■

Notes marked Important contain information that is essential to completing a

task.

■

Notes marked Note contain supplemental information.

■

Notes marked Caution contain warnings about possible loss of data.

Conventions

The following conventions are used throughout this book.

Notational Conventions

■

Characters or commands that you type appear in bold lowercase type.

■

Italic in syntax statements indicates placeholders for variable information.

Italic is also used for book titles.

■

Names of files and folders appear in Title Caps, except when you are to type

them directly. Unless otherwise indicated, you can use all lowercase letters

when you type a filename in a dialog box or at a command prompt.

■

Filename extensions appear in all lowercase.

■

Acronyms appear in all uppercase.

■

Monospace type represents code samples, examples of screen text, or entries

that you might type at a command prompt or in initialization files.

MCDBA - MCAD - MCSE - 70-229 - Microsoft SQL Server 2000 Database Design And Implementation.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: