MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition

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.