- MCTS SQL Server 2008 Business Intelligence Development and Maintenance

A Firebrand Training
4
Day Course

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Overview

SQL Server 2008 Business Intelligence platform provides a scalable business intelligence (BI) platform optimised for data integration, reporting, and analysis, enabling organisations to deliver intelligence where users want it.

During this course, delegates will learn how to implement Business Intelligence solutions, using SQL Server 2008’s suite of tools, including Integration Services, Reporting Services and Analysis Services. Delegates will also learn how to implement Data Mining Solutions with Analysis Services.

This blended-learning program employs outcome-based (Lecture | Lab | Review) delivery - that focuses on preparing you with the real-world skills required to obtain your certification and to hit the ground running in your career. Our Trainers are among the most senior consultants in the industry, affording each Firebrand Training student the benefit of many years of real-world development expertise - while being able to effectively translate complex technical theory into easily understood terms.

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Benefits

Other training providers rely heavily on lecture, self-testing and self-study.

Our approach is highly varied and interactive to keep your attention, promote teamwork, and reinforce knowledge gained through hands-on learning.

You will:

Be Immersed into a distraction-free environment - escaping your normal routine and focusing purely on learning.

Experience Accelerated Learning methods – designed to help you learn much more quickly, spend less time out of the office, and see returns from your investment straight away.

Be Measured through on-site exam testing - creating a complete feedback loop that ensures you understand the subject thoroughly.

With Firebrand Training, you will learn more.

This information has been provided as a helpful tool for candidates considering certification. Benefits of certification determined through studies do not guarantee any particular personal successes. Firebrand Training provides a guarantee of obtaining certification at the camp, but does not make any guarantees about personal successes or benefits of obtaining certification.

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Curriculum

Firebrand Training provides thorough instructor-led training to ensure that you learn the fundamentals and obtain hands-on skills. You will emerge able to immediately apply your new knowledge in your career environment.

Course Content

Introduction to Microsoft SQL Server Analysis Services

  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services
  • Installing SQL Server Analysis Services

Creating Multidimensional Analysis Solutions

  • Developing Analysis Services Solutions
  • Creating Data Sources and Data Source Views
  • Creating a Cube

Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes

Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Querying Multidimensional Analysis Solutions

  • MDX Fundamentals
  • Adding Calculations to a Cube

Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Deploying and Securing an Analysis Services Database

  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database

Maintaining a Multidimensional Solution

  • Configuring Processing
  • Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis Services Database

Introduction to Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

Introduction to SQL Server 2008 Integration Services

  • Overview of SQL Server Integration Services
  • Using Integration Services Tools

Developing Integration Services Solutions

  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution

Implementing Control Flow

  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Implementing Data Flow

  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths

Implementing Logging

  • Overview of Integration Services Logging
  • Enabling and Configuring Logging

Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Implementing Checkpoints and Transactions

  • Implementing Checkpoints
  • Implementing Transactions

Configuring and Deploying Packages

  • Package Configurations
  • Deploying Packages

Managing and Securing Packages

  • Managing Packages
  • Securing Packages

Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

Authoring Basic Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data

Manipulating Data Sets

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

Using Report Models

  • Creating Report Models
  • Using Report Builder

Publishing and Executing Reports

  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

Using Subscriptions to Distribute Reports

  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions

Administering Reporting Services

  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008

Programming Reporting Services

  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code
  • Review
  • Exam 70-448

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Exam Track

Candidates for this exam 70-448 are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services.

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - What's Included

With Firebrand, you benefit from top-quality education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so you can focus solely on your studies and certification goals.

You’ll get a robust set of course materials that cater to each of our three key individual learning styles (auditory, visual, and kinaesthetic-tactile) - critical for a successful learning experience.

Our Certification Programs include*

  • Daily lectures, exercises, and review sessions
  • Intensive Hands-on Training Utilising our (Lecture | Lab | Review)TM Delivery
  • Comprehensive study materials and courseware - we adapt official curriculum to address the demands of accelerated learners
  • Self-testing software and/or mock exam papers
  • Fully instructor-led program with 24 hour lab access
  • Exam vouchers
  • On site testing
  • Accommodation, all meals, drinks and snacks
  • Our Certification Guarantee - because we're sure you'll pass first time, if don’t pass your exams, come back to the course within a year and you only pay for accommodation and exam vouchers - everything else is free

* Please note:

  • Our ISC(2) Cissp CBK Review program differs from normal course delivery. For more details, speak to us on 080 80 800 888.
  • Exam vouchers for our (ISC)2 certifications need to be purchased directly from (ISC)2
  • On site testing is not included in our Scrum, ISACA or PMI certifications

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year.  Students will only be responsible for accommodation and vendor exam fees.

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

 - MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Prerequisites

Delegates are required to meet the following prerequisites:

  • One to two years of experience working with the Microsoft .NET Framework
  • Two to three years of experience using SQL Server 2005 BI components
  • Experience using the Business Intelligence Development Studio (BIDS)
  • Experience using Microsoft SQL Server Management Studio (SSMS)
  • Knowledge of relational and multi-dimensional database schemas
  • Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
  • Experience creating and deploying a data mining model in SSAS
  • Experience writing relational and multi-dimensional database queries
  • Experience creating and deploying SQL Server Reporting Services (SSRS) reports
  • Experience authoring and deploying SQL Server Integration Services (SSIS) packages
  • Experience debugging, monitoring, and troubleshooting BI solutions

We interview all applicants for the course on their technical background, degrees and certifications held, and general suitability. If you get through this screening process, it means you stand a great chance of passing.

Firebrand Training is an immersive training environment. You must be committed to the course. The above prerequisites are guidelines, but many students with less experience have other background or traits that have enabled their success in accelerated training through Firebrand Training.

Interested? See our pricing or text 'firebrand mctsbi08' to 07786 200 690

MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Testimonials

"The Firebrand Training experience is superb if you enjoy working at a fast pace. Though the days are long they really don't seem because you are constantly using your brain and learning."
Andrew Price, Insolvency Service.

"Fantastic experience I have been wanting to achieve this MCITP Enterprise Administrator certification for a long time and it was everything I expected. Tremendously hard work but enjoyable and ultimately rewarding"
Jack Stalley, Firebrand Training.

"Excellent training and facilities. I chose my Dynamics training with Firebrand as it was recommended to me by an online recruitment agency."
L.B, Morrisons plc.

"I was very happy with the Prince 2 course at Firebrand. It went very quickly from little/no knowledge to exam passing potential. (I hope - yet to take Prince2 Practitioner exam!)"
Kevin Ball, Ministry of justice.

"This without a doubt the most efficient course I have ever attended. Especially the way high level training was coupled to my situation at home worded well."
Jens Riis, Bornholms Regionskommune.

"It was a hard but useful experience. The Microsoft Dynamics course was intense but helped me to learn lot of things regarding the product I work on."
Crisitian Garcia, Tinet Spa.

"For people already experienced in the subject Firebrand's intensive training provides a good way to rationalise and consolidate your knowlege as well as understand best practice. Good learning environment helped by knowlegable instructors provides a very positive learning experience."
D.I, Ergo Computing UK Ltd.

"My SharePoint instructor was excellent. I don't remember ever being on a course with such a knowledgeable instructor who knew the subject matter and most related areas too! But take a kettle or book into the Premier Lodge! "
Terry Goff, Self Employed.

"Helpful staff. Clean training center"
V.C, Serco.

"The instructor and CISA course themselves were very good. Thank you."
Steve Fitzpatrick, Self Employed.

"The trainer was exceptionally helpful and knowledgable. He style is/was conducive to a well rounded education; the children I joined the A+ Network+ course with were under 18 and they also felt he was excellent - which is a testament to his abilities."
Michelle Alexander, Oasis Academy Hadley.

"Overall i had a positive experience and felt I learnt a lot and appreciated efforts by all the Staff."
Ian Colcomb, Netasq.

"Good facilities & excellent trainers. Hard work but very rewarding. "
M.H, DrFoster.

"Fantastic experience, exceeded my expectations. Long days and hard work but was amazed at how much learnt in such a short time."
Shafeeq Norodien, BFI Ltd.

"I don't have much background knowledge on CEH, the trainer taught from basics. He spared extra time with me. I am really very much thankful to Firebrand and Luck."
Vamshiram Tulasi, www.informa.com.

"It was a hard but useful experience. The Microsoft Dynamics course was intense but helped me to learn lot of things regarding the product I work on."
Crisitian Garcia, Tinet Spa.

"Really enjoyed the course, it was long hours but I knew it would be a lot of work. The instructor was really good and I found it amazing how well I absorbed all the information. He came up with really good ways of remembering things. It was well worth all the effort as I'm now qualified after just 2 weeks! Id recommend the course to anyone! I chose Firebrand because I had been wanting to do the MCITP EA training for a while and had been looking at self learning. Due to a lot of travel and long hours with work I couldn't commit to this so knew that a boot camp would be much better suited. I knew somebody that had been on the MCSE 2003 course about 18 month before and he said he would recommend it. K3 have also sent a number of people on Microsoft Dynamics courses and they are on the Firebrand website so going with Firebrand made complete sense. "
Gareth Kee, None.

"The Prince2 2009 training experience was good. excellent, putting structures around what I knew all the time"
O.O, NHS.

"My first training experience for some years. I have been nurtured and very impressed by the training and facilities."
Oliver Waterhouse, sightek.

"The CCNA course is no doubt difficult to say the least, but with the instructors help Ive managed to pass the CCENT and CCNA, and I've never had any experience with Cisco equipment before! The course is thorough, well taught. Just make sure you cram in enough reading and sleep to perform at your best! 10/10 for this course!!"
Jaimin Rao, unemployed.

"The MCITP Server Administrator course does what it says on the tin......it gets you certified!!!!! but be prepared for late nites, early mornings and lots of hard work!"
Nicholas Jones, South Hook LNG.

"Due to my hectic work schedule working around the world for Honeywell I do not get the opportunity to dedicate random days over a long period for training in centres or self study. Firebrand was the only company I found who was able to supply a bootcamp environment with training and accommodation in Europe that met the training and exam criteria for the MCITP(EA). This 13 day course is not a course for the 9 to 5 worker. To pass the exam you require hard work and dedication from yourself and your instructor. Firebrand was able to supply the right facilities and people to do the job. I chose Firebrand Training because of bootcamp training and the ability to do exams directly after the course."
Kurt Forster, Honeywell.

"The accommodation was fantastic, and the educational facilities were very conducive to learning. It truly is a full-submersion course, and you cant help but leave with an abundance of information. I'm looking forward to taking the ECSA - LPT course in 5 months time. I chose Firebrand Training for my Certified Ethical Hacker course because the website was informative and EC-Council confirmed reputation of Firebrand Training."
Daniel Azgour, Opera Solutions Ltd.

"I don't have much background knowledge on CEH, the trainer taught from basics. He spared extra time with me. I am really very much thankful to Firebrand and Luck."
Vamshiram Tulasi, www.informa.com.

"My eight days at Firebrand on the Dynamics CRM course was an intensive and extreme learning experience. Long days, with huge amounts of information to cram in, but all made possible by the instructors engaging, enthusiastic and well balanced approach to training. I couldn't recommend Firebrand, and especially this course, highly enough. The accommodation was good, the food great and plentiful, the staff helpful and courteous. There was also a much needed, never ending supply, of coffee. So overall, a brilliant experience, and I leave Firebrand knowing rather more about Dynamics CRM, than I did on Saturday the 6th of February. I chose the Dynamics CRM course with Firebrand because it was recommended to me internally at Microsoft by a number of people."
Damian Conrad, Microsoft.

"Great SharePoint Professional course, great teacher!! The facilities were very good and being immersed in a subject for five days is a good way of learning it. Exams are never nice to take (unless you're an exam junky) but being immersed means the exams are very relevant and are taken when everything is fresh in your mind."
Darren Phipson, Clarita Solutions.

"Good training courses offered in a comfortable environment conducive to maximum learning with minimum fuss. I enrolled on the MCITP Enterprise Support Technician course because it was very well defined and has given me the qualifications I was after at this time with the minimum disruption to my life."
M.K, None.

"Good training courses offered in a comfortable environment conducive to maximum learning with minimum fuss. I enrolled on the MCITP Enterprise Support Technician course because it was very well defined and has given me the qualifications I was after at this time with the minimum disruption to my life."
M.K, None.

"It was good. For a person in with my personal circumstances, it is the only way I could have achieved this kind of focus on the course material. The place is well run and very accomodating. As the particular course I did was hugely intense, the tutor offered great support and had a teaching style which would have appealed to a wide audience."
Peter McCormack, Pinewood Technologies.

"The facilities and the location were excellent. All staff were friendly and very helpful - I would recommend Firebrand training to all interested in a career in IT. During my stay we had some young students in the CompTIA A+ class - who were clearly not interested in IT and their actions were disruptive to the studying process and other students (including my colleague) who did want to study found it very difficult. But it is a testament to the instructor that the course continued and stayed on track. I would suggest that only students who are interested in pursuing a career in IT should attend "
Lee Adler, TNT.

MCTS SQL Server 2008 Business Intelligence Development and Maintenance - Course Dates

Start

Finish

Status

Book now

18/1/2010

21/1/2010

Finished

 

1/3/2010

4/3/2010

Finished

 

3/5/2010

6/5/2010

Open

Book now

Bookmark  - MCTS SQL Server 2008 Business Intelligence Development and Maintenance

Talk to us about Firebrand Training and our accelerated courses:080 80 800 888

Talk to us about Firebrand Training and our accelerated courses:

080 80 800 888

Request more information about Firebrand Training and our accelerated courses:

Request more information about Firebrand Training and our accelerated courses:

Firebrand Training printable phone icon Talk to us about this course on: 080 80 800 888