Forgot My Password Support
◊ MICROSOFT SQL SERVER 2005 SOLUTIONS MCITP 70-441 ONLINE TRAINING SERIES

Online Microsoft SQL Server 2005 Solutions MCITP 70-441 Training


Only $99.95

Microsoft SQL Server 2005 Solutions MCITP 70-441 Series (12 hours)

ONLINE TRAINING FEATURES

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Microsoft SQL Server 2005 Solutions MCITP 70-441:1 Designing a Database Solution

Time: 1 hours
This course covers creating a logical database design. It discusses (de)normalization, data types, domain integrity, physical entity implementation, entity integrity, and referential integrity.

Objectives

  • Design a logical database, application solutions, objects, attributes, entities, and entity relationships



2. Microsoft SQL Server 2005 Solutions MCITP 70-441:2 Designing Database Objects

Time: 2 hours
This course 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



3. Microsoft SQL Server 2005 Solutions MCITP 70-441:3 Performance Tuning a Database Solution

Time: 1 hours
This course 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



4. Microsoft SQL Server 2005 Solutions MCITP 70-441:4 Securing a Database Solution

Time: 1 hours
This course addresses setting up database security for particular database solutions and business needs.

Objectives

  • Design an application solution to support security

Topics

  • Design database security



5. Microsoft SQL Server 2005 Solutions MCITP 70-441:5 Designing Database Testing and Code Management Procedures

Time: 1 hours
This course 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



6. Microsoft SQL Server 2005 Solutions MCITP 70-441:6 Designing a Web Service Solution

Time: 1 hours
This course 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



7. Microsoft SQL Server 2005 Solutions MCITP 70-441:7 Designing Messaging Services for a Database Solution

Time: 1 hours
This course 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



8. Microsoft SQL Server 2005 Solutions MCITP 70-441:8 Designing a Reporting Services Solutions

Time: 1 hours
This course 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



9. Microsoft SQL Server 2005 Solutions MCITP 70-441:9 Designing Data Integration Solutions

Time: 1 hours
This course 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



10. Microsoft SQL Server 2005 Solutions MCITP 70-441:10 Practice Exam 1

Time: 1 hours
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.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam



11. Microsoft SQL Server 2005 Solutions MCITP 70-441:11 Practice Exam 2

Time: 1 hours
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.

Objectives

  • Complete the practice exam questions

Topics

  • Practice Exam



Resources for Microsoft SQL Server 2005 Solutions MCITP 70-441