微软认证数据库管理员

微软认证数据库管理员(MCDBA)为微软针对SQL Server数据库所推出的独立认证,特别针对数据库管理员所设计,持有此认证的专业人员,可被视为具有管理SQL Server以及设计数据库应用的专业能力与知识。MCDBA最早是自SQL Server 7.0开始推出,历经SQL Server 2000时期,两个时期的认证要求差不多,都是要求通过四科考试,包含数据库系统管理,数据库设计,伺服器操作系统管理以及选考科目。

本认证已随着Exam 70-228与Exam 70-229于2009年3月31日停考后正式走入历史,但已发出的认证为永久有效。

MCDBA on SQL Server 7.0

MCDBA on SQL Server 7.0是第一代的MCDBA认证,配合SQL Server 7.0所需要的执行环境,以及程序发展的需求所设计,当时的作业环境为Windows 2000,并且在SQL Server 7.0中首次支持数据仓库的建置,但在当时并不是主要的需求,因此将数据仓库的考试放置在选考科目中。

必考科目,伺服器作業系統:
Exam 70-215: Installing, Configuring, and Administering Microsoft Windows 2000 Server

必考科目,資料庫系統管理:
Exam 70-028: Administering Microsoft SQL Server 7.0 

必考科目,資料庫設計:
Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0 

選考科目(擇一應考,部份):
Exam 70-019: Designing and Implementing Data Warehouses With Microsoft SQL Server 7.0 
Exam 70-015: Designing and Implementing Distributed Applications by using Visual C++ 6.0
Exam 70-155: Designing and Implementing Distributed Applications by using Visual FoxPro 6.0
Exam 70-175: Designing and Implementing Distributed Applications by using Visual Basic 6.0

MCDBA on SQL Server 2000

在SQL Server 2000时代,由于作业环境横跨了Windows 2000和Windows Server 2003,因此MCDBA的考试也纳入两个环境,在SQL Server 2000的考试配置的差异和SQL Server 7.0时期差不多,都需要通过系统管理与数据库设计两科考试。

必考科目,伺服器作業系統(擇一應考):
Exam 70-215: Installing, Configuring, and Administering Microsoft Windows 2000 Server
Exam 70-290: Managing and Maintaining a Windows Server 2003 Environment
Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure

必考科目,資料庫系統管理:
Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

必考科目,資料庫設計:
Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition 

選考科目(擇一應考,部份):
Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Exam 70-316: Designing and Implementing Windows-Based Applications by using Visual C#.NET and Visual Studio .NET
Exam 70-306: Designing and Implementing Windows-Based Applications by using Visual Basic.NET and Visual Studio .NET
Exam 70-315: Designing and Implementing Web-Based Applications by using Visual C#.NET and Visual Studio .NET
Exam 70-305: Designing and Implementing Web-Based Applications by using Visual Basic.NET and Visual Studio .NET
Exam 70-320: Designing and Implementing XML Web Services and Server Components by using Visual C#.NET and Visual Studio .NET
Exam 70-310: Designing and Implementing XML Web Services and Server Components by using Visual Basic.NET and Visual Studio .NET
Exam 70-015: Designing and Implementing Distributed Applications by using Visual C++ 6.0
Exam 70-155: Designing and Implementing Distributed Applications by using Visual FoxPro 6.0
Exam 70-175: Designing and Implementing Distributed Applications by using Visual Basic 6.0
Exam 70-019: Designing and Implementing Data Warehouses With Microsoft SQL Server 7.0

后续认证

由于微软新一代认证层次结构的推展,MCDBA已由MCITP取代,但现行的MCDBA on SQL Server 2000仍为永久有效。

此认证的继承者为:

  • MCITP: Database Administrator
  • MCITP: Database Developer
  • MCITP: Business Intelligence Developer