EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition
By Table of Contents | 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
The Server and Its Components
The Exam
SQL Server Objects
Types of Data
Exam Prep Questions
Chapter 2. Creating a Logical Data Model
Data Modeling and Logical Data Design
Data Normalization
Denormalization
Relationships Between Entities
Chapter 3. Implementing the Physical Database
A Hardware Dialogue
The File System
Database Creation
Inside the Database
Trigger Utilization
Troubleshooting Failed Object Creation
Chapter 4. Advanced Physical Database Implementation
The Need for a More Complex Design
Database Configuration Options
Other Multiple Machine Database Implementations
Chapter 5. Retrieving and Modifying Data
Moving a Mountain of Data
Selecting Information from the Data
Joining Multiple Sets of Data
Extensible Markup Language (XML)
Chapter 6. Programming Business Logic
Start with Data Analysis Prior to Coding
Providing the Orders to Be Followed
Converting Constructs to Code
Alternative Coding Mechanisms
Chapter 7. Tuning and Optimizing Analysis
Information Gathering
Query Optimization
Chapter 8. Designing for Optimized Data Access
Optimization Through Design
Maintaining the System to Get Back Performance
Chapter 9. Designing a Database Security Plan
Troubleshooting Security Issues
Chapter 10. Completing a Business System Design
SQL Server Supporting Applications
Coding for Distributed Data
SQL Server Automation of Processes
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