본문 바로가기
㏈ª By β┖υΕJini/MS-SQL

SQL 2008 MCITP 관련 자격증

by ㏈ª ☞ β┖υΕJini.κR 2009. 5. 14.
사용자 삽입 이미지
  


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:

Microsoft Certified Technology Specialist - SQL Server 2008 Implementation and Maintenance

  • 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

Microsoft Certified Technology Specialist - 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.

Microsoft Certified IT Professional - SQL Server 2008 Business Intelligence Development and Maintenance

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


 

MCITP: 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.

Microsoft Certified IT Professional - Database Administrator 2008

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

Microsoft Certified IT Professional - 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.

Microsoft Certified IT Professional - Business Intelligence Developer 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