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