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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.