Banner

Microsoft Certified IT Professional (MCITP): Database Administrator

Select Industry/Course:

Course Schedule & Online Registration

If you are an individual, please click here.
If you are representing a company, please click here

Target Audience

IT professionals who want to pursue careers as database administrators, database developers, or business intelligence developers.

Course Overview

MCITP certifications build on the technical proficiency measured in the Microsoft Certified Technology Specialist (MCTS) certifications. You will be able to earn one or more MCTS certifications on your way to earning an MCITP credential.

Course Duration

140 hours / 20 days

Assessment

Trainess are required to sit for 1 MCTS exam and 2 Professional Series Exams

Core exams
(3 required)		 Classroom Training

Exam 70-431:

Microsoft SQL Server 2005 - Implementation and Maintenance

Course 2779:

Implementing a Microsoft SQL Server 2005 Database
(5 Days)

and

Course 2780:

Maintaining a Microsoft SQL Server 2005 Database
(5 Days)

Exam 70-443:

Designing a Database Server Infrastructure by using Microsoft SQL Server 2005

Course 2786:

Designing a Microsoft SQL Server 2005 Infrastructure
(2 Days)

and

Course 2787

Designing Security for Microsoft SQL server 2005
(2 Days)

and

Course 2788

Designing High Availability Database Solutions using Microsoft SQL Server 2005
(3 Days)

Exam 70-444:

Optimizing and Maintaining a Database Administration Solution by using Microsoft SQL Server 2005

Course 2787:

Designing Security for Microsoft SQL Server 2005
(2 days)

and

Course 2789

Administering and Automating Microsoft SQL Server 2005 Databases and Servers
(1 Day)

and

Course 2790

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
(2 Days)


Course Outline

Implementing a Microsoft SQL Server 2005 Database
Course Code: 2779
Course Duration: 35 hours / 5 days
Exam code: 70 – 431

    Creating Databases and Database Files
  • Creating Databases
  • Creating Filegroups
  • Creating Schemas
  • Creating Database Snapshots

    Creating Data Types and Tables
  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables

    Using XML
  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Introducing XQuery
  • Using the xml Data Type

    Creating and Tuning Indexes
  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes
  • Creating XML Indexes

    Implementing Data Integrity by Using Constraints
  • Data Integrity Overview
  • Implementing Constraints

    Implementing Data Integrity by Using Triggers and XML Schemas
  • Implementing Triggers
  • Implementing XML Schemas

    Implementing Views
  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views

    Implementing Stored Procedures
  • Implementing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Working With Execution Plans
  • Handling Errors

    Implementing Functions
  • Creating and Using Functions
  • Working with Functions
  • Controlling Execution Context

    Implementing Managed Code in the Database
  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects

    Managing Transactions and Locks
  • Overview of Transactions and Locks
  • Managing Transactions
  • Understanding SQL Server Locking Architecture
  • Managing Locks

    Using Service Broker
  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages

    Using Notification Services (Optional)
  • Introduction to Notification Services
  • Developing Notification Services Solutions


Maintaining a Microsoft SQL Server 2005 Database
Course Code: 2780
Course Duration: 35 hours / 5 days
Exam code: 70 – 431
    Installing and Configuring SQL Server 2005
  • Preparing to Install SQL Server
  • Installing SQL Server 2005
  • Managing a SQL Server 2005 Installation

    Managing Databases and Files
  • Planning Databases
  • Creating Databases
  • Managing Databases

    Disaster Recovery
  • Planning a Backup Strategy
  • Backing Up User Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Database and Disaster Recovery

    Managing Security
  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Managing Keys and Certificates in SQL Server

    Monitoring SQL Server
  • Viewing Current Activity
  • Using System Monitor
  • Using SQL Server Profiler
  • Using DDL Triggers
  • Using Event Notifications

    Transferring Data
  • Overview of Data Transfer
  • Introduction to SQL Server Integration Services
  • Using SQL Server Integration Services
  • Features of SQL Server Integration Services

    Automating Administrative Tasks
  • Automating Administrative Tasks in SQL Server 2005
  • Configuring the SQL Server Agent
  • Creating Jobs and Operators
  • Creating Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security

    Implementing Replication
  • Overview of Replication
  • Implementing Replication
  • Configuring Replication in Some Common Scenarios

    Maintaining High Availability
  • Introduction to High Availability
  • Implementing Server Clustering
  • Implementing Database Mirroring
  • Implementing Log Shipping
  • Implementing Peer-to-Peer Replication

Designing a Microsoft SQL Server 2005 Infrastructure
Course Code: 2786
Course Duration: 14 hours / 2 days
Exam code: 70 – 443
    Analyzing Capacity Needs
  • Estimating Storage Requirements
  • Estimating CPU Requirements
  • Estimating Memory Requirements
  • Estimating Network Requirements

    Designing a Strategy for Data Archiving
  • Identifying Requirements that Affect Data Archiving
  • Determining the Structure of Archival Data
  • Creating a Data Archival Plan

    Designing a Strategy for Database Server Consolidation
  • Overview of Database Server Consolidation
  • Designing a Strategy for SQL Server Instances
  • Designing a Database Server Consolidation Plan

    Designing a Strategy for Data Distribution
  • Overview of Data Distribution
  • Creating a Data Distribution Plan Using Replication

    Designing a Database Server Infrastructure
  • Evaluating the Current Database Server Infrastructure
  • Gathering Requirements for Changing a Database Server Infrastructure
  • Designing Modifications to a Database Server Infrastructure

    Designing a Strategy for Data Recovery
  • Creating a Backup and Restore Strategy
  • Creating a Database Disaster Recovery Plan

    Establishing Database Conventions and Standards
  • Establishing Database Naming Conventions
  • Defining Database Standards

Designing Security for Microsoft SQL Server 2005
Course Code: 2787
Course Duration: 14 hours / 2 days
Exam code: 70 – 443
    Introduction to Designing SQL Server Security
  • Principles of Database Security
  • Methodology for Designing a SQL Server Security Policy
  • Monitoring SQL Server Security

    Designing a SQL Server Systems Infrastructure Security Policy
  • Integrating with Enterprise Authentication Systems
  • Developing Windows Server-Level Security Policies
  • Developing a Secure Communication Policy
  • Defining SQL Server Security Monitoring Standards

    Designing Security Policies for Instances and Databases
  • Designing an Instance-Level Security Policy
  • Designing a Database-Level Security Policy
  • Designing an Object-Level Security Policy
  • Defining Security Monitoring Standards for Instances and Databases

    Integrating Data Encryption into a Database Security Design
  • Securing Data by Using Encryption and Certificates
  • Designing Data Encryption Policies
  • Determining a Key Storage Method

    Designing a Security Exceptions Policy
  • Analyzing Business and Regulatory Requirements
  • Determining the Exceptions and their Impact

    Designing a Response Strategy for Threats and Attacks
  • Designing a Response Policy for Virus and Worm Attacks
  • Designing a Response Policy for Denial-of-Service Attacks
  • Designing a Response Policy for Internal and SQL Injection Attacks

Designing High Availability Database Solutions Using Microsoft SQL Server 2005
Course Code: 2788
Course Duration: 21 hours / 3 days
Exam code: 70 – 443
    Selecting the Appropriate High-availability Solution
  • Identifying High-availability Requirements and Constraints
  • Analyzing High-availability Requirements and Constraints
  • Determining Appropriate High-availability Solutions

    Designing a Clustering Solution
  • Designing the Platform for Clustering
  • Designing the SQL Server Cluster Implementation
  • Designing Recovery Strategies and Test Plans for Database Clustering
  • Migrating and Upgrading SQL Server Clusters
  • Designing an Operations Plan for Clustering

    Designing a Highly Available Database Storage Solution
  • Determining Storage Requirements for SQL Server Databases
  • Determining Storage Requirements for SQL Server Components and Files
  • Designing Storage Solutions for SQL Server Databases
  • Designing a Backup and Restore Strategy

    Designing a Log Shipping Solution
  • Introduction to Designing a Log Shipping Solution
  • Designing Log Shipping Server Roles and Topology
  • Designing a Log Shipping Upgrade Strategy
  • Designing an Operations Plan for Log Shipping

    Designing a Database Mirroring Solution
  • Introduction to Designing a Database Mirroring Solution
  • Designing Database Roles and Topology for Database Mirroring
  • Converting High-availability Solutions to Database Mirroring
  • Designing an Operations Plan for Database Mirroring

    Designing a Highly Available Solution Based on Replication
  • Introduction to Designing a Replication Solution
  • Designing a Replication Solution
  • Designing a Replication Upgrade Strategy
  • Designing an Operations Plan for Replication

    Combining High-availability Technologies
  • Evaluating Weaknesses in Each High-availability Technology
  • Maximizing Availability by Combining High-availability Technologies

    Documenting and Testing a High-availability Strategy
  • Documenting High-availability Solutions
  • Creating a Test Plan for High-availability Solutions

Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Course Code: 2789
Course Duration: 7 hours / 1 days
Exam code: 70 – 444
    Managing and Automating Databases and Servers
  • Planning an Automated System for Database Maintenance
  • Planning an Automated System Server Maintenance.
  • Documenting Administration and Automation Information.

    Managing SQL Server Supporting Services
  • Managing SSIS Packages.
  • Managing Replication.
  • Managing Reporting Services

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Course Code: 2790
Course Duration: 14 hours / 2 days
Exam code: 70 – 444

    Building a Monitoring Solution for SQL Server Performance Issues
  • Narrowing Down a Performance Issue to an Environment Area
  • Guidelines for Monitoring Database Servers and Instances by Using Profiler and Sysmon
  • Guidelines for Auditing and Comparing Test Results

    Troubleshooting Database and Database Server Performance Issues
  • Narrowing Down a Performance Issue to a Database Object
  • How Profiler Can Help Narrow a Search to a Specific Issue
  • How the SQLdiag Tool Can Be Used to Analyze Outputs

    Optimizing the Query Performance Environment
  • The Methodology of Optimizing a Query Environment
  • The Query Performance Troubleshooting Process

    Troubleshooting SQL Server Connectivity Issues
  • The Methodology of Troubleshooting SQL Server Connectivity Issues
  • Areas to Troubleshoot for Common Connectivity Issues.
  • What Are SQL Server 2005 Endpoints?

    Troubleshooting SQL Server Data Issues
  • The Methodology of Troubleshooting SQL Server Data Issues
  • The Process of Troubleshooting Data Integrity Issues
  • How Torn Pages Can be Resolved Using a Single-Page Restore

    Troubleshooting SQL Server Data Concurrency Issues
  • The Methodology of Troubleshooting Concurrency Issues
  • What Are SQL Server Latches?
  • Activity: Choosing a Blocking Monitoring Solution

Pre-requisites

Trainees for this course should have prior programming knowledge. Knowledge for the following areas is recommended:

  • Tools usage
  • UI navigation
  • Wizards usage
  • Writing code in the appropriate language (Transact-SQL, CLR language, and other scripting languages)
  • Code debugging or syntactic issue resolution
  • Troubleshooting
  • Accomplishing specific focused tasks by using code or UI navigation

    • Course Location

    NTUC Trade Union House
    73 Bras Basah Road
    #02-01
    Singapore 189556

    Methodology

    Instructor - Led

    Certification

    Microsoft Certified IT Professional (MCITP): Database Administrator

    Funding Info

    Please click here for more information

    Enquiry

    Enter characters displayed

    * Mandatory fields

    Our Partners