Learn iT! Desktop Training
Learn iT! Professional Development courses

SQL 2008/2005 Business Intelligence - Certifications

SQL Server 2008
MCTS: SQL Server 2008, Business Intelligence Development & Maintenance
MCITP: Business Intelligence Developer 2008

Upgrade to SQL Server 2008 from SQL Server 2005
MCITP: Business Intelligence Developer 2008 (upgrading from MCITP SQL Server 2005 Business Intelligence)

SQL Server 2005
MCTS: SQL Server 2005 Business Intelligence 
MCITP: Business Intelligence Developer on Microsoft SQL Server 2005

PerformancePoint Server 2007
MCTS: Microsoft Office PerformancePoint Server 2007, Configuring


SQL Server 2008 - Business Intelligence

MCTS: SQL Server 2008, Business Intelligence Development & Maintenance
MS Certified Technology Specialist (1 MCTS exam)
When you earn a MS Certified Technology Specialist (MCTS) certification, you validate your deep technical knowledge and skill using the features and functionality of key technology areas in MS SQL Server 2008. You can demonstrate your depth of knowledge in one specific area, earn multiple MCTS certifications to show breadth across different areas, or build on the MCTS to earn a Professional Series credential.
(1) Recommended Foundation
6231 Maintaining a MS SQL Server 2008 Database (Administrator) (5 days)  
 
(2) MS SQL Server 2008, Business Intelligence Development & Maintenance (1 MCTS exam)
6234 Implementing & Maintaining MS SQL Server 2008 Analysis Services (3 days) exam 70-448
6235 Implementing & Maintaining MS SQL Server 2008 Integration Services (3 days)
6236 Implementing & Maintaining MS SQL Server 2008 Reporting Services (3 days)
 
OR: Experienced SQL 2005 BI Developers: Can update skills to SQL Server 2008 MCTS level by taking 6158.
6158* Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 days) exam 70-448
 
*Note: If you are already certified as a SQL Server 2005 MCITP Business Intelligence Developer please refer to the SQL Server 2008 Upgrading section and exam 70-455.
 
MCITP: Business Intelligence Developer 2008
MS Certified IT Professional (1 MCTS exam + 1 MCITP exam)
When you earn the MS Certified IT Professional (MCITP) credential, you demonstrate your professional expertise in using MS SQL Server 2008 to excel in a specific, actual job role.
(1) Recommended Foundation
6231 Maintaining a MS SQL Server 2008 Database (Administrator) (5 days)  
 
(2) Obtain the MCTS: SQL Server 2008, Business Intelligence Development & Maintenance certification (1 MCTS exam)
6234 Implementing & Maintaining MS SQL Server 2008 Analysis Services (3 days) exam 70-448
6235 Implementing & Maintaining MS SQL Server 2008 Integration Services (3 days)
6236 Implementing & Maintaining MS SQL Server 2008 Reporting Services (3 days)
 
OR: Experienced SQL 2005 BI Developers: Can update skills to SQL Server 2008 MCTS level by taking 6158.
6158* Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 days) exam 70-448
 
*Note: If you are already certified as a SQL Server 2005 MCITP BI Developer please refer to the SQL Server 2008 Upgrading section and exam 70-455.
 
(3) Designing a Business Intelligence Infrastructure Using SQL Server 2008 (1 MCITP exam)
TBD SQL 2008 BI Design course TBD (5 days) exam 70-452

SQL Server 2008 (upgrading from MCITP SQL Server 2005 Business Intelligence)

MCITP: BI Developer 2008 (upgrading from MCITP SQL Server 2005 BI)
MS Certified IT Professional (1 MCITP upgrade exam)
When you earn the MS Certified IT Professional (MCITP) credential, you demonstrate your professional expertise in using MS SQL Server 2008 to excel in a specific, actual job role.
Transition Your MCITP BI Developer 2005 Skills to MCITP BI Developer 2008 (1 MCITP upgrade exam)
6158* Updating Your SQL Server 2005 Skills to SQL Server 2008 (3 days) exam 70-455
 
*Note: Earn both the MCTS: SQL Server 2008, Business Intelligence Development & Maintenance, & MCITP: Business Intelligence Developer 2008 certifications by passing the 70-455 upgrade exam.

SQL Server 2005 - Business Intelligence

MCTS: SQL Server 2005 Business Intelligence
MS Certified Technology Specialist (1 MCTS exam)
MS Certified Technology Specialists in MS SQL Server 2005 Business Intelligence implement and maintain business intelligence solutions. They have thorough knowledge of the MS SQL Server 2005 Business Intelligence Development tool suite. This includes knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the MS .NET Framework. They can write database queries, use SSAS data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience.
MS SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam)
2791 Implementing and Maintaining MS SQL Server 2005 Analysis Services 3 days exam 70-445
2792 Implementing and Maintaining MS SQL Server 2005 Integration Services 3 days
2793 Implementing and Maintaining MS SQL Server 2005 Reporting Services 3 days
 
MCITP: Business Intelligence Developer on MS SQL Server 2005
MS Certified IT Professional (1 MCTS exam + 1 MCITP exam)
MCITP: Business Intelligence Developer is the premier certification for business intelligence system designers and developers. This certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), custom transforms, and custom reporting solutions.
1) MS SQL Server 2005 Business Intelligence - Implementation and Maintenance (1 MCTS exam)
2791 Implementing and Maintaining MS SQL Server 2005 Analysis Services 3 days exam 70-445
2792 Implementing and Maintaining MS SQL Server 2005 Integration Services 3 days
2793 Implementing and Maintaining MS SQL Server 2005 Reporting Services 3 days
 
2) Designing a Business Intelligence Solution by Using MS SQL Server 2005 (1 MCITP exam)
2794 Designing a Business Intelligence Solution Architecture for the Enterprise Using MS SQL Server 2005 2 days exam 70-446
2795 Designing an ETL Solution Architecture Using MS SQL Server 2005 Integration Services 2 days
2796 Designing an Analysis Solution Architecture Using MS SQL Server 2005 Analysis Services 3 days
2797 Designing a Reporting Solution Architecture Using MS SQL Server 2005 Reporting Services 2 days

PerformancePoint Server 2007

Microsoft Certified Technology Specialist (1 MCTS exam)
Candidates for this exam typically work in an environment in which they are responsible for the implementation and configuration of PerformancePoint Server. Their organizations require the use of PerformancePoint Server for business analysis and integration. Candidates for this exam are expected to know how to correctly install and configure PerformancePoint Server in their organizations. Candidates should have six months to a year of experience in monitoring, analyzing, and planning the use of PerformancePoint Server in a medium-size to enterprise-size computing environment.

The qualified candidate for this exam typically: installs and maintains PerformancePoint Server 2007; monitors and troubleshoots PerformancePoint Server 2007; monitors, analyzes, and plans business activities that use PerformancePoint Server 2007; drives alignment, accountability, and actionable insight across an entire organization; drives better adoption and compliance by enabling organizations to better associate business intelligence with corporate performance. Candidates for this exam will also monitor, analyze, and plan activities that use an integrated and collaborative solution.
Microsoft Office PerformancePoint Server 2007, Applications (1 MCTS exam)
50141 Microsoft Office PerformancePoint Server 2007 Technical Training (5 days) exam 70-556

Contact Us

about our courses.
for your team.



San Francisco: 415.693.0250
Santa Clara: 408.200.0953


Learn iT! Customer Testimonials


Learn IT! Anywhere - training from the comfort of your home or office. Click to learn more about Learn IT! Anywhere Click to get more information about the Learn IT! Anywhere program. Learn IT! Anywhere class listing. Click to log in to Learn IT! Anywhere and attend a class.

 
Microsoft Gold Partner Software Assurance Citrix Partner Project Management Institute Microsoft Office Specialist Training Adobe Authorized Training Center