Microsoft SQL Server 2005 Solutions MCITP 70-441 - Online Course

This series 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.

This series is for anyone who wants to achieve MCITP 70-441 certification. This online course contains 9 lessons and 2 practice exams and should take approximately 12 hours to complete.

Lesson 1: Designing a Database Solution (1.0) hour

Designing a Database Solution teaches you how to design a logical database, application solutions, objects, attributes, entities, and entity relationships. This course covers creating a logical database design. It discusses (de)normalization, data types, domain integrity, physical entity implementation, entity integrity, and referential integrity.

Lesson 2: Designing Database Objects (2.0) hours

Designing Database Objects teaches you how to use indexes and partitioning, discuss the various objects supported by SQL Server 2005, examine the different types of triggers, and explain the scheduled job execution and alerts produced by the SQL Server Agent. This course covers designing database objects that define and retrieve data, extend the functionality of the server, and perform actions.

Lesson 3: Performance Tuning a Database Solution (1.0) hour

Performance Tuning a Database Solution teaches you how to create a performance baseline and benchmarking strategy for a database, and design data distribution. This course covers establishing performance objectives, evaluating performance monitoring tools, and detecting and responding to performance problems.

Lesson 4: Securing a Database Solution (1.0) hour

Securing a Database Solution teaches you how to design an application solution to support security. This course addresses setting up database security for particular database solutions and business needs. Topics include Design database security.

Lesson 5: Designing Database Testing and Code Management Procedures (1.0) hour

Designing Database Testing and Code Management Procedures teaches you how to design a unit test plan for a database, create a plan for deploying a database, and control changes to source code. This course addresses database testing, deployment, and source code control.

Lesson 6: Designing a Web Service Solution (1.0) hour

Designing a Web Service Solution teaches you how to select and design SQL Server services to support business needs, and design data distribution. This course addresses distributed application development and SQL Server 2005 support for XML Web services.

Lesson 7: Designing Messaging Services for a Database Solution (1.0) hour

Designing Messaging Services for a Database Solution teaches you how to select and design SQL Server services to support business needs, design data distribution, develop applications for Notification Services, and design objects that perform actions. This course addresses the use of SQL Server Service Broker, SQL Server Notification Services, and SQL Server Database Mail.

Lesson 8: Designing a Reporting Services Solutions (1.0) hour

Designing a Reporting Services Solutions teaches you how to design an application solution that supports reporting, design data distribution, develop applications that use Reporting Services, and select and design SQL Server services to support business needs. This course addresses the use of SQL Server Reporting Services as a compelling reporting solution for database applications.

Lesson 9: Designing Data Integration Solutions (1.0) hour

Designing Data Integration Solutions teaches you how to select and design SQL Server services to support business needs, develop packages for Integration Services, design data distribution, design interoperability with external systems, and design the data transformation. This course addresses extracting, transforming, and loading data with SQL Server 2005.

2 Practice Exams

This course 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.