Search For a COURSE
  Submit

Learning Plan for the Database Administrator Job Role for SQL Server 2005

SQL 2005
Comprehensive Learning Plan

Primary Focus: SQL 2005



This learning plan will help you train to become a Database Administrator for Microsoft SQL Server 2005, and earn the Microsoft Certified Database Administrator 2005 certification.

The Database Administrator 2005 credential validates your expertise and ability to design, implement, and maintain SQL Server 2005 database solutions.

Estimated Time to Complete This Learning Plan: 20 days

Recommended Learning Resources:
Step 1

Course 2780B: Maintaining a Microsoft SQL Server 2005 Database



This five-day instructor-led course provides the knowledge and skills to maintain a SQL Server 2005 database. The course focuses on how to use SQL Server 2005 product features and tools to maintain a database.
Step 2

Course 2779B: Implementing a Microsoft SQL Server2005 Database



This five-day instructor-led course teaches students how to:
  • Create databases, database files, data types, and tables
  • Use XML-related features in Microsoft SQL Server 2005
  • Plan, create, and optimize indexes
  • Implement data integrity, views, procedures, and functions
  • Implement managed code in the database
  • Manage transactions and locks
  • Use Service Broker to build a messaging-based solution
Step 3

Preparation Guide for Exam 70-431



Review this preparation guide to ensure that you are familiar with the topics covered in the exam.
Step 4

Register and schedule for your exam



Register now for a 15% off voucher for exam 70-431, the first exam required for the Database Administrator credential.
Step 5

Course 2786B: Designing a Microsoft SQL Server 2005 Infrastructure



This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.
Step 6

Course 2787A: Designing Security for Microsoft SQL Server 2005



This two-day instructor-led course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005.
Step 7

Course 2788A: Designing High Availability Database Solutions Using Microsoft SQL Server 2005



This three-day instructor-led course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during design. Students will also learn how to document and test the high availability database solution.
Step 8

Preparation Guide for Exam 70-443



Review this preparation guide to ensure that you are familiar with the topics covered in the exam.
Step 9

Register and schedule for your exam



Register now for a 25% off voucher for exam 70-443, the second exam required for the Database Administrator credential.
Step 10

Course 2789B: Administering and Automating Microsoft SQL Server 2005 Databases and Servers



This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers.
Step 11

Course 2790A: Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005



The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005.
Step 12

Register and schedule for your exam



Register now for a 25% off voucher for exam 70-444, the final exam required for the Database Administrator credential.