CAD/MCSE/MCDBA Self-Paced Training Kit [Electronic resources]: Microsoft SQL Server 2000 Database Design and Implementation, Second Edition (Exam 70-229) نسخه متنی

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Second Edition (Exam 70-229)

byMicrosoft Corporation

ISBN:0735619603

Microsoft Press

2003

(815 pages)

Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition--as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.

CD Content

Table of Contents

MCAD/MCSE/MCDBA Self-Paced Training Kit—Microsoft SQL Server 2000 Database Design and Implementation, Second Edition, Exam 70-229

About This Book

Part 1 -
Self-Paced Training for Microsoft SQL Server 2000 Database Design and Implementation

Chapter 1
-

Introduction to Microsoft SQL Server 2000

Chapter 2
-

Using Transact-SQL on a SQL Server Database

Chapter 3
-

Designing a SQL Server Database

Chapter 4
-

Implementing SQL Server Databases and Tables

Chapter 5
-

Implementing Data Integrity

Chapter 6
-

Accessing and Modifying Data

Chapter 7
-

Managing and Manipulating Data

Chapter 8
-

Implementing Stored Procedures

Chapter 9
-

Implementing Triggers

Chapter 10
-

Implementing Views

Chapter 11
-

Implementing Indexes

Chapter 12
-

Managing SQL Server Transactions and Locks

Chapter 13
-

Designing and Administering SQL Server 2000 Security

Chapter 14
-

SQL Server Monitoring and Tuning

Part 2 -
Preparation for MCP Exam 70-229

Objective Domain 1
-
Developing a Logical Data Model

Objective Domain 2
-
Implementing the Physical Database

Objective Domain 3
-
Retrieving and Modifying Data

Objective Domain 4
-
Programming Business Logic

Objective Domain 5
-
Tuning and Optimizing Data Access

Objective Domain 6
-
Designing a Database Security Plan

Appendix A
-

Questions and Answers

Glossary

Index

List of Figures

CD Content