SQL Server 2000 Database Design MCSE 70-229

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Optimization and Security shows users the tools and techniques that can be used to monitor and optimize the performance of a SQL Server 2000 database, and how to design and implement a database security plan.

Audience
This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Time
2 hours

Product Code: SQL207

SQL Server 2000 Database Design MCSE 70-229: Optimization and Security covers the following topics:

Monitoring performance

Configuring Windows 2000 Server

Configuring SQL Server 2000

Using SQL Profiler

Analyzing performance

Login authentication

Permissions

Database user accounts

Roles

Authentication modes

The database security plan

This course has the following features:

Activities that allow users to apply course concepts in an interactive questioning environment

Simulations that allow users to practice course skills, even if they don't have access to SQL Server 2000

A glossary

A Skill Assessment

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation (SQL201)

SQL Server 2000 Database Design MCSE 70-229: Database Objects (SQL202)

SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data (SQL203)

SQL Server 2000 Database Design MCSE 70-229: Indexes and Views (SQL204)

SQL Server 2000 Database Design MCSE 70-229: Database Programming (SQL205)

SQL Server 2000 Database Design MCSE 70-229: Remote Data Access and XML (SQL206)

SQL Server 2000 Database Design MCSE 70-229: Exam Preparation 1 (SQL208)

SQL Server 2000 Database Design MCSE 70-229: Exam Preparation 2 (SQL209)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.