Microsoft Certified IT Professional MCITP Database Administrator

Course Code: BA211

The Microsoft brand is well respected and will stand out on your C.V. It starts at a level that allows you to grasp concepts quickly and easily and build on this knowledge to give you a full understanding of Database Administration.

This course teaches students how to use the tools, SQL language and exploring the user interface.

Course Content

Creating Databases & Database Files

Creating databases
Creating filegroups
Creating database snapshots

Creating Data Types & Tables

Creating data types
Creating tables
Creating partitioned tables

Using XML

Retrieving XML using FOR XML
Shredding XML by using OPEN XML
Using the XML data type

Creating and Tuning Indexes

Planning indexes
Creating & optimising indexes
Creating XML indexes

Implementing Data Integrity

Data integrity overview
Implementing contraints
Implementing triggers
Implementing XML schemas

Implementing Views

Introduction to views
Creating and managing views
Optimising performance by using views

Implementing Stored Procedures & Functions

Implementing stored procedures
Creating parameterised stored procedures
Creating functions
Handling errors
Controlling execution context

Implementing Managed Code in the Database

Introduction to the SQL server common language runtime
Importing & configuring assemblies
Creating managed database objects

Using Server Broker

Service broker overview
Creating service broker objects
Sending and receiving messages
Maintaing a Microsoft SQL server 2005 database

Installing & Configuring SQL Server 2005

Preparing to instal SQL server
Installing SQL server
Managing an SQL server installatio

Managing Database & Files

Planning & creating databases
Managing databases

Disaster Recovery

Planning a back-up strategy
Backing up user databases
Restoring user databases
Recovering data
System database

Managing Security

Overview of SQL server security
Securing the server scope
Securing the database scope
Managing keys and certificates in SQL server

Monitoring SQL Server

Viewing current activity
Using system monitors
Using SQL server profiler
Using DDL triggers
Using event notifications

Transferring Data

Overview of data transfer
Introduction to the SQL server integration services
Using the SQL intergration service

Automating Administrative Tasks in SQL Server 2005

Configuring the SQL server agent
Creating jobs and operations
Creating alerts
Managing multiple servers
Managing security

Maintaining High Availability

Introduction to high availability
Implementing server clustering
Implementing database mirroring
Implmenting log shipping

Introduction to Replication

Overview of replication
Replication scenarios

Assessment

The MCITP Database Administrator course requires students to pass 3 examinations taken at a local test centre to you. It is the students responsibility to book and pay for exams, these are around £85.00, however it is advised that you do check this with your chosen test centre. These exams can be sat at Prometric test centres.

Exams 70-431, 70-443, 70-444

Study Method

The course is designed for study by distance learning at home or at work. Students receive a course manual, assignments and study guide plus tutor support by mail or email. You can start at any time and plan your studies over a period of up to one year from the time of registration.

Qualifications

A successful completion of your examinations and assessments you will receive the MCITP Database Administrator certificate; a leading industry recognised awarding body.

You can read more about Microsoft and our awarding bodies here: Awards.

Course Questions & Answers

Q: What skills are needed to enrol onto this course?

Students will ideally have at least 12 months of experience of database work, although this is not essential. Students should also have knowledge of Microsoft SQL Server 2005.

Q: Is there a time limit for completion of this course?

You will spend around 120 hours studying on this course in your own time at home. Students are provided with a full 12 months to complete the course.

Q: What is included in the cost of my course?

You will receive your official course CD-ROM's
Unlimited tutor support via email

Q: Do I have to sit an exam?

Yes, to gain full MCITP Database Administrator certification you will need to take exams in a local test centre to you. It is the students' responsibility to arrange the exams. The exams can be done at Prometric test centres. These cost around £85.00, however it is advised that you do speak to your chose exam centre about the cost of the exams.