EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

About the Exam and Content Areas

The exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition includes a variety of content. For specifics on the exam, check the exam guide on the Microsoft website at this URL:

http://www.microsoft.com/learning/exams/70-229.asp

The broad topic areas covered by the exam include the following:

Developing a Logical Data Model
Application of common database development theories to a database design project is initiated using common industry standards.

Implementing the Physical Database
Turning the design into a reality within the SQL Server framework is the start toward SQL Serverspecific implementation.

Retrieving and Modifying Data
Getting the data in and out and manipulating the data to produce the results will be expected within the business solution.

Programming Business Logic
Complex task will require procedure development and programming technique.

Tuning and Optimizing Data Access
An application, once in place, will need to be analyzed and tweaked.

Designing a Database Security Plan
Confidential data must be protected and access to areas of data controlled to prevent corruption.

Each of the task areas represents elements of a systems design from the outset of a project. The exam will be taking systems from a rough design through to the specifics of the implementation and then following up with fine-tuning of the application to improve performance and guarantee security.