The MCDBA program and credential is designed for individuals who want to demonstrate that they have the necessary skills to design, implement, and administer Microsoft SQL Server 2000 databases. Database professionals who use or want to learn to use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) program. Click here to go to the MCTS course description. Microsoft will retire the two SQL Server 2000 exams (exam 70-228 and 70-229) on March 31, 2009.
Upon successful completion of this course, the student should:
- Demonstrate professional conduct and interpersonal communication skills.
- Install, upgrade, configure, and administer computer networking systems hardware and software.
- Demonstrate an understanding of problem-solving methods essential to troubleshooting a network infrastructure.
- Demonstrate knowledge of the key services used in a typical network environment.
- Demonstrate the basic skills in PC troubleshooting by using software diagnostic tools, test cards, and test equipment.
- Network PCs in both local and remote areas and optimize for performance.
- Demonstrate a functional understanding of operating systems principles and applications.
- Describe SQL Server architecture.
- Plan for a SQL Server installation, and then install an instance of SQL Server.
- Manage files and databases, including determining resource requirements.
- Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
- Perform and automate administrative tasks and create custom administrative tools.
- Back up databases and implement a backup strategy.
- Restore databases.
- Monitor and optimize SQL Server performance.
- Transfer and migrate data into databases.
- Maintain the high availability of SQL Server.
- Describe how to replicate data from one SQL Server to another.
- Be prepared to take Microsoft exams 70-290 – Maintaining a Microsoft Windows Server 2003 Environment, 70-291 – Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-293 – Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-228 – System Administration for Microsoft SQL Server 2000, and 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
Microsoft Certified Database Administrator (MCDBA)
GES 805 -- 460 hours
Course Objectives
- Demonstrate professional conduct and interpersonal communication skills.
- Install, upgrade, configure, and administer computer networking systems hardware and software.
- Demonstrate an understanding of problem-solving methods essential to troubleshooting a network infrastructure.
- Demonstrate knowledge of the key services used in a typical network environment.
- Demonstrate the basic skills in PC troubleshooting by using software diagnostic tools, test cards, and test equipment.
- Network PCs in both local and remote areas and optimize for performance.
- Demonstrate a functional understanding of operating systems principles and applications.
- Describe SQL Server architecture.
- Plan for a SQL Server installation, and then install an instance of SQL Server.
- Manage files and databases, including determining resource requirements.
- Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
- Perform and automate administrative tasks and create custom administrative tools.
- Back up databases and implement a backup strategy.
- Restore databases.
- Monitor and optimize SQL Server performance.
- Transfer and migrate data into databases.
- Maintain the high availability of SQL Server.
- Describe how to replicate data from one SQL Server to another.
- Be prepared to take Microsoft exams 70-290 – Maintaining a Microsoft Windows Server 2003 Environment, 70-291 – Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-293 – Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure, 70-228 – System Administration for Microsoft SQL Server 2000, and 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
The MCDBA program and credential is designed for individuals who want to demonstrate that they have the necessary skills to design, implement, and administer Microsoft SQL Server 2000 databases. Database professionals who use or want to learn to use Microsoft SQL Server 2005 should consider the Microsoft Certified Technology Specialist (MCTS) program. Click here to go to the MCTS course description. Microsoft will retire the two SQL Server 2000 exams (exam 70-228 and 70-229) on March 31, 2009.
Upon successful completion of this course, the student should:
