Microsoft Certified IT Professional (MCITP) Database Administrator

The MCITP Database Administrator certification is designed for individuals who create 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 optimise databases, and install and configure SQL Server.

With the MCITP Database Administrator Package, you will learn:

Exam: 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2008

Analysing Capacity Needs for Microsoft SQL Server 2008 Designing a Data Archiving Strategy for Microsoft SQL Server 2008 Designing a Database Server Consolidation Strategy for Microsoft SQL Server 2008 Designing a Data Distribution Strategy for Microsoft SQL Server 2008 Designing a Microsoft SQL Server 2008 Database Server Infrastructure Designing a Data Recovery Strategy for Microsoft SQL Server 2008 Establishing Database Conventions and Standards for Microsoft SQL Server 2008 Introduction to Designing SQL Server Security for Microsoft SQL Server 2008 Designing a SQL Server 2008 Security Policy to Integrate with Systems Infrastructure Designing Security Policies for Microsoft SQL Server 2008 Instances and Databases Integrating Data Encryption into a Microsoft SQL Server 2008 Database Security Design Designing a Microsoft® SQL Server 2008 Security Exceptions Policy Designing a Response Strategy for Threats and Attacks Against Microsoft SQL Server 2008 Selecting the Appropriate High-Availability Technology Using Microsoft SQL Server 2008 Designing a Clustering Solution Using Microsoft SQL Server 2008 Designing a Log Shipping Solution Using Microsoft SQL Server 2008 Designing a Database Mirroring Solution Using Microsoft SQL Server 2008 Designing Replication Solutions for High Availability Using Microsoft SQL Server 2008 Combining High-Availability Technologies Using Microsoft SQL Server 2008 Documenting and Testing a High-Availability Strategy Using Microsoft SQL Server 2008

Exam: 70-444: PRO: Optimising and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2008

Introduction to Designing SQL Server Security for Microsoft SQL Server 2008 Designing a SQL Server 2008 Security Policy to Integrate with Systems Infrastructure Designing Security Policies for Microsoft SQL Server 2008 Instances and Databases Integrating Data Encryption into a Microsoft SQL Server 2008 Database Security Design Designing a Microsoft SQL Server 2008 Security Exceptions Policy Designing a Response Strategy for Threats and Attacks Against Microsoft SQL Server 2008 Managing and Automating Microsoft SQL Server 2008 Databases and Servers Managing Microsoft SQL Server 2008 Supporting Services Building a Monitoring Solution for Microsoft SQL Server 2008 Performance Issues Troubleshooting Microsoft SQL Server 2008 Database and Database Server Performance Issues Optimizing the Microsoft SQL Server 2008 Query Performance Environment Troubleshooting Microsoft SQL Server 2008 Connectivity Issues Troubleshooting Microsoft SQL Server 2008 Data Issues Troubleshooting Microsoft SQL Server 2008 Concurrency Issues

Exam: 70-431: TS: Microsoft SQL Server 2008 - Implementation and Maintenance

Getting Started with Databases and Transact-SQL in Microsoft SQL Server 2008 Performing Basic Queries in Microsoft SQL Server 2008 Grouping and Summarizing Data in Microsoft SQL Server 2008 Joining Data from Multiple Tables in Microsoft SQL Server 2008 Working with Subqueries in Microsoft SQL Server 2008 Modifying Data in Microsoft SQL Server 2008 Querying Metadata, XML, and Full-Text Indexes in Microsoft SQL Server 2008 Using Programming Objects for Data Retrieval in Microsoft SQL Server 2008 Using Advanced Querying Techniques in Microsoft SQL Server 2008