Microsoft Certified IT Professional - Database Administrator

UK Learning College
5.0
1 review
  • It was an enjoyable and informative course. Marking and feedback was prompt which was a major plus. I work in project management and the course was particularly useful in highlighting some activities that I undertake putting them more into context and giving me a better understanding how they fitted into the overall process. For the future I think projects I am involved with will benefit from improved structure of project planning.
    ← | →

Course

In

Price on request

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Start date

    Different dates available

Course OverviewA distance learning course is the ideal way to gain a qualification in Microsoft Certified IT Professional (MCITP) - Database Administrator. Whether you're looking to go on to further education, improve your job prospects or expand your knowledge, distance learning Microsoft Certified IT Professional (MCITP) - Database Administrator is a flexible and convenient course, which allows you to comprehensively prepare for an exam or career through home study. What's more, because the distance learning Microsoft Certified IT Professional (MCITP) - Database Administrator course is a fully comprehensive course, no prior knowledge is required.Microsoft Certified IT Professional - Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.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. 

Facilities

Location

Start date

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • It was an enjoyable and informative course. Marking and feedback was prompt which was a major plus. I work in project management and the course was particularly useful in highlighting some activities that I undertake putting them more into context and giving me a better understanding how they fitted into the overall process. For the future I think projects I am involved with will benefit from improved structure of project planning.
    ← | →
100%
4.6
excellent

Course rating

Recommended

Centre rating

David Burdekin

5.0
30/09/2014
What I would highlight: It was an enjoyable and informative course. Marking and feedback was prompt which was a major plus. I work in project management and the course was particularly useful in highlighting some activities that I undertake putting them more into context and giving me a better understanding how they fitted into the overall process. For the future I think projects I am involved with will benefit from improved structure of project planning.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 11 years

Subjects

  • Server
  • SQL
  • Security
  • IT Security
  • Database training
  • Database
  • IT
  • SQL Server
  • Database Administration

Teachers and trainers (1)

Support Advisor

Support Advisor

Support Advisor

Course programme

Training Course Content

Course Structure

MCITP Database Administrator SQL Server 2008 Certification Training:

SQL Server 2008 - Implementation and Maintenance (70-432) Training Course Curriculum:

Module 1 - Installing SQL Server

  • Services and Installation Process
  • Installing SQL Server
  • Module Review

Module 2 - Configuring SQL Instances

  • Common Server Options
  • Database Mail
  • Module Review

Module 3 - Managing Databases

  • Recovery Models
  • Partitions
  • Encryption and Compression
  • Module Review

Module 4 - Disaster Recovery

  • Backups and Restores
  • Database Snapshots
  • Module Review

Module 5 - Security

  • Authorization
  • Policies
  • Database and Server Level Triggers
  • SQL Server Auditing
  • Module Review

Module 6 - Indexes

  • Specialized Indexes
  • Module Review
  • Concurrency
  • Monitoring Locks
  • Module Review

Module 7 - Optimizing Performance

  • SQL Server Profiler
  • Data Collector
  • Resource Governor
  • Module Review
  • Maintaining a SQL Server Database
  • Automating SQL Tasks
  • Maintenance Plans
  • Importing/Exporting Data
  • Module Review

Module 8 - High Availability

  • Database Mirroring
  • Log Shipping
  • Replication
  • Module Review

Course Review and Exam Tips

70-432 Demo Scripts

SQL Server 2008 - Designing, Optimizing and Maintaining a Database Administrative Solution (70-450) Training Course Curriculum:

Module 1 - Configuring SQL Server

  • Module Overview
  • Hardware Configuration
  • Windows Configuration
  • Instance Configuration
  • Database Configuration
  • Maintaining SQL Server
  • Upgrading
  • Module Review

Module 2 - Designing Secure SQL Server Solutions

  • Module Overview
  • Authentication
  • Authorization
  • Encryption
  • Policies
  • SQL Server Auditing
  • Module Review

Module 3 - Designing Highly Available SQL Server Solutions

  • Module Overview
  • Failover Clustering
  • Database Mirroring
  • Log Shipping
  • Combining Solutions
  • Module Review

Module 4 - Designing Disaster Recovery Solutions

  • Module Overview
  • Backup Strategies
  • Recovery Strategies
  • Piecemeal Backup and Restore
  • Recovering Pages
  • Media Failure
  • Database Snapshots
  • Module Review

Module 5 - Designing Data Distribution

  • Module Overview
  • SQL Server Integration Services
  • Replication
  • Module Review

Module 6 - Monitoring SQL Server

  • Module Overview
  • Windows Resources
  • SQL Resources
  • Resource Governor
  • Module Review
  • Course Review
  • Exam Tips

The UK Learning College is a leading Distance Learning Provider, offering a route to study for anyone who wants to gain a new skill or qualification, but finds the traditional, classroom-based mode of study unsuitable. Distance learning is an ideal way to learn around your current time and financial commitments, no matter how diverse and unpredictable your schedule is. With UK Learning College you not only study when it suits you and in your own time, but you can be sure of receiving all the advice and support you require as your studies develop. Because of our continuous system of enrolments, Students can enrol any time of year, and our flexible distance learning courses allow students to plan their studies to fit in their life style or work commitments. All of our students have access to their own personal distance learning course tutor who specialises in their field of education and is totally committed to helping you succeed in your home learning course.

Additional information

Expenses

Enrolment Fees

Our aim is to provide you with the best deal available, therefore the registration fee, certification fee and full tutor support is included in the course price for you. The enrolment fee for the Microsoft Certified IT Professional (MCITP) - Database Administrator home study course is £868.75,...

See related categories

Microsoft Certified IT Professional - Database Administrator

Price on request

The best SQL Server courses

See all

See all