IntroductionInformation GatheringQuery OptimizationExam Prep QuestionsChapter 8. Designing for Optimized Data AccessIntroductionOptimization Through DesignMaintaining the System to Get Back PerformanceExam Prep QuestionsChapter 9. Designing a Database Security PlanIntroductionTroubleshooting Security IssuesExam Prep QuestionsChapter 10. Completing a Business System DesignIntroductionSQL Server Supporting ApplicationsCoding for Distributed DataSQL Server Automation of ProcessesExam Prep QuestionsChapter 11. Practice Exam OneChapter 12. Answers to Practice Exam OneChapter 13. Practice Exam TwoChapter 14. Answers to Practice Exam TwoAppendix A. What's on the CD-ROM?Multiple Test ModesQuestion TypesRandom Questions and Order of AnswersDetailed Explanations of Correct and Incorrect AnswersAttention to Exam ObjectivesInstalling the CDTechnical SupportAppendix B. Need to Know More?Chapter 1Chapter 2Chapter 3Chapter 4Chapter 5Chapter 6Chapter 7Chapter 8Chapter 9Chapter 10GlossaryABCDEFGHIJK-LMNOPQRSTUVWX-Z