APPENDIX DExam 70-441: What You Need to Know to Pass

There are three ingredients in the good life: learning, earning, and yearning.

—Christopher Morley

70-441: Designing Database Solutions by Using Microsoft SQL Server 2005

Introduction

The 70-441 exam focuses heavily on designing databases from the ground up. This includes data types, constraints, tables and relationships between tables, VIEWs, stored procedures, triggers, database security, and more. While the preparation guide indicates that you need to be an expert in T-SQL, the exam doesn't directly test this knowledge. Instead of coding, you need to have a solid knowledge of the underlying concepts.

What You Can Expect

This is a design exam. Unless you've taken a design exam before, ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.