Code: 
6231+2778
Duration: 
5 Day(s)
Price: 
£2500

Overview

Focus on earning an MCTS SQL Server 2008 Implementation and Maintenance certification on our intensive accelerated MCTS track

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

  • Course based on Microsoft Official Curriculum
  • 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

Audience

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

Prerequisites

  • 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 Specifics

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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
Onsite
5 2500 £2500 2018-07-16
Liverpool
5 2500 £2500 2017-11-06
Manchester
5 2500 £2500 2017-10-23
Cardiff
5 2500 £2500 2017-10-02
Reading
5 2500 £2500 2017-09-18
Birmingham
5 2500 £2500 2017-09-11
Belfast
5 2500 £2500 2017-09-06