Candidates on the MCDBA track need to pass three core exams and one elective that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of Microsoft SQL Server databases.
Suitable for:
Systems engineers, Technical support engineers, Systems analysts, Network analysts and Technical consultants
Further information available from the Microsoft web site
| MCSDBA TRACK |
|
Exam Code |
Course Title |
Duration
(days) |
Course Code |
|
Must pass the following exams: |
70-228
|
Administering a MS SQL Server 2000 Database |
5 |
|
| 70-229 |
Programming a Microsoft SQL Server 2000 Database |
5 |
|
| and |
| Querying MS SQL Server 2000 with Transact-SQL |
2 |
|
| Plus, pass one of the following exams: |
| 70-290 |
Managing a Microsoft Windows Server 2003 Environment |
5 |
MS2274 |
| Maintaining a Microsoft Windows Server 2003 Environment |
3 |
|
| or |
| Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 |
5 |
|
| 70-291 |
Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts |
2 |
MS2276 |
|
Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services |
5 |
MS2277 |
| or |
| Updating Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows Server 2003 |
5 |
|
| 70-215 |
Microsoft Windows 2000 Network and Operating Systems Essentials |
3 |
MS2151 |
|
Implementing Microsoft Windows 2000 Professional and Server |
5 |
MS2152 |
| or |
| Updating Sipport Skills from Microsoft Windows NT4 to Microsoft WIndows 2000 |
5 |
|
|
Plus, pass one of the following exams: |
| 70-216 |
Implementing a Microsoft Windows 2000 Network Infrastructure |
5 |
|
| Updating Sipport Skills from Microsoft Windows NT4 to Microsoft Windows 2000 |
5 |
|
| 70-293 |
Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure |
5 |
|
| 70-305 |
Developing Web Applications Using Microsoft Visual Studio .NET |
5 |
MS2310 |
| Programming with Microsoft Visual Basic.NET |
5 |
MS2373 |
| Programming ADO.NET |
3 |
MS2389 |
| 70-306 |
Programming with Microsoft Visual Basic.NET |
5 |
MS2373 |
| Programming ADO.NET |
3 |
MS2389 |
Developing .NET Windows Applications (Microsoft Visual Basic .NET)
|
5 |
MS2565 |
| 70-310 |
Developing XML Web Services Using Microsoft ASP.NET
|
3 |
MS2524 |
| Building COM+ Applications Using Microsoft .NET Enterprise Servics |
5 |
MS2557 |
| Programming ADO.NET |
3 |
MS2389 |
| 70-315 |
Developing Web Applications Using Microsoft Visual Studio .NET |
5 |
MS2310 |
| Programming with C# |
5 |
MS2124 |
| Programming ADO.NET |
3 |
MS2389 |
| 70-316 |
Developing MS.NET Applications for Windows (Visual C#.NET) |
5 |
MS2555 |
| Progamming with C# |
5 |
MS2124 |
| Programming with MS ADO.NET |
3 |
MS2389 |
| 70-320 |
Developing XML Web Services Using MS AS.NET |
3 |
MS2524 |
| Building COM+ Applications Using MS.NET Enterprise Services |
5 |
MS2557 |
| Programming with MS ADO.NET |
3 |
MS2389 |
| 70-019 |
Designing and Implementing a Data Warehouse using MS SQL Server 7.0 |
5 |
MS1502 |
| Designing and Implementing OLAP Solutions using MS SQL Server 2000 |
5 |
MS2074 |
Desktop Courses 
Microsoft Certified Database Administrator (MCDBA)