| Microsoft Certified Database Administrator (MCDBA): Information Center |
| |
| Overview of Program |
|
| MCDBA Requirements |
|
| Prerequisites:
Understanding of Basic Development Languages and Relational Databases |
|
| 1
Core SQL Server Administration Exam Required |
|
| SQL Server Admin. Exam: 70-228 |
| Learning Asset |
Product Title |
Product ID |
Hours |
| Courseware |
|
|
|
| 1 |
Overview
of SQL Server 2000 |
31478_ENG |
1.75 |
| 1 |
Installing,
Configuring, and Upgrading SQL Server 2000 |
31489_ENG |
2.00 |
| 1 |
SQL
Server 2000 Databases |
31493_ENG |
1.75 |
| 1 |
Transferring
and Transforming Data in SQL Server 2000 |
31496_ENG |
1.50 |
| 1 |
Security
in a Microsoft SQL Server 2000 Environment |
31499_ENG |
2.00 |
| 1 |
Managing
SQL Server 2000 Databases |
31552_ENG |
2.25 |
| 1 |
Backing
Up SQL Server 2000 Databases |
31556_ENG |
2.00 |
| 1 |
Restoring
SQL Server 2000 Databases |
31560_ENG |
1.75 |
| 1 |
SQL
Server 2000 Replication |
31563_ENG |
1.75 |
| 1 |
Monitoring
SQL Server 2000 Performance |
31566_ENG |
1.50 |
| 1 |
SQL
Server 2000 High Availability |
31569_ENG |
1.00 |
| 1 |
SQL
Server 2000, XML, and the Web |
31571_ENG |
1.50 |
| |
Totals |
12 |
20.75 |
| 1
Core SQL Server Design Exam Required |
|
| SQL Server Design Exam: 70-229 |
| Courseware |
|
|
|
| 1 |
Overview
of SQL Server 2000 |
31478_ENG |
1.75 |
| 1 |
SQL
Server 2000 Databases |
31493_ENG |
1.75 |
| 1 |
Transferring
and Transforming Data in SQL Server 2000 |
31496_ENG |
1.25 |
| 1 |
SQL
Server 2000, XML, and the Web |
31571_ENG |
1.50 |
| 1 |
Designing
and Implementing Security in SQL Server 2000 |
31898_ENG |
1.00 |
| 1 |
The
SQL Server 2000 Logical Data Model |
31901_ENG |
2.25 |
| 1 |
Using
T-SQL in SQL Server 2000 |
31905_ENG |
3.00 |
| 1 |
SQL
Server 2000 Indexes |
31910_ENG |
2.00 |
| 1 |
SQL
Server 2000 Programming Business Logic |
31913_ENG |
2.75 |
| 1 |
SQL
Server 2000 Transactions and Distributed Data |
31917_ENG |
1.50 |
| 1 |
Analyzing
and Optimizing SQL Server 2000 Queries |
31920_ENG |
1.50 |
| |
Totals |
11 |
20.25 |
| 1
Core Networking System Exams Required: |
|
| Networking System Exam: 70-290 |
| Learning
Asset |
Product Title |
Product ID |
Hours |
| Courseware |
|
|
|
| 1 |
Windows Server
2003: Basic Concepts |
124011_ENG |
1.00 |
| 1 |
Windows
Server 2003: Managing Users, Groups, and Computers |
123546_ENG |
3.00 |
| 1 |
Windows
Server 2003: Managing Resource Access |
123572_ENG |
3.00 |
| 1 |
Windows
Server 2003: Managing Hardware, Disks, and Logical Devices |
123582_ENG |
3.00 |
| 1 |
Windows
Server 2003: Managing the Server Environment |
123605_ENG |
4.00 |
| 1 |
Windows
Server 2003: Managing Disaster Recovery |
123583_ENG |
2.00 |
| |
Totals |
6 |
16.00 |
| Networking System Exam: 70-291 |
| Courseware |
|
| 1 |
Windows Server
2003: Implementing, Managing, and Maintaining TCP/IP |
125865_ENG |
2.00 |
| 1 |
Windows
Server 2003: Implementing, Managing, and Maintaining DHCP |
126071_ENG |
3.00 |
| 1 |
Windows
Server 2003: Implementing, Managing, and Maintaining Name Resolution |
125926_ENG |
3.00 |
| 1 |
Windows
Server 2003: Implementing, Managing, and Maintaining Network Security and
Software |
125927_ENG |
|
| 1 |
Windows
Server 2003: Implementing, Managing, and Maintaining Remote Access |
125928_ENG |
3.00 |
| 1 |
Windows
Server 2003: Implementing, Managing, and Maintaining Routing |
126092_ENG |
3.00 |
| 1 |
Windows
Server 2003: Maintaining a Network Infrastructure |
125929_ENG |
2.00 |
| |
Totals |
7 |
16.00 |
| Networking System Exam: 70-215 |
| Courseware |
|
|
|
| 1 |
Windows
2000 - New Features and Architecture |
112593_ENG |
3.50 |
| 1 |
Windows
2000 - Installation |
112681_ENG |
5.00 |
| 1 |
Windows
2000 - Administration |
112790_ENG |
3.00 |
| 1 |
Windows
2000 - Users |
112804_ENG |
3.25 |
| 1 |
Windows
2000 - Groups and Terminal Services |
112818_ENG |
3.50 |
| 1 |
Windows 2000 -
Files and Folders |
112836_ENG |
4.00 |
| 1 |
Windows
2000 - Advanced File and Folder Management |
112876_ENG |
3.75 |
| 1 |
Windows
2000 - Hardware Configuration and Optimization |
112893_ENG |
6.25 |
| 1 |
Windows
2000 - Storage and Printing |
112987_ENG |
5.50 |
| 1 |
Windows
2000 - Events |
113251_ENG |
3.00 |
| 1 |
Windows 2000 -
Backup and Recovery |
113373_ENG |
3.75 |
| 1 |
Windows
2000 - Group Policy |
113410_ENG |
6.25 |
| 1 |
Windows
2000 - Network Protocols and Remote Access |
113467_ENG |
3.00 |
| |
Totals |
13 |
53.75 |
| 1 Elective
Required Exam |
|
|
|
| Elective Exam: 70-216 |
| Courseware |
|
|
|
| 1 |
Windows
2000 - Implementing a Network Infrastructure: IP Routing |
113523_ENG |
4.00 |
| 1 |
Windows 2000 -
Implementing a Network Infrastructure: Addressing and Naming Services |
113522_ENG |
6.00 |
| 1 |
Windows
2000 - Implementing a Network Infrastructure: Security |
113524_ENG |
5.00 |
| 1 |
Windows
2000 - Implementing a Network Infrastructure: Remote Access and Network
Protocols |
119873_ENG |
3.00 |
| |
Totals |
4 |
18.00 |
| Elective Exam: 70-293 |
| Courseware |
|
|
|
| 1 |
Windows
Server 2003: Planning the Network Infrastructure |
127946_ENG |
3.75 |
| 1 |
Windows
Server 2003: Planning for Name Resolution |
127959_ENG |
3.00 |
| 1 |
Windows
Server 2003: Implementing Routing and Remote Access |
127971_ENG |
3.00 |
| 1 |
Windows
Server 2003: Planning for Network Availability |
128023_ENG |
2.00 |
| 1 |
Windows
Server 2003: Planning Server Roles and Server Security |
128052_ENG |
2.75 |
| 1 |
Windows
Server 2003: Planning a Security Infrastructure |
128064_ENG |
3.00 |
| |
Totals |
6 |
17.50 |
| Elective Exam: 70-305 |
| Courseware |
|
|
|
| 1 |
Introducing
Microsoft .NET |
31679_ENG |
4.50 |
| 1 |
Moving
to Visual Basic .NET |
61588_ENG |
5.25 |
| 1 |
Advanced
Language Features of Microsoft VB.NET |
61594_ENG |
5.25 |
| 1 |
Windows
Forms and ASP.NET |
61599_ENG |
4.50 |
| 1 |
Introduction
to ASP.NET |
66794_ENG |
2.50 |
| 1 |
Building
ASP.NET Applications |
66795_ENG |
6.25 |
| 1 |
Optional
ASP.NET Features and Finalizing ASP.NET Applications |
66796_ENG |
5.75 |
| 1 |
ADO.NET
Connections and Commands |
73686_ENG |
4.25 |
| 1 |
Building
ADO.NET DataSets |
73687_ENG |
4.00 |
| 1 |
Advanced
ADO.NET Programming |
73689_ENG |
4.50 |
| 1 |
Assemblies
and Configuration in .NET |
84842_ENG |
3.25 |
| 1 |
Security
With VB.NET |
84854_ENG |
5.50 |
| 1 |
Testing
and Instrumenting Web Applications in VB.NET |
112070_ENG |
3.00 |
| 1 |
Web
Application Tracing and Debugging in VB.NET |
112074_ENG |
3.75 |
| 1 |
Web
Application Maintenance in VB.NET |
112219_ENG |
3.25 |
| 1 |
Planning
and Starting the Deployment of a .NET Web Application |
115334_ENG |
2.25 |
| 1 |
Using
Visual Studio .NET to Deploy a Web-based Application |
115333_ENG |
2.75 |
| 1 |
ASP.NET
User Interface Considerations |
117745_ENG |
2.50 |
| 1 |
Adding
Professional Features to an ASP.NET User Interface |
117893_ENG |
2.50 |
| 1 |
Globalizing
ASP.NET Applications |
117761_ENG |
1.50 |
| 1 |
Advanced
ASP.NET Topics |
117772_ENG |
3.75 |
| |
Totals |
21 |
80.75 |
| Elective Exam: 70-306 |
| Courseware |
|
|
|
| 1 |
Introducing
Microsoft .NET |
31679_ENG |
4.50 |
| 1 |
Moving
to Visual Basic .NET |
61588_ENG |
5.25 |
| 1 |
Advanced
Language Features of Microsoft VB.NET |
61594_ENG |
5.25 |
| 1 |
Windows
Forms and ASP.NET |
61599_ENG |
4.50 |
| 1 |
ADO.NET
Connections and Commands |
73686_ENG |
4.25 |
| 1 |
Building
ADO.NET DataSets |
73687_ENG |
4.00 |
| 1 |
Advanced
ADO.NET Programming |
73689_ENG |
4.50 |
| 1 |
Application
Deployment in .NET |
79126_ENG |
2.00 |
| 1 |
Deployment
of Windows-Based .NET Applications |
79788_ENG |
6.00 |
| 1 |
Testing
and Instrumenting VB.NET Applications |
79986_ENG |
5.00 |
| 1 |
Application
Maintenance and Optimization in VB.NET |
79995_ENG |
2.25 |
| 1 |
Assemblies
and Configuration in .NET |
84842_ENG |
3.25 |
| 1 |
Security
With VB.NET |
84854_ENG |
5.50 |
| 1 |
Windows
Forms and Controls in VB.NET |
108764_ENG |
3.25 |
| 1 |
Customizing
Controls and Events in VB.NET |
121217_ENG |
2.25 |
| 1 |
Input
Validation and Error Handling in VB.NET |
108765_ENG |
2.00 |
| 1 |
Adding
Services and Components in VB.NET |
109638_ENG |
2.25 |
| 1 |
Printing,
Reporting, Help, Accessibility, Localization, and Globalization in VB.NET |
109314_ENG |
3.00 |
| |
Totals |
18 |
69.00 |
| Elective Exam: 70-310 |
| Courseware |
|
| 1 |
XML Web
Services and Microsoft.NET |
61990_ENG |
3.00 |
| 1 |
Building
Web Services and Web-Service Clients with Microsoft .NET |
61994_ENG |
2.50 |
| 1 |
Moving
to Visual Basic .NET |
61588_ENG |
5.25 |
| 1 |
Advanced
Language Features of Microsoft VB.NET |
61594_ENG |
5.25 |
| 1 |
Windows
Forms and ASP.NET |
61599_ENG |
4.50 |
| 1 |
ADO.NET
Connections and Commands |
73686_ENG |
4.25 |
| 1 |
Building
ADO.NET DataSets |
73687_ENG |
4.00 |
| 1 |
Advanced
ADO.NET Programming |
73689_ENG |
4.50 |
| 1 |
Assemblies
and Configuration in .NET |
84842_ENG |
3.25 |
| 1 |
Security
With VB.NET |
84854_ENG |
5.50 |
| 1 |
Testing
and Instrumenting Web Applications in VB.NET |
112070_ENG |
3.00 |
| 1 |
Web
Application Tracing and Debugging in VB.NET |
112074_ENG |
3.75 |
| 1 |
Web
Application Maintenance in VB.NET |
112219_ENG |
3.25 |
| 1 |
Planning
and Starting the Deployment of a .NET Web Application |
115334_ENG |
2.25 |
| 1 |
Using
Visual Studio .NET to Deploy a Web-based Application |
115333_ENG |
2.75 |
| 1 |
Windows
Services in VB.NET |
116720_ENG |
2.00 |
| 1 |
Interoperability
and Serviced Components |
116749_ENG |
3.25 |
| 1 |
.NET
Remoting |
116782_ENG |
4.00 |
| 1 |
XML
Data Access in VB.Net |
116805_ENG |
3.00 |
| |
Totals |
19 |
69.25 |
| Elective Exam: 70-315 |
| Courseware |
|
| 1 |
Introducing
Microsoft .NET |
31679_ENG |
4.50 |
| 1 |
Inside
C# |
65409_ENG |
6.50 |
| 1 |
Programming
C# for the C++ Developer |
65410_ENG |
7.50 |
| 1 |
Beginning
C# |
64554_ENG |
7.25 |
| 1 |
Programming
C# for the VB6 Developer |
64556_ENG |
7.75 |
| 1 |
Assemblies
and Configuration with C# in .NET |
110465_ENG |
3.25 |
| 1 |
Security
with C# |
110468_ENG |
5.50 |
| 1 |
ADO.NET
Connections and Commands |
129900_ENG |
3.75 |
| 1 |
Building
ADO.NET DataSets |
129901_ENG |
2.25 |
| 1 |
Advanced
ADO.NET Programming |
129902_ENG |
2.25 |
| 1 |
Managing
Disconnected Data |
131252_ENG |
3.25 |
| 1 |
Testing
and Instrumenting Web Applications in C# |
132055_ENG |
3.00 |
| 1 |
Web
Application Tracing and Debugging in C# |
132056_ENG |
3.75 |
| 1 |
Web
Application Maintenance in C# |
132057_ENG |
3.25 |
| |
Totals |
14 |
63.75 |
| Elective Exam: 70-316 |
| Courseware |
|
|
|
| 1 |
Introducing
Microsoft .NET |
31679_ENG |
4.50 |
| 1 |
Inside
C# |
65409_ENG |
6.50 |
| 1 |
Programming
C# for the C++ Developer |
65410_ENG |
7.50 |
| 1 |
Beginning
C# |
64554_ENG |
7.25 |
| 1 |
Programming
C# for the VB6 Developer |
64556_ENG |
7.75 |
| 1 |
Application
Deployment in .NET |
79126_ENG |
2.00 |
| 1 |
Deployment
of Windows-Based .NET Applications |
79788_ENG |
6.00 |
| 1 |
Testing
and Instrumenting Applications in C# |
109340_ENG |
5.00 |
| 1 |
Application
Maintenance and Optimization in C# |
109343_ENG |
2.25 |
| 1 |
Assemblies
and Configuration with C# in .NET |
110465_ENG |
3.25 |
| 1 |
Security
with C# |
110468_ENG |
5.50 |
| 1 |
ADO.NET
Connections and Commands |
129900_ENG |
3.75 |
| 1 |
Building
ADO.NET DataSets |
129901_ENG |
2.25 |
| 1 |
Advanced
ADO.NET Programming |
129902_ENG |
2.25 |
| 1 |
Managing
Disconnected Data |
131252_ENG |
3.25 |
| 1 |
Windows
Forms and Controls in C# |
130035_ENG |
3.75 |
| 1 |
Customizing
Controls and Events in C# |
130036_ENG |
2.25 |
| 1 |
Input
Validation and Error Handling in C# |
130037_ENG |
2.00 |
| 1 |
Adding
Services and Components in C# |
130038_ENG |
2.00 |
| 1 |
Printing,
Help, Accessibility, Localization, and Globalization in C# |
130039_ENG |
2.75 |
| |
Totals |
20 |
81.75 |
| Elective Exam: 70-320 |
| Courseware |
|
|
|
| 1 |
Introducing
Microsoft .NET |
31679_ENG |
5.00 |
| 1 |
Inside
C# |
65409_ENG |
6.50 |
| 1 |
Programming
C# for the C++ Developer |
65410_ENG |
7.50 |
| 1 |
Beginning
C# |
64554_ENG |
7.25 |
| 1 |
Programming
C# for the VB6 Developer |
64556_ENG |
7.75 |
| 1 |
Assemblies
and Configuration with C# in .NET |
110465_ENG |
3.25 |
| 1 |
Security
with C# |
110468_ENG |
5.50 |
| 1 |
XML
Web Services and Microsoft.NET |
61990_ENG |
3.00 |
| 1 |
Building
Web Services and Web-Service Clients with Microsoft .NET |
61994_ENG |
2.50 |
| 1 |
Windows
Services in C# |
130090_ENG |
2.00 |
| 1 |
Interoperability
and Serviced Components in C# |
130091_ENG |
3.25 |
| 1 |
.NET
Remoting in C# |
130092_ENG |
4.00 |
| 1 |
XML
Data Access in C# |
130093_ENG |
3.00 |
| 1 |
ADO.NET
Connections and Commands |
129900_ENG |
3.75 |
| 1 |
Building
ADO.NET DataSets |
129901_ENG |
2.25 |
| 1 |
Advanced
ADO.NET Programming |
129902_ENG |
2.25 |
| 1 |
Managing
Disconnected Data |
131252_ENG |
3.25 |
| 1 |
XML
Web Services and Microsoft.NET |
130206_ENG |
2.50 |
| 1 |
Building
and using web services |
210879_ENG |
1.50 |
| 1 |
Building
Web Services and Web Service Clients with Microsoft .NET |
130207_ENG |
1.50 |
| 1 |
Testing
and Instrumenting Web Applications in C# |
132055_ENG |
3.00 |
| 1 |
Web
Application Tracing and Debugging in C# |
132056_ENG |
3.75 |
| 1 |
Web
Application Maintenance in C# |
132057_ENG |
3.25 |
| |
Totals |
23 |
87.50 |
|
|
|
|