MCITP Training

Microsoft SQL Server 2005 Business Intelligence
– Implementation and Maintenance
C

This exam will empower you with the capacity to maintain and sustain business intelligence solutions in an organization and how to advance, manipulate and manage Integration Services packages.

Applicants’ training prerequisites:

Acquaintance with relational and multidimensional database schemas;

A cube in SQL Server Analysis Services (SSAS);
SSAS data mining algorithms;

Practicality in devising SQL Server Reporting Services (SSRS) reports;
Able to author and deploy SQL Server Integration Services (SSIS) packages;
Experience with the Microsoft .NET Framework;

Certification:
It is mandatory that The Microsoft SQL Server 2005 Business Intelligence - Development and Maintenance course is taken before embarking on the following course:

MCTS: SQL Server 2005 Business Intelligence

Designing a Business Intelligence Infrastructure by Using
Microsoft SQL Server 2005
C

This exam - resorting to the Microsoft SQL Server 2005 - empowers IT qualified individuals with hands-on practice at devising and projecting business intelligence solutions.

Applicants’ training prerequisites:

Acquaintance with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), & SQL Server Reporting Services (SSRS);
Hands-on experience - minimum 1 year – with devising relational and multidimensional database schemas alike;
Hands-on experience with planning and constructing cubes tailored to business specifications;
Hands-on experience - one to two years – with writing both relational and multidimensional queries;

Troubleshoot business domains through data mining;

Writing reports tailored to business requirements;
Experience at collecting data into a data depository, from a multifarious sourced data environment;
Skills should extend to the ability to design enterprise-type solutions for very large multidimensional databases.

Certification:
The design of a Business Intelligence Solution through the Microsoft SQL Server 2005 is required, before embarking on the following course:

MCITP: Business Intelligence Developer.

MCITP: Database Administrator 2008
C

This exam is tailored to SQL Server 2008 Database administrators with at least three years of experience at supervising databases who wish to become experts at making design and technology related decisions. Gained lab skills comprise of: database server security solutions, database solutions for high availability, backup and recovery solutions, monitoring strategies and data distribution. These tasks will also help you understand the objectives and competencies required by the PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 certification exam. This exam counts as credit towards the following certification(s): Microsoft Certified IT Professional: Database Administrator 2008.

Applicants should also be proficient at:

Specifying scope availability solutions;
Data dissemination;
Scrutinize database stats, backups, etc;
Decide appropriate index rebuild time, file groups for backup, etc;
Delineate security solutions;
Supervise/troubleshoot the database server;
Boost performance such as physical tuning hardware, operating system, instance-level tuning & PerfMon;
Devise, deploy, migrate;
DInfrastructure design (i.e. storage, hardware, & number of servers or instances).

Certification:
The tests that this series prepares students to take are a part of earning the following:

Microsoft Certified Technology Specialist (MCTS): Windows Server 2008 Applications Infrastructure

Configuration and Microsoft Certified IT Professional (MCITP): Enterprise Administrator certifications.

Audience:
This series is for anyone who wants to achieve MCTS 70-643 certification.

Features:

Flash-based instructional demonstrations applying course concepts;
Instructional audio with graphics highlighting key points;
Exercises allow learners to practice in the actual application being studied;
A Course Topics list contains active hyperlinks, permitting quick access to specific topics;
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course;
Search text enables learners to rapidly search all text within a course to easily retrieve information required;
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank;
A skill assessment generates a customized learning path based on the results of a pre-test;
A glossary provides a reference for definitions of unfamiliar terms;
Bookmarking tracks the learner's progress in a course.

MCITP: Database Developer 2008
C

This exam is tailored to SQL Server 2008 Database administrators with at least three years of experience at supervising databases who wish to become experts at making design and technology related decisions. Gained lab skills comprise of: database server security solutions, database solutions for high availability, backup and recovery solutions, monitoring strategies and data distribution. These tasks will also help you understand the objectives and competencies required by the PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 certification exam. This exam counts as credit towards the following certification(s): Microsoft Certified IT Professional: Database Administrator 2008.

Applicants should also be proficient at:

Specifying scope availability solutions;
Data dissemination;
Scrutinize database stats, backups, etc;
Decide appropriate index rebuild time, file groups for backup, etc;
Delineate security solutions;
Supervise/troubleshoot the database server;
Boost performance such as physical tuning hardware, operating system, instance-level tuning & PerfMon;
Devise, deploy, migrate;
Infrastructure design (i.e. storage, hardware, & number of servers or instances).

Certification:

Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008 :

counts as credit toward the following certification(s):

Microsoft Certified IT Professional (MCITP): Database Developer 2008

MCITP: Business Intelligence Developer 2008
C

Applicants who aspire to hone their skills in typical Microsoft SQL Server business intelligence solutions BI – are required to possess two to three years of prior proficiency in earlier versions of SQL Server, such as its 2005 version. Requirements are discriminated below:

SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS);
USQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS);
USQL Server 2005 and SQL Server 2008 Business Intelligence Development Studio (BIDS);
Designing and building cubes;
Reporting proficiency;
Employ data mining algorithms to business problem domains;
Experience aggregating data into a data warehouse from multiple sources in a heterogeneous data environment;
Experience in designing enterprise-level solutions for very large multidimensional databases;
Assess and satisfy business requirements.

Certification:
Certification Exam 70-452 counts as credit toward the following certification:

Microsoft Certified IT Professional (MCITP): Business Intelligence Developer 2008

MCITP: Database Administrator on SQL Server 2005
U

This exam is meant to estimate applicants’ proficiency in establishing, designing, and sustaining an SQL Server 2008 system. Candidates need previous hands-on experience with using SQL Server 2008 – minimum two years or two to three years at its previous versions (i.e. 2005). Additional prior requirements consist of prior key management roles of the above server. Further requirements consist of:

Trainees with general IT knowledge, who are comfortable with the workings of the SQL Server 2008;
IT professionals who specialize in running SQL Server 2008;
Programmers who build applications using SQL Server 2008;
IT practitioners who devise third-party applications that are built-in to the SQL Server 2008.

This exam entitles candidates with an upgrade from the existing MCITP SQL Server 2005 DBA to MCITP SQL Server 2008.

Certification:
Certification Exam 70-453 also completes the requirements for the following certification:

MCITP: SQL Server 2008 Database Administrator

MCITP: Business Intelligence Developer on SQL Server 2005
U

This progression course is designed to certify applicants of their ability to sustain business intelligent solutions – BI – in their organizations which typically use the SQL Server 2008. It’s a pre-condition that candidates routinely perform services’ report, evaluation and integration. Their skills should equally extend to configuring, validating and troubleshooting switches and spot systems’ protection threats, as well as alleviate individual ones. Additional prerequisites consist of the following experience and respective duration concerning:

Microsoft .NET Framework One to two years;
SQL Server 2005 BI components two to three years;
SQL Server 2008 six months to one year;
SQL Server 2008 Business Intelligence Development Studio (BIDS);
Microsoft SQL Server Management Studio (SSMS);
Relational and multi-dimensional database schemas;
Cube creation & deployment in SQL Server Analysis Services (SSAS);
Creating and deploying a data mining model in SSAS;
Structuring relational and multi-dimensional database queries;
Devising and arranging SQL Server Reporting Services (SSRS) reports;
Conceiving & deploying SQL Server Integration Services (SSIS) packages.

This exam entitles candidates with an upgrade from the existing MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer.

Certification:
Certification Exam 70-455 also completes the requirements for the following certification:

MCITP: SQL Server 2008 BI Developer

Applications on a Windows Vista Client
for Consumer Support Technicians
C

Professional candidates for this exam aim to offer technical support to end users of the Windows Vista operating system stand-alone or small home-network environments in terms of installation, configuration and troubleshooting. Successful applicants should have previously worked with an ample array of desktop operating systems, desktop applications, mobile devices, network experience, viruses, malicious software, and hardware support issues.

Certification:

Certification Exam 70-623 also completes the requirements for the following certification:

Microsoft Certified IT Professional (MCITP): Consumer Support Technician

Windows Vista Configuration MCTS 70-620 Series
C

The Microsoft 70-620 test on installing and configuring Vista is the required exam to receive the Microsoft Certified Technology Specialist (MCTS): Windows Vista, Configuration certification. 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.

Certification:

The test that this series prepares students to take is a part of earning the Microsoft Certified Technology Specialist (MCTS): Windows Vista Configuration certification.

Audience:
This series is for anyone who wants to achieve MCTS 70-620 certification:

Features:

Flash-based instructional demonstrations applying course concepts;
Instructional audio with graphics highlighting key points;
Exercises allow learners to practice in the actual application being studied;
A Course Topics list contains active hyperlinks, permitting quick access to specific topics;
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required;
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank;
A skill assessment generates a customized learning path based on the results of a pre-test;
A glossary provides a reference for definitions of unfamiliar terms;
Bookmarking tracks the learner's progress in a course.

Windows SharePoint Services 3.0 MCTS 70-631 Series
C

This series will prepare you for the MCTS 70-631: Windows SharePoint Services 3.0, Configuring exam. This exam is the only requirement to apply for the Technology Specialist: Windows SharePoint Services 3.0, Configuration certification. This study guide will prepare you to deploy, configure, secure, and maintain SharePoint Services 3.0.

Certification:

The test that this series prepares students to take is a part of earning the Microsoft Certified Technology Specialist (MCTS): Windows SharePoint Services 3.0 Configuration certification.

Audience:

This course is for anyone who wants to achieve MCTS 70-631 certification.

Features:

Flash-based instructional demonstrations applying course concepts;
Instructional audio with graphics highlighting key points;
Exercises allow learners to practice in the actual application being studied;
A Course Topics list contains active hyperlinks, permitting quick access to specific topics;
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course;
Search text enables learners to rapidly search all text within a course to easily retrieve information required;
A skill assessment generates a customized learning path based on the results of a pre-test;
A glossary provides a reference for definitions of unfamiliar terms;
Bookmarking tracks the learner's progress in a course.

	Exam No	Training Courses	Type
		Microsoft Training Package The Microsoft Training package includes MCSE, MCSA, MCAD, MCDBA, MCSD, and MCDST. All courses shown below + Free Vista Practice Exams) = £1199.99 Buy Microsoft Training Package - MCITP MCITP Training Package includes all courses shown below that are underlined.