Welcome to MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation. This training kit introduces you to SQL Server 2000 and provides detailed information 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 introduced 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.
Each chapter in this book is divided into lessons. Most lessons include hands-on procedures 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.
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.