QA Accelerated – MCTS: SQL Server 2008, Database Development

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/QAMCTSSQDD

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|-|-|9|-show prices/book
    LocationSepOctNovDecview earlier dates
    King William Street, EC4|17|-|-|-show prices/book
  2. King William Street, EC4location information and directions

    hide-prices
    09 Jul 5 or more places available £2,200 exc VAT

    orenquire about this course

    17 Sep 5 or more places available £2,200 exc VAT

    orenquire about this course

    QA Accelerated - MCTS: SQL Server 2008, Database Development training in King William Street, EC4

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

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 Database development 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:30pm
  • Practice tests taken with full support from your instructor
  • Exam 70-433 TS: Microsoft SQL Server 2008, Database Development taken on the last day of the course
  • Free exam re-test voucher should you fail your first attempt

Prerequisites

This course is intended for IT Professionals who administer and maintain SQL Server databases.  They should have experience in:-

  • Knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page , create a folder); Login (CTRL ALT DELETE); Start a service using services add-in. (administration tools); Use a mouse, start menu etc.)
  • 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 and Database Files
  • Creating Data Types and Tables
  • Creating and Tuning Indexes.
  • Implementing Data Integrity by Using Constraints and Triggers
  • Using XML 
  • Implementing Views.
  • Implementing Stored Procedures
  • Implementing 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/QAMCTSSQDD

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/QAMCTSSQDD

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
  • Apple logo
  • novell logo
  • compTIA logo