لطفا منتظر باشید ...
EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise EditionBy Table of Contents
| Copyright
A Note from Series Editor Ed TittelAbout the AuthorAcknowledgmentsWe Want to Hear from You!IntroductionAbout the Exam and Content AreasHow to Prepare for the ExamWhat This Book Will DoWhat This Book Will Not DoAbout the BookSelf-AssessmentDatabase Implementation and Administration as an MCDBATesting Your Exam ReadinessWell, Let''''s Get to ItChapter 1.
Database Development on SQL Server 2000
IntroductionThe Server and Its ComponentsThe ExamSQL Server ObjectsTypes of DataExam Prep QuestionsChapter 2.
Creating a Logical Data Model
IntroductionData Modeling and Logical Data DesignData NormalizationDenormalizationRelationships Between EntitiesExam Prep QuestionsChapter 3.
Implementing the Physical Database
IntroductionA Hardware DialogueThe File SystemDatabase CreationInside the DatabaseTrigger UtilizationTroubleshooting Failed Object CreationExam Prep QuestionsChapter 4.
Advanced Physical Database Implementation
IntroductionThe Need for a More Complex DesignDatabase Configuration OptionsOther Multiple Machine Database ImplementationsExam Prep QuestionsChapter 5.
Retrieving and Modifying Data
IntroductionMoving a Mountain of DataSelecting Information from the DataJoining Multiple Sets of DataExtensible Markup Language (XML)Exam Prep QuestionsChapter 6.
Programming Business Logic
IntroductionStart with Data Analysis Prior to CodingProviding the Orders to Be FollowedConverting Constructs to CodeAlternative Coding MechanismsExam Prep QuestionsChapter 7.
Tuning and Optimizing Analysis
IntroductionInformation GatheringQuery OptimizationExam Prep QuestionsChapter 8.
Designing for Optimized Data Access
IntroductionOptimization Through DesignMaintaining the System to Get Back PerformanceExam Prep QuestionsChapter 9.
Designing a Database Security Plan
IntroductionTroubleshooting Security IssuesExam Prep QuestionsChapter 10.
Completing a Business System Design
IntroductionSQL Server Supporting ApplicationsCoding for Distributed DataSQL Server Automation of ProcessesExam Prep QuestionsChapter 11.
Practice Exam One
Chapter 12.
Answers to Practice Exam One
Chapter 13.
Practice Exam Two
Chapter 14.
Answers to Practice Exam Two
Appendix 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
