Tel: UK 0845 757 3888 | Ireland: 01 284 6796
QA Accelerated – MCTS: SQL Server 2008, Database Development
Course type Fast-track (What does this mean?)
| Course title | QA Accelerated - MCTS: SQL Server 2008, Database Development |
|---|---|
| Delivery method |  Classroom |
| RRP | £2200 exc. VAT |
| Days/Duration | 5 |
| Code | QAMCTSSQDD |
Secure online payment
- view dates / book course
- course description
- skills paths
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
King William Street, EC4 |- |- |9 |- 
Location Sep Oct Nov Dec view earlier dates King William Street, EC4 |17 |- |- |- King William Street, EC4location information and directions
09 Jul 5 or more places available £2,200 exc VAT 17 Sep 5 or more places available £2,200 exc VAT QA Accelerated - MCTS: SQL Server 2008, Database Development training in King William Street, EC4
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
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.
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.
