EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition


book cover
EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition
By Thomas Moore
...............................................
Publisher: Que
Pub Date: June 01, 2005
ISBN: 0-7897-3106-1
Pages: 504
 

Table of Contents  | Index  | Examples
overview
The MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases with SQL Server 2000 Enterprise Edition covers exactly what you need to know to pass the 70-229 exam. It is the ideal refresher that ensures readers cover the essentials and the ultimate complement guide for larger training guides, instructor-led classes or CBT training. This comprehensive reference guide also comes with the popular "Cram Sheet" tear card for your last minute cram sessions, and the accompanying CD includes a practice test engine powered by MeasureUp. You will also benefit from the community support at www.examcram2.com, which features industry news, study tips, practice exams, and discussion boards.


book cover
EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition
By Thomas Moore
...............................................
Publisher: Que
Pub Date: June 01, 2005
ISBN: 0-7897-3106-1
Pages: 504
 

Table of Contents  | Index  | Examples

   Copyright
   A Note from Series Editor Ed Tittel
   About the Author
   Acknowledgments
   We Want to Hear from You!
   Introduction
      About the Exam and Content Areas
      How to Prepare for the Exam
      What This Book Will Do
      What This Book Will Not Do
      About the Book
   Self-Assessment
      Database Implementation and Administration as an MCDBA
      Testing Your Exam Readiness
      Well, Let's Get to It
        Chapter 1.  Database Development on SQL Server 2000
      Introduction
      The Server and Its Components
      The Exam
      SQL Server Objects
      Types of Data
      Exam Prep Questions
        Chapter 2.  Creating a Logical Data Model
      Introduction
      Data Modeling and Logical Data Design
      Data Normalization
      Denormalization
      Relationships Between Entities
      Exam Prep Questions
        Chapter 3.  Implementing the Physical Database
      Introduction
      A Hardware Dialogue
      The File System
      Database Creation
      Inside the Database
      Trigger Utilization
      Troubleshooting Failed Object Creation
      Exam Prep Questions
        Chapter 4.  Advanced Physical Database Implementation
      Introduction
      The Need for a More Complex Design
      Database Configuration Options
      Other Multiple Machine Database Implementations
      Exam Prep Questions
        Chapter 5.  Retrieving and Modifying Data
      Introduction
      Moving a Mountain of Data
      Selecting Information from the Data
      Joining Multiple Sets of Data
      Extensible Markup Language (XML)
      Exam Prep Questions
        Chapter 6.  Programming Business Logic
      Introduction
      Start with Data Analysis Prior to Coding
      Providing the Orders to Be Followed
      Converting Constructs to Code
      Alternative Coding Mechanisms
      Exam Prep Questions
        Chapter 7.  Tuning and Optimizing Analysis
      Introduction
      Information Gathering
      Query Optimization
      Exam Prep Questions
        Chapter 8.  Designing for Optimized Data Access
      Introduction
      Optimization Through Design
      Maintaining the System to Get Back Performance
      Exam Prep Questions
        Chapter 9.  Designing a Database Security Plan
      Introduction
      Troubleshooting Security Issues
      Exam Prep Questions
        Chapter 10.  Completing a Business System Design
      Introduction
      SQL Server Supporting Applications
      Coding for Distributed Data
      SQL Server Automation of Processes
      Exam Prep Questions
        Chapter 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 Modes
      Question Types
      Random Questions and Order of Answers
      Detailed Explanations of Correct and Incorrect Answers
      Attention to Exam Objectives
      Installing the CD
      Technical Support
        Appendix B.  Need to Know More?
      Chapter 1
      Chapter 2
      Chapter 3
      Chapter 4
      Chapter 5
      Chapter 6
      Chapter 7
      Chapter 8
      Chapter 9
      Chapter 10
   Glossary
      A
      B
      C
      D
      E
      F
      G
      H
      I
      J
      K-L
      M
      N
      O
      P
      Q
      R
      S
      T
      U
      V
      W
      X-Z
   Index