Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 candidates need to pass three core exams and one elective exam. These exams provide a valid and reliable measure of technical proficiency and expertise in the implementation and administration of Microsoft SQL Server databases.
Candidates who administer, develop, or analyze Microsoft SQL Server 2005 databases should consider the Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) credentials. These credentials give IT professionals a simpler and more targeted framework to display their technical skills and their ability to create database solutions for business problems.
| Courses Available | ||
| Course Code | Course Name | Duration |
| 70 – 228 | Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition | 7 Days |
| 70 – 229 | Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition | 7 Days |
| 70 – 290 | Managing and Maintaining a Microsoft Windows Server 2003 Environment | 11 Days |
| 70 – 293 | Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure | 5 Days |
Course Outline:-
70 - 228
- Installing and Configuring SQL Server 2000
- Creating SQL Server 2000
- Databases Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
- Extracting and Transforming Data with SQL Server 2000
- Managing and Monitoring SQL Server 2000 Security
- Managing, Monitoring, and Troubleshooting SQL Server 2000
70 - 229
- Developing a Logical Data Model
- Implementing the Physical Database
- Retrieving and Modifying Data
- Programming Business Logic
- Tuning and Optimizing Data Access
- Designing a Database Security Plan
70 - 290
- Managing and Maintaining Physical and Logical Devices
- Managing Users, Computers, and Groups
- Managing and Maintaining Access to Resources
- Managing and Maintaining a Server Environment
- Managing and Implementing Disaster Recovery
- Preparation Tools and Resources
70 - 293
- Planning and Implementing Server Roles and Server Security
- Planning, Implementing, and Maintaining a Network Infrastructure
- Planning, Implementing, and Maintaining Routing and Remote Access
- Planning, Implementing, and Maintaining Server Availability
- Planning and Maintaining Network Security
- Planning, Implementing, and Maintaining Security Infrastructure
