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:
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:
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: