EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

Sitemap

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

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