文档介绍:This document is created with the unregistered version of CHM2PDF Pilot
< Day Day Up >
MCAD/MCSE/MCDBA Self-Paced Training Kit:
Microsoft SQL Server 2000 Database Design and
Implementation, Second Edition (Exam 70-229)
by Microsoft 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
Ch
apt
- Introduction to Microsoft SQL Server 2000
er
1
Ch
apt
- Using Transact-SQL on a SQL Server Database
er
2
Ch
apt
- Designing a SQL Server Database
er
3
Ch
apt
- Implementing SQL Server Databases and Tables
er
4
Ch
apt
- Implementing Data Integrity
er
5
Ch
apt
- Accessing and Modifying Data
er
6
Ch
apt
- Managing and Manipulating Data
er
7
This document is created with the unregistered version of CHM2PDF Pilot
Ch
apt
- Implementing Stored Procedures
er
8
Ch
apt
- Implementing Triggers
er
9
Ch
apt
- Implementing Views
er
10
Ch
apt
- Implementing Indexes
er
11
Ch
apt
- Managing SQL Server Transactions and Locks
er
12
Ch
apt
- Designing and Administering SQL Server 2000 Security
er
13
Ch
apt
- SQL Server Monitoring and Tuning
er
14
Part 2 - Preparation for MCP Exam 70-229
Ob
jec
tiv
e
- Developing a Logical Data Model
Do
ma
in
1
Ob
jec
tiv
e
- Implementing the Physical Database
Do
ma
in
2
This document is created with the unregistered version of CHM2PDF Pilot
Ob