MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition

Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

SQL Server 2000 Requirements

Database Design for SQL Server 2000

Physical Database Design and Implementation

Querying and Modifying Data

Advanced Data Retrieval and Modification

Programming SQL Server 2000

Working with Views

Use of Triggers

Stored Procedures and User-Defined Functions

Boosting Performance with Indexes

Implementing and Understanding Replication Methodologies

Monitoring and Tuning SQL Server Databases

Категории