QA Accelerated – MCTS: SQL Server 2008, Implementation and Maintenance

call us now - 0845 757 3888
  • view dates / book course
  • course description
  • skills paths
  • blogs

Print course outline | Download Word document | Link to page: http://www.qa.com/QAMCTSSQIM

Course dates

Currently scheduled dates for this training course
LocationMayJunJulAugview later dates
LocationSepOctNovDecview earlier dates
London
  1. Currently scheduled dates for this training course
    King William Street, EC4|28|-|-|20show prices/book
    LocationSepOctNovDecview earlier dates
    King William Street, EC4|-|-|-|-show prices/book
  2. King William Street, EC4location information and directions

    hide-prices
    28 May limited availability £2,200 exc VATrequest availability
    20 Aug 5 or more places available £2,200 exc VAT

    orenquire about this course

    QA Accelerated - MCTS: SQL Server 2008, Implementation and Maintenance training in King William Street, EC4
  1. Currently scheduled dates for this training course
    Middlesex Street, E1|-|-|-|-show prices/book
    LocationSepOctNovDecview earlier dates
    Middlesex Street, E1|-|29|-|3show prices/book
  2. Middlesex Street, E1location information and directions

    hide-prices
    29 Oct 5 or more places available £2,200 exc VAT

    orenquire about this course

    03 Dec 5 or more places available £2,200 exc VAT

    orenquire about this course

    QA Accelerated - MCTS: SQL Server 2008, Implementation and Maintenance training in Middlesex Street, E1

Print course outline | Download Word document | Link to page: http://www.qa.com/QAMCTSSQIM

Special Notices

Do you qualify for free Microsoft training, through the Microsoft Software Assurance scheme?  If so you could claim towards your QA Accelerated course.

  • Use 5 SA vouchers and pay a balance of only £766

Overview

Focus on earning an MCTS SQL Server 2008 Implementation and Maintenance certification on our intensive ACCELERATED track. Demonstrate your skill in working with SQL Server 2008.

The QA Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Including:

  • Course based on Microsoft Official Curriculum
  • All events delivered by QA’s expert MCT team
  • Extended delivery days – normally 8:30am – 6:00pm
  • Practice tests taken with full support from your instructor
  • Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance exam taken on the final day of your course
  • Free exam re-test voucher should you fail your first attempt

Prerequisites

This course is intended for IT Professionals who implement, administer and maintain SQL Server databases

  • Working knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Some experience with database design

Course Outline

  • Installing and Configuring SQL Server
  • Managing Databases and Files
  • Disaster Recovery
  • Managing Security
  • Transferring Data
  • Automating Administrative Tasks
  • Implementing Replication
  • Maintaining High Availability
  • Monitoring SQL Server
  • Troubleshooting and Performance Tuning
  • Creating Databases, Database Files, Data Types and Tables
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML
  • Implementing Views, Stored Procedures and Functions
  • Implementing Managed Code in the Database
  • Managing Transactions and Locks
  • Using Service Broker

Print course outline | Download Word document | Link to page: http://www.qa.com/QAMCTSSQIM

Related certification and/or skills paths

This course forms part of the following certification track(s) or skills path(s):

Need help planning your training?

The easiest way to get help planning your training is to call one of our specialists on 0845 757 3888 or to email us info@qa.com. We'll be happy to help.

Print course outline | Download Word document | Link to page: http://www.qa.com/QAMCTSSQIM

Related blogs

vSphere 5 CLI reference poster

Posted by Bryan O'Connor on 24 May 2012

The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision

Connection Options for the vMA (VMware Management Assistant)

Posted by Bryan O'Connor on 23 May 2012

This article covers the various conn-options for the vMA

Let’s have a Fling

Posted by Bryan O'Connor on 22 May 2012

Not the type you thought, but an offering from VMware

Windows 7 Native Boot Adding the VHD to Bare Metal

Posted by Andrew Mallett on 21 May 2012

I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....

Microsoft Virtual Academy

Posted by Bryan O'Connor on 21 May 2012

Been on a Microsoft Offical Course and fancy some complentary information, have a look at Microsoft Virtual Academy.

See all related blogs

 
top of page
  • Apple logo
  • AppSense logo
  • cisco logo
  • citrix logo
  • compTIA logo
  • ec council logo
  • IBM logo
  • lpi logo
  • microsoft gold logo
  • novell logo
  • oracle logo
  • redhat logo
  • SAP logo
  • symantec logo
  • vmware logo
  • cisco logo
  • IBM logo