Tel: UK 0845 757 3888 | Ireland: 01 284 6796
QA Accelerated – MCTS: SQL Server 2008, Business Intelligence
Course type Fast-track (What does this mean?)
| Course title | QA Accelerated - MCTS: SQL Server 2008, Business Intelligence |
|---|---|
| Delivery method |  Classroom |
| RRP | £2200 exc. VAT |
| Days/Duration | 5 |
| Code | QAMCTSQ08BI |
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
Middlesex Street, E1 |- |- |2 |- 
Location Sep Oct Nov Dec view earlier dates Middlesex Street, E1 |17 |- |- |- Middlesex Street, E1location information and directions
02 Jul fewer than 5 places available £2,200 exc VAT 17 Sep fewer than 5 places available £2,200 exc VAT QA Accelerated - MCTS: SQL Server 2008, Business Intelligence training in Middlesex Street, E1
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 Business Intelligence 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-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance 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 individuals who design and maintain business intelligence solutions for their organization. They should have experience in:-
- Conceptual understanding of OLAP solutions.
- Experience navigating the Microsoft Windows Server environment.
- Experience with Windows services (starting and stopping).
- Experience creating service accounts and permissions.
- Experience with Microsoft SQL Server, including: SQL Server Agent, SQL Server query language (SELECT, UPDATE, INSERT, and DELETE), SQL Server System tables and SQL Server accounts (users and permissions).
Course Outline
- Microsoft SQL Server Analysis Services
- Creating Multidimensional Analysis Solutions
- Working with Cubes and Dimensions
- Working with Measures and Measure Groups
- Querying Multidimensional Analysis Solutions
- Customizing Cube Functionality
- Maintaining a Multidimensional Solution
- Introduction to Data Mining
- Introduction to SQL Server 2008 Integration Services
- Developing Integration Services Solutions
- Implementing Control Flow
- Implementing Data Flow
- Implementing Logging
- Debugging and Error Handling
- Implementing Checkpoints and Transactions
- Configuring and Deploying Packages
- Managing and Securing Packages
- Introduction to Microsoft SQL Server Reporting Services
- Authoring Basic Reports
- Enhancing Basic Reports
- Manipulating Data Sets
- Using Report Models
- Publishing and Executing Reports
- Using Subscriptions to Distribute Reports
- Administering Reporting Services
- Programming Reporting Services
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.
