微軟認證資料庫管理員
微軟認證資料庫管理員(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