Skip to content

Microsoft Database Certifications

August 5, 2009

DATABASE
SQL Server Specialisations

Technology Specialist: SQL Server 2005

They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface.
￯﾿ツ￯ᄒᄋ         Exam 70-431: TS: Microsoft SQL Server 2005 – Implementation and Maintenance

Technology Specialist: SQL Server 2005 Business Intelligence
They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite. They have knowledge of database schemas and of debugging, monitoring, and troubleshooting Business Intelligence solutions, and they know how to work with Microsoft .NET Framework. They can write database queries, use SQL Server Analysis Services (SSAS) data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages.

￯﾿ツ￯ᄒᄋ        Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance

IT Professional: Database Developer
Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data using SQL queries or tune and optimize queries.

MCTS: Microsoft SQL Server 2005 – Implementation and Maintenance
Exam 70￯﾿ᄁ￯ᄒタ￯ᄒモ441: PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 Open License 6.0
Exam 70￯﾿ᄁ￯ᄒタ￯ᄒモ442: PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

IT Professional: Database Administrator
Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-size to large organizations.

MCTS: Microsoft SQL Server 2005 – Implementation and Maintenance
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
Previous Generation Certification Programs

Microsoft Certified Database Administrator (MCDBA)

The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server. This certification requires passing three core exams, and one elective exam.

IT Professional (MCITS) Upgrades

MCDBA to MCITP: Database Administrator
This certification requires that one pass the following examination:

MCTS: .NET Framework 2.0 Windows Applications
Exam 70￯﾿ᄁ￯ᄒタ￯ᄒモ447: UPGRADE: MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: