[videohttp://dxr1evk25kz7c.cloudfront.net/microsoft-sql-server-2005-solutions-mcitp-70-441.flv
http://videocourses.nhanced.co.uk/microsoft-sql-server-2005-solutions-mcitp-70-441.jpg.300:300]

Microsoft SQL Server 2005 Solutions MCITP 70-441

Total Items: 11 Total Time: 12 hour(s)

Summary:

This course provides you with a study guide to prepare to become certified as a Microsoft Certified IT Professional: Database Developer. PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 (70-441), will cover your ability to build efficient, effective enterprise Microsoft SQL Server 2005 database solutions.

Practice exams are also included, which will allow you to answer questions in the same format that the test will use on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you'll need to master.

Learning Segment 1: Designing a Database Solution

Summary:

This learning segment covers creating a logical database design. It discusses (de)normalization, data types, domain integrity, physical entity implementation, entity integrity, and referential integrity.

Learning Segment 2: Designing Database Objects

Summary:

This learning segment covers designing database objects that define and retrieve data, extend the functionality of the server, and perform actions.

Objectives:

• Use indexes and partitioning
• Discuss the various objects supported by SQL Server 2005
• Examine the different types of triggers
• Explain the scheduled job execution and alerts produced by the SQL Server Agent

Learning Segment 3: Performance Tuning a Database Solution

Summary:

This learning segment covers establishing performance objectives, evaluating performance monitoring tools, and detecting and responding to performance problems.

Objectives:

• Create a performance baseline and benchmarking strategy for a database
• Design data distribution

Learning Segment 4: Securing a Database Solution

Summary:

This learning segment addresses setting up database security for particular database solutions and business needs.

Learning Segment 5: Designing Database Testing and Code Management Procedures

Summary:

This learning segment addresses database testing, deployment, and source code control.

Objectives:

• Design a unit test plan for a database
• Create a plan for deploying a database
• Control changes to source code

Learning Segment 6: Designing a Web Service Solution

Summary:

This learning segment addresses distributed application development and SQL Server 2005 support for XML Web services.

Objectives:

• Select and design SQL Server services to support business needs
• Design data distribution

Learning Segment 7: Designing Messaging Services for a Database Solution

Summary:

This learning segment addresses the use of SQL Server Service Broker, SQL Server Notification Services, and SQL Server Database Mail.

Objectives:

• Select and design SQL Server services to support business needs
• Design data distribution
• Develop applications for Notification Services
• Design objects that perform actions

Learning Segment 8: Designing a Reporting Services Solutions

Summary:

This learning segment addresses the use of SQL Server Reporting Services as a compelling reporting solution for database applications.

Objectives:

• Design an application solution that supports reporting
• Design data distribution
• Develop applications that use Reporting Services
• Select and design SQL Server services to support business needs

Learning Segment 9: Designing Data Integration Solutions

Summary:

This learning segment addresses extracting, transforming, and loading data with SQL Server 2005.

Objectives:

• Select and design SQL Server services to support business needs
• Develop packages for Integration Services
• Design data distribution
• Design interoperability with external systems
• Design the data transformation

Learning Segment 10: Practice Exam 1

Summary:

This learning segment presents questions that will help you prepare for the MCITP 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.

Learning Segment 11: Practice Exam 2

Summary:

This learning segment presents questions that will help you prepare for the MCITP 70-441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 exam. The feedback for each question provides in-depth background on the topic, including why each incorrect option was wrong and what to look for in correct answers.

Technical Requirements: