Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 candidates need to pass three core exams and one elective exam that provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of SQL Server databases.
MCDBAs on Microsoft SQL Server 2000 are not required to pass Windows Server 2003 exams to retain MCDBA certification. The Windows 2000 Server exams and the Windows Server 2003 exams for the MCDBA on SQL Server 2000 certification remain available concurrently.
Core Exams (3 Exams Required)
MCDBA candidates are required to pass one SQL Server administration exam and one SQL Server design exam. In addition, MCDBA candidates have the option to pass either one Windows 2000 Server or one Windows Server 2003 exam to fulfill the networking systems core requirement.3
Elective Exams (1 Exam Required)
In addition to the core exam requirements, you must also pass one elective exam that provides proof of expertise with a specific Microsoft server product.3
| Core Exams (3 Exams Required) |
| Core Exams: SQL Server Administration (1 Exam Required) |
| Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition |
| Exam 70-0283,4: Administering Microsoft SQL Server 7.0 |
| Core Exams: SQL Server Design(1 Exam Required) |
| Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition |
| Exam 70-0293,4: Designing and Implementing Databases with Microsoft SQL Server 7.0 |
| Core Exams: Networking Systems1(1 Exam Required) |
| Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment |
| Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure |
| Exam 70-2152: Installing, Configuring, and Administering Microsoft Windows 2000 Server |
| Elective Exams (1 Exam Required) |
| Elective Exams(1 Exam Required) |
| Exam 70-2162: Implementing and Administering a Microsoft Windows 2000 Network Infrastructure |
| Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure |
| Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic® .NET and Microsoft Visual Studio® .NET |
| Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET |
| Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework |
| Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C#™ .NET and Microsoft Visual Studio .NET |
| Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET |
| Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework |
| Exam 70-0154: Designing and Implementing Distributed Applications with Microsoft Visual C++® 6.0 |
| Exam 70-0193,4: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0 |
| Exam 70-1554: Designing and Implementing Distributed Applications with Microsoft Visual FoxPro® 6.0 |
| Exam 70-1754: Designing and Implementing Distributed Applications with Microsoft Visual Basic® 6.0 |
Managing and Maintaining a Microsoft Windows Server 2003 Environment (Exam: 70-290)
This certification exam measures your ability to manage and maintain a Microsoft Windows Server 2003 environment.
Objectives:
- Prepare to administer server resources.
- Configure a server to monitor system performance.
- Monitor system performance.
- Manage device drivers by configuring device driver signing and restoring a device driver.
- Manage hard disks.
- Manage data storage.
- Manage disaster recovery.
- Maintain software by using Microsoft Software Update Services.
Course content:
- Introduction Microsoft Windows Server 2003
- Administering Microsoft Windows Server 2003
- User Accounts
- Group Accounts
- Computer Accounts
- Files and Folders
- Backing Up Data
- Printers
- Maintaining the Operating System
- Managing Hardware Devices and Drivers
- Managing Microsoft Windows Server 2003 Disk Storage
- Monitoring Microsoft Windows Server 2003
- Recovering from System Failure
Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (Exam: 70-293)
This certification exam measures your ability to plan and maintain a Microsoft Windows Server 2003 network infrastructure.
Objectives:
- Plan a TCP/IP physical and logical network.
- Plan and troubleshoot a routing strategy.
- Plan a Dynamic Host Configuration Protocol (DHCP) strategy.
- Optimize and troubleshoot DHCP.
- Plan a Domain Name System (DNS) strategy.
- Optimize and troubleshoot DNS.
- Plan and optimize Windows Internet Naming Service (WINS).
- Plan, optimize, and troubleshoot IPSec network access.
- Troubleshoot network access
Course content:
- Planning a Network Topology
- Planning a TCP/IP Network Infrastructure
- Planning Internet Connectivity
- Planning a Name Resolution Strategy
- Using Routing and Remote Access
- Maintaining Server Availability
- Clustering Servers
- Planning a Secure Baseline Installation
- Hardening Servers
- Deploying Security Configurations
- Creating and Managing Digital Certificates
- Securing Network Communications Using IPSec
- Designing a Security Infrastructure
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition (70-228)
This certification exam measures your ability to administer and troubleshoot information systems that incorporate Microsoft SQL Server 2000 Enterprise Edition.
- Overview of SQL Server 2000
- Installing SQL Server 2000
- Preparing to Use SQL Server 2000
- Upgrading to SQL Server 2000
- Understanding System and User Databases
- Creating and Configuring User Database
- Populating a Database
- Developing a Data Restoration Strategy
- Backing Up and Restoring SQL Server
- Managing Access to SQL Server 2000
- Managing SQL Server Permissions
- Performing Administrative Tasks
- Automating Administrative Tasks
- Monitoring SQL Server Performance and Activity
- Using SQL Server Replication
- Maintaining High Availability
Microsoft SQL Server 2000 Database Design and Implementation (Exam: 70-229)
This certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition.
- Introduction to Microsoft SQL Server 2000
- Using Transact-SQL on a SQL Server Database
- Designing a SQL Server Database
- Implementing SQL Server Databases and Tables
- Implementing Data Integrity
- Accessing and Modifying Data
- Managing and Manipulating Data
- Implementing Stored Procedures
- Implementing Triggers
- Implementing Views
- Implementing Indexes
- Managing SQL Server Transactions and Locks
- Designing and Administering SQL Server 2000 Security
- SQL Server Monitoring and Tuning
|
