MCITP Microsoft SQL Server 2005 Database Design Study Guide

Description

* This comprehensive book guides readers through Microsoft's brand- new SQL 2005 certification: Microsoft Certified IT Professional Developer for SQL Server 2005 (Exam 70441)

* Topics covered include writing SQL queries, designing and implementing programming objects, database optimization, designing databases at both the conceptual and logical levels, and implementing databases at the physical level

* Aimed at candidates for this exam, namely professional database developers who are responsible for designing and implementing database solutions using SQL Server 2005

* The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards

  For Instructors: Teaching supplements are available for this title.

CONTENTS:

Introduction.

  
Assessment Test.

  
Chapter 1. Designing a Database Solution.

  
Chapter 2. Designing Database Objects.

  
Chapter 3. Performance Tuning a Database Solution.

  
Chapter 4. Securing a Database Solution.

  
Chapter 5. Designing Database Testing and Code Management Procedures.

  
Chapter 6. Designing a Web Services Solution.

  
Chapter 7. Designing Messaging Services for Database Solution.

  
Chapter 8. Designing a Reporting Services Solution.

  
Chapter 9. Designing Data Integration Solutions.

  
Chapter 10. Case Studies.

  
Glossary.

  
Index.