Certifications:
Microsoft Certified Technology Specialist (MCTS):SQL Server 2008, Implementation
and Maintenance
You need to pass one exam 70-432 focusing on installing, configuring and maintaining SQL Server
2008.
Skills measured include:
- Installing and configuring SQL Server 2008
- Maintaining SQL Server instances
- Managing SQL Server security
- Maintaining a SQL Server database
- Performing data management tasks
- Monitoring and troubleshooting SQL Server
- Optimising SQL Server performance
- Implementing high availability
Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and MaintenanceYou
need to pass one exam 70-432 focusing on installing, configuring and maintaining
SQL Server 2008.
Exam 70-432 also forms a credit towards: MCITP: Database Administrator 2008
MCTS: SQL Server 2008, Database Development
You need to pass one exam 70-433 covering the following areas:
- Implementing tables and views
- Implementing programming object
- Working with query fundamentals
- Applying additional query techniques
- Working with additional SQL Server components
- Working with XML data
- Gathering performance information
Exam 70-433: TS: Microsoft SQL Server 2008, Database Development
Exam 70-433 also forms a credit towards: MCITP: Database Developer 2008
MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
This certification is for candidates who work with SQL Server 2008 and work with the business intelligence technologies, including Reporting Services, Analysis Services and Integration Services.
You need to pass one exam 70-448 covering the following areas:
- Implementing a SQL Server Integration Services (SSIS) solution
- Configuring, deploying and maintaining SSIS
- Implementing a SQL Server Analysis Services (SSAS) solution
- Configuring, deploying and maintaining SSAS
- Implementing a SQL Server Reporting Services (SSRS) solution
- Configuring, deploying and maintaining SSRS
Exam 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
Exam 70-448 also forms a credit towards: MCITP: Business Intelligence Developer
2008
MCTS: Database Administrator 2008
This certification is targeted at the professional level SQL Server 2008 Database Administrator. It tests your ability to make appropriate design and technology choice considerations for your SQL Server 2008 installations.
You need to pass two exams – 70-432 (mentioned above) and 70-450 covering the following areas:
- Designing a SQL Server instance and a database solution
- Designing a database server security solution
- Designing a database solution for high availability
- Designing a backup and recovery solution
- Designing a monitoring strategy
- Designing a strategy to maintain and manage databases
- Designing a strategy for data distribution
Exam 70-450: TS: PRO: Designing, Optimizing and Maintaining a Database
Administrative Solution Using Microsoft SQL Server 2008
Upgrade Path:
If you hold the MCITP: Database Administrator certification on SQL Server 2005,
you can earn MCITP: Database Administrator 2008 by passing the following exam:
Exam 70-453: Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008
This is an upgrade exam that is designed to assess candidates’ knowledge of installing, configuring and maintaining a SQL Server 2008 system.
MCITP: Database Developer 2008
You need to pass two exams – 70-433 (mentioned above) and 70-451 covering the following areas:
- Designing a database strategy
- Designing database tables
- Designing programming objects
- Designing a transaction and concurrency strategy
- Designing an XML strategy
- Designing queries for performance
- Designing a database for optimal performance
Exam 70-451: PRO: Designing Database Solutions and Data Access Using Microsoft
SQL Server 2008
Upgrade Path:
If you hold the MCITP: Database Developer certification on SQL Server 2005,
you can earn MCITP: Database Developer 2008 by passing the following exam:
Exam 70-454: Upgrade: Transition your MCITP Database Developer Skills to MCITP Database Developer 2008
MCITP: Business Intelligence Developer 2008
This certification validates your ability to design, develop, deploy and maintain
business intelligence solutions by using SQL Server Integration Services,
Reporting Services and Analysis Services in SQL Server 2008.
You need to pass two exams – 70-428 (mentioned above) and 70-452 covering the following areas:
- Designing and managing reports
- Designing data mining models
- Administering a Business Intelligence (BI) solution
- Designing the BI architecture
- Designing and deploying SSIS packages
- Designing an analysis services database
Exam 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008
Upgrade Path:
If you hold the MCITP: Business Intelligence Developer certification on SQL Server
2005, you can earn MCITP: Business Intelligence Developer 2008 by passing the following exam:
Exam 70-455: Upgrade: Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI Developer