MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005

Be the first to write a review

Overview

EXAM PREP GUIDE

Ace your preparation for the skills measured by MCITP Exam 70-441—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make...

See more details below
Paperback (REV)
$41.65
BN.com price
(Save 30%)$59.99 List Price
Other sellers (Paperback)
  • All (25) from $1.99   
  • New (6) from $4.93   
  • Used (19) from $1.99   
Sending request ...

More About This Book

Overview

EXAM PREP GUIDE

Ace your preparation for the skills measured by MCITP Exam 70-441—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

  • Develop solutions that support business strategy
  • Design attributes and define entities and entity relationships
  • Create programmatic database objects using T-SQL and CLR
  • Define data access requirements and work with schemas to manage objects
  • Design reporting solutions with SQL Server Reporting Services
  • Plan for unit testing, benchmarking, and deployment

PRACTICE TESTS

Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers-including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

  • 15% exam discount from Microsoft. (Limited time offer). Details inside.
  • Official self-paced study guide.
  • Practice tests with multiple, customizable testing options and a learning plan based on your results.
  • 200+ practice and review questions.
  • Case scenarios, practice exercises, and best practices.
  • 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
  • Fully searchable eBook of this guide.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Read More Show Less

Editorial Reviews

From Barnes & Noble
As SQL Server becomes increasingly popular, and moves even more deeply into the enterprise, demand for expert SQL Server developers keeps growing. While certification isn't the whole story, it sure can get you in the door. MCITP: Database Developer certification encompasses two exams, and Microsoft's just released a superb study package for the first of them: Exam 70-441, Designing Database Solutions by Using Microsoft SQL Server 2005.

Like all of Microsoft's Self-Paced Training Kits, this one begins with a well-written, real-world study guide based on final, official exam content -- with plenty of realistic scenarios, case studies, and troubleshooting labs. It then adds more than 200 questions on CD-ROM: questions carefully crafted to reflect the actual exam.

Microsoft has even thrown in a 180-day DVD evaluation version of SQL Server 2005 Enterprise Edition -- plus a 15%-off coupon on the exam to help pay for all these goodies. Bill Camarda, from the October 2007 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780735623422
  • Publisher: Microsoft Press
  • Publication date: 9/22/2007
  • Edition description: REV
  • Pages: 656
  • Product dimensions: 7.44 (w) x 8.98 (h) x 1.72 (d)

Meet the Author

Dejan Sarka is a mentor with SolidQ and focuses on development of database and business intelligence applications. He is a frequent speaker at international conferences such as TechEd, SqlDevCon, and PASS. He is the founder of the Slovenian SQL Server and .NET Users Group. As main author or coauthor, Dejan has written nine books about SQL Server. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.

The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.

Javier Loria is a SQL Server expert who works at Solid Quality Mentors where he combines deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.

Read More Show Less

Table of Contents

Exam 70-441: Pro: Designing Database Solutions by Using Microsoft® SQL Server™ 2005;
About the Authors;
Dejan Sarka;
Adolfo Wiernik;
Javier Loria;
Andy Leonard;
Francisco A. González;
Jesús López;
Introduction;
Hardware Requirements;
Software Requirements;
Case Scenarios and the 70-441 Exam;
Using the CD and DVD;
Microsoft Certified Professional Program;
Technical Support;
Evaluation Edition Software Support;
Chapter 1: Selecting and Designing SQL Server Services to Support Business Needs;
1.1 Before You Begin;
1.2 Lesson 1: Selecting the Appropriate Services;
1.3 Lesson 2: Evaluating Core, SQL Server Agent, and Database Mail Solutions;
1.4 Lesson 3: Using Advanced Services;
1.5 Lesson 4: Evaluating Other Services;
1.6 Case Scenario: Select SQL Server Services to Support Business Needs;
1.7 Chapter Summary;
Chapter 2: Designing a Logical Database;
2.1 Before You Begin;
2.2 Lesson 1: Systematically Approaching Design Stages;
2.3 Lesson 2: Designing a Normalized Database;
2.4 Lesson 3: Optimizing the Database Design by Denormalizing;
2.5 Lesson 4: Designing the Data Flow Architecture;
2.6 Lesson 5: Supertypes and Subtypes;
2.7 Case Scenario: Design a Logical Database;
2.8 Chapter Summary;
Chapter 3: Designing a Physical Database;
3.1 Before You Begin;
3.2 Lesson 1: Choosing Column Data Types and Sizes;
3.3 Lesson 2: Designing User-Defined Data Types;
3.4 Lesson 3: Defining Entities and Entity and Referential Integrity;
3.5 Lesson 4: Defining Domain Integrity and Business Rules;
3.6 Lesson 5: Creating Programmable Objects to Maintain Integrity;
3.7 Case Scenario: Design a Physical Database;
3.8 Chapter Summary;
Chapter 4: Designing a Database for Performance;
4.1 Before You Begin;
4.2 Lesson 1: Optimizing Queries by Creating Indexes;
4.3 Lesson 2: Designing Indexes;
4.4 Lesson 3: Specifying Indexed Views;
4.5 Lesson 4: Partitioning a Table;
4.6 Case Scenario: Design a Database for Performance;
4.7 Chapter Summary;
Chapter 5: Using Appropriate Database Technologies and Techniques for Your Application;
5.1 Before You Begin;
5.2 Lesson 1: Using XML Data in Databases;
5.3 Lesson 2: Choosing Languages;
5.4 Lesson 3: Designing for Scalability;
5.5 Lesson 4: Designing Interoperability with External Systems;
5.6 Case Scenario: Implement Database Technologies and Techniques for Your Application;
5.7 Chapter Summary;
Chapter 6: Designing Objects That Retrieve Data;
6.1 Before You Begin;
6.2 Lesson 1: Designing Views;
6.3 Lesson 2: Designing Stored Procedures;
6.4 Lesson 3: Designing User-Defined Functions;
6.5 Case Scenario: Designing Objects That Retrieve Data;
6.6 Chapter Summary;
Chapter 7: Designing Objects That Extend Server Functionality;
7.1 Before You Begin;
7.2 Lesson 1: Creating and Designing Stored Procedures;
7.3 Lesson 2: Designing Scalar User-Defined Functions;
7.4 Lesson 3: Designing DML and DDL Triggers;
7.5 Lesson 4: Designing CLR User-Defined Aggregates;
7.6 Case Scenario: Adding an Audit Trail;
7.7 Chapter Summary;
Chapter 8: Designing a Secure Application Solution;
8.1 Before You Begin;
8.2 Lesson 1: Securing Components of a SQL Server Solution;
8.3 Lesson 2: Designing the Database to Enable Auditing and Encryption;
8.4 Case Scenario: Design a Secure Application Solution;
8.5 Chapter Summary;
Chapter 9: Designing a Secure Database;
9.1 Before You Begin;
9.2 Lesson 1: Designing a Database-Access Strategy;
9.3 Lesson 2: Managing Schemas;
9.4 Lesson 3: Specifying Database Object Security Permissions;
9.5 Lesson 4: Managing Objects That Access Data;
9.6 Lesson 5: Designing an Execution-Context Strategy;
9.7 Case Scenario: Design a Secure Database;
9.8 Chapter Summary;
Chapter 10: Designing a Unit Test Plan for a Database;
10.1 Before You Begin;
10.2 Lesson 1: Assessing Which Components to Unit Test;
10.3 Lesson 2: Designing Tests for Query Performance;
10.4 Lesson 3: Designing Tests for Data Consistency;
10.5 Lesson 4: Designing Tests for Application Security;
10.6 Lesson 5: Designing Tests for System Resources Use;
10.7 Lesson 6: Designing Tests to Ensure Code Coverage;
10.8 Case Scenario: Design a Unit Test Plan for a Database;
10.9 Chapter Summary;
Chapter 11: Creating a Database Benchmarking Strategy;
11.1 Before You Begin;
11.2 Lesson 1: Establishing Performance Objectives and Capacity Planning;
11.3 Lesson 2: Creating a Strategy for Measuring Performance Changes;
11.4 Lesson 3: Creating a Plan for Responding to Performance Changes;
11.5 Lesson 4: Creating a Plan for Tracking Benchmark Statistics Over Time;
11.6 Case Scenario: Create a Performance Baseline and Benchmarking Strategy;
11.7 Chapter Summary;
Chapter 12: Creating a Plan for Deploying a Database;
12.1 Before You Begin;
12.2 Lesson 1: Selecting a Deployment Technique;
12.3 Lesson 2: Practical Deployment Considerations;
12.4 Case Scenario: Deploying a Database;
12.5 Chapter Summary;
Chapter 13: Controlling Changes to Source Code;
13.1 Before You Begin;
13.2 Lesson 1: Managing Source Code Changes;
13.3 Lesson 2: Setting File Permissions;
13.4 Lesson 3: Setting and Retrieving Version Information;
13.5 Lesson 4: Detecting Differences Between Versions;
13.6 Lesson 5: Encrypting Source Code;
13.7 Lesson 6: Tracking Changes to Groups of Objects;
13.8 Case Scenario: Controlling Changes to Source Code;
13.9 Chapter Summary;
Chapter 14: Designing for Data Distribution;
14.1 Before You Begin;
14.2 Lesson 1: Designing a DatabaseMail Solution for Distributing Data;
14.3 Lesson 2: Designing SQL Server Agent Alerts;
14.4 Lesson 3: Specifying a Web Services Solution for Distributing Data;
14.5 Lesson 4: Specifying a Reporting Services Solution for Distributing Data;
14.6 Lesson 5: Specifying a Notification Services Solution for Distibuting Data;
14.7 Case Scenario: Design a Distributed Data Solution;
14.8 Chapter Summary;
Chapter 15: Designing Applications That Support Reporting and Use Reporting Services;
15.1 Before You Begin;
15.2 Lesson 1: Evaluating the Use of Reporting Services and Designing Reports;
15.3 Lesson 2: Designing a Snapshot Strategy, Schema, Indexes, and Data Transformations;
15.4 Lesson 3: Designing Programmatic Interfaces and the Data Access Method for Reporting;
15.5 Lesson 4: Optimizing Reports;
15.6 Case Scenario: Building a Reporting Services Infrastructure for a SharePoint Portal;
15.7 Chapter Summary;
Chapter 16: Developing Applications for Notification Services;
16.1 Before You Begin;
16.2 Lesson 1: Configuring Notification Services Instances and Applications;
16.3 Lesson 2: Defining Notification Services Events and Event Providers;
16.4 Lesson 3: Configuring the Notification Services Generator and Distributor;
16.5 Lesson 4: Testing the Notification Services Application;
16.6 Lesson 5: Creating Subscriptions;
16.7 Lesson 6: Optimizing Notification Services;
16.8 Case Scenario: Design a Notification Services Application;
16.9 Chapter Summary;
Chapter 17: Developing Packages for Integration Services;
17.1 Before You Begin;
17.2 Lesson 1: Creating Integration Services Packages;
17.3 Lesson 2: Debugging and Testing SSIS Packages;
17.4 Lesson 3: Selecting an Appropriate SSIS Technology or Strategy;
17.5 Case Scenario: Building an SSIS ETL Infrastructure;
17.6 Chapter Summary;
Case Scenario Answers;
Chapter 1: Select SQL Server Services to Support Business Needs;
Chapter 2: Design a Logical Database;
Chapter 3: Design a Physical Database;
Chapter 4: Design a Database for Performance;
Chapter 5: Implement Database Technologies and Techniques for Your Application;
Chapter 6: Designing Objects That Retrieve Data;
Chapter 7: Adding an Audit Trail;
Chapter 8: Design a Secure Application Solution;
Chapter 9: Design a Secure Database;
Chapter 10: Design a Unit Test Plan for a Database;
Chapter 11: Create a Performance Baseline and Benchmarking Strategy;
Chapter 12: Deploying a Database;
Chapter 13: Controlling Changes to Source Code;
Chapter 14: Design a Distributed Data Solution;
Chapter 15: Building a Reporting Services Infrastructure for a SharePoint Portal;
Chapter 16: Design a Notification Services Application;
Chapter 17: Building an SSIS ETL Infrastructure;
System Requirements;
Hardware Requirements;
Software Requirements;
Additional Resources for Developers: Advanced Topics and Best Practices;
Additional SQL Server Resources for Developers;
Additional Windows (R2) Resources for Administrators;
Additional SQL Server Resources for Administrators;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)