About the Exam and Content AreasThe 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. |