Mcse 70 290 Pdf Free Download

SQL Server 2000 and 2005 Certification Resources

By: | Updated: 2006-06-06 | Comments (2) | Related: More > Professional Development Certifications

Problem

Answering the question 'Why should I get certified?' yields many different answers. This is certainly the case for current versus aspiring DBA's. Some responses are personal and career driven while others are related to the excitement of learning new technologies.

No matter how you slice it the drivers and inherent benefits are there, although perception of value of the certification differs from person to person as well. For example, one perception with the SQL Server 2005 track is that the tests are a better representation of reality than previous certifications. Another important factor to take into consideration is the time and financial investment because this too can be costly. So, weigh your options and see if your employer can help you achieve this goal or see if this is something you can chip away at slowly, but surely.

Solution

In order to get a firm understanding of the current SQL Server certifications, below is a table comparing the two certifications with the available educational options. This information should serve as the foundation for researching and preparing for the tests.

SQL Server 2000 - MCDBA	SQL Server 2005 - MCITP: Database Administrator
Certification Requirements
Microsoft's MCDBA web site MCDBA on Microsoft SQL Server 2000 Certification Requirements	MCTS: SQL Server 2005 MCITP: Database Administrator
Certification Exams
Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Exam 70-290: Managing and Maintaining a Microsoft Windows Server 2003 Environment Exam 70-293: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure	Upgrade from MCDBA Exam 70-447 : UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005 Microsoft Technology Specialist Exam 70-431 : TS: Microsoft SQL Server 2005 - Implementation and Maintenance MCITP DBA Exam 70-443 : PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 Exam 70-444 : PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
Training Classes
Course 2072: Administering a Microsoft SQL Server 2000 Database (5 days) - Preparation for Exam 70-228 Course 2073: Programming a Microsoft SQL Server 2000 Database (5 days) - Preparation for Exam 70-229 Course 2274: Managing a Microsoft Windows Server 2003 Environment (5 days) - Preparation for Exam 70-290 Course 2278: Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure (5 days) - Preparation for Exam 70-293	Upgrade from MCDBA 2786 : Designing a Microsoft SQL Server 2005 Infrastructure (two days) 2787 : Designing Security for Microsoft SQL Server 2005 (two days) 2788 : Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days) 2789 : Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (one day) 2790 : Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days) Microsoft Technology Specialist 2779 : Implementing a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006) 2780 : Maintaining a Microsoft SQL Server 2005 Database (available as three-day classroom training in early 2006) MCITP DBA 2786 : Designing a Microsoft SQL Server 2005 Infrastructure (two days) 2787 : Designing Security for Microsoft SQL Server 2005 (two days) 2788 : Designing High Availability Database Solutions Using Microsoft SQL Server 2005 (three days) 2787 : Designing Security for Microsoft SQL Server 2005 (two days) 2789 : Administering and Automating Microsoft SQL Server 2005 Databases and Services 2005 (one day) 2790 : Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 (two days)
Certification Books
MCSE Training Kit: Microsoft SQL Server 2000 System Administration - Preparation for Exam 70-228 MCSE Training Kit: Microsoft SQL Server 2000 Database Design and Implementation - Preparation for Exam 70-229 MCSA/MCSE Self-Paced Training Kit (Exam 70-290): Managing and Maintaining a Microsoft Windows Server 2003 Environment - Preparation for Exam 70-290 MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294 - Preparation for Exam 70-290 MCSE Self-Paced Training Kit (Exam 70-293): Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure - Preparation for Exam 70-293 MCSE Self-Paced Training Kit: Microsoft Windows Server 2003 Core Requirements, Exams 70-290, 70-291, 70-293, 70-294 - Preparation for Exam 70-290 MCDBA Administering SQL Server 2000 Study Guide (Exam 70-228) MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) MCSA/MCSE/MCDBA: SQL Server 2000 Administration Study Guide, 2nd Edition (70-228) MCDBA Books on Amazon.com	MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server 2005 MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft SQL Server 2005 Database Server Infrastructure MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005 MCITP Self-Paced Training Kit (Exam 70-444): Optimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005 MCITP Self-Paced Training Kit (Exam 70-443): Designing a Microsoft SQL Server 2005 Database Server Infrastructure
Practice Tests
Measure Up Practice Tests	Measure Up Practice Tests - TS Measure Up Practice Tests - Database Admin
Testing Centers
Prometric Testing Centers	Prometric Testing Centers
Additional Resources
AppDev - CD-ROM's MCDBA Boot Camp TurboCert MCDBA2003 - Microsoft Certified Database Administrator (SQL Server 2000 & Windows Server 2003) Microsoft SQL Server 2000 Grand Slam Multimedia Training Suite MCDBA Cram Session	2936-2944: Microsoft E-Learning Series for Database Administrators, Database Developers, and Business Intelligence Developers

Next steps

Answer the why should I get certified question for yourself.
If you have a compelling reason, setup your certification goals.
Setup target dates to prepare and pass each exam.
Setup time on a daily or weekly basis to read and study for the tests.
Talk to your employer to see if they will pay for the tests or training or give you time on a weekly basis to study.
Take a practice test or two so you are prepared for the real thing.
Make the tests a slam dunk!