Find Schools & Degree Programs - Your New Career Training Starts Here!

Online MCDBA Training Certification

Microsoft MCDBA Certification Requirements

Are you interested in a career in database administration? Do you want a qualification that will open doors in the IT world? Or perhaps you just want to give your resume a boost? Perhaps becoming a Microsoft Certified Database Administrator is for you! The Microsoft Certified Database Administrator credential (or MCDA for short) proves to employers that you know your stuff when it comes to Microsoft software, particularly in relation to the programming language SQL and SQL 2000 Servers. The course focuses on SQL sever administration and design, and the programs Windows Server 2000 and 2003.

The MCAS is suitable for candidates from a range of abilities, though is probably more rewarding for those from a background other than IT. Primarily designed for office workers, the MCAS validates your experience working with Microsoft Windows products, and might give you the edge you need when looking for a role that requires computer literacy. There a a variety of ways to study and prepare for the exam or exams you will take, including instructor-led training, practice tests, self-paced training kits and Microsoft Press books. Although some may prefer instructor-led training, Microsoft recommends a self-study method, and offers preparation guides for each exam, which include a list of relevant skills students can practice. Upon completion of your tutor-led or self-study program, you must then sit and pass a four-part exam to gain the MCDA qualification. Topics covered on the exam are:

  • SQL server administration
  • SQL server design
  • Windows 2000 or 2003 server networking
  • An elective, chosen by the student

Part four of the exam is elected by the student, and is designed to show particular competency in their choice of Microsoft server product. In this way, students may specialize on their exam in order to show particular interest or skill in certain server products. Although an MCDA may help you get into the database administration world, candidates should bear in mind that many employers prefer applicants with a Bachelor's degree in a related field (such as computer science or information systems). There are many relative careers available to those with MCDA certification, especially in conjunction with a Bachelor's degree in computer science or a related subject. These can include database administrators, database analysts and database developers, and each depends on the skill set of the individual. Here is a brief description of the role as a database developer, a position you may be qualified for when you have gained your MCDA.

As a database developer, you will understand both the administration side of databases (such as how database administrators manage systems and software to build and maintain computer databases) and the principles of software engineering, design and development. For this, you need to be familiar with the database structure, which is where your MCDA training will come in handy.

You will need to understand the software behind Microsoft database, network and server applications, and use your knowledge to develop new solutions and ideas. This could include:

  • Writing original code to solve new problems, or designing new methods of implementing code
  • Editing or “bug fixing” existing code, usually in order to erase problems or update the software for new uses (such as producing new versions of a product)
  • Maintenance and updating of existing applications
  • Testing, updating or implementing security measures

As a database developer, you must have a keen eye for detail, plus excellent written and oral communication skills. You will need to be able to discuss your work both on a technical level with colleagues, and in lay terms with users or clients who may not have as much technical know-how as you. As a database developer, you will be on the lookout for new ways to improve existing systems, making businesses run smoother and ensuring your company's server and network needs are met.

Before you sign up to take the MCDA, you should:

  • Have a good knowledge of Microsoft systems, especially network and server software such as SQL 2000
  • Have some experience using networking and server software. Preferably this will at least include Microsoft products, however this may not be essential. Please refer to Microsoft's website for more details on prerequisites for course applications.
  • Have excellent written and oral communication skills, and be comfortable talking both on a technical level and in lay terms about your work
  • Have great attention-to-detail and a problem-solving, analytical mind. You must be able to come up with efficient solutions to both common and complex problems in the role you will likely undertake upon completion of the MCDA qualification, so this is especially important.
  • Preferably have a degree in a related field (such as computer science or information systems)