Table of Contents

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