# # # #

Service Center

Microsoft MCTS / MCITP SQL 2008 Business Intelligence (BI) Boot Camp

During this intensive 7-day dual Microsoft Certified Technology Specialist and Professional (MCTS. MCITP): SQL Server 2008 Business Intelligence Boot Camp, students will live, learn, and take the exams at one of our state-of-the-art education centers. This blended-learning course employs outcome-based (Lecture | Lab | Review)™ delivery that focuses on preparing you with the real-world skills and is designed to provide the maximum amount of material in the shortest period of time.

Upon successful completion of this course, you will walk away with two Microsoft certifications and the knowledge and skills necessary to design and plan business intelligence (BI) solutions by using Microsoft SQL Server 2008 BI tools.

Training Dates and Locations Nationally
Our Boot camp includes:

  • Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Review)™ Delivery.
  • Blended-Learning Instruction comprised of comprehensive study materials and pre-class mentoring, customized Microsoft Official Curriculum, comprehensive lab manuals, and Self-Test Testing Software.
  • Seven (7) Days of Deluxe Hotel Accommodation.
  • 24-Hour Lab and Instructor Access.
  • Examination Vouchers & On-site Certification Testing.
  • Most Meals; Unlimited Beverages, Snacks and Freshly-brewed Coffee.
  • Examination Passing Policy. Should a student complete this Boot Camp 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.

Microsoft MCTS SQL 2008 Self Paced Online or CD-ROM Course for Certification

Daily Class Schedule:
Our daily schedule incorporates different modes of instruction and learning environments to ensure that students learn, retain, comprehend, and can apply knowledge critical to a MCITP on SQL 2008. Please note that changes may be made to the schedule on a daily basis to ensure that the goals of the course are met.

  • 8:15 am to 9:00 am       Breakfast
  • 9:00 am to 1:00 pm       Instruction: Lecture
  • 1:00 pm to 1:30 pm       Lunch
  • 1:30 pm to 5:30 pm       Instruction/Interactive, Hands-on Labs
  • 5:30 pm to 7:30 pm       Dinner Break, Study Time, One-One Instructor Mentoring
  • 7:30 pm to 9:00 pm       Wrap-Up Sessions

Training Courses Covers

  •     SSAS Solution
  •     Configuring, Deploying, and Maintaining SSAS
  •     Implementing an SSRS Solution
  •     Configuring, Deploying, and Maintaining SSRS
  •     Managing Reports
  •     Data Mining Models
  •     Administering a BI Solution
  •     BI Architecture
  •     Deploying SSIS Packages
  •     Analysis Services Database

After attending our MCITP SQL 2008 BI Business Intelligence Boot Camp, you will know :

  • Business Intelligence (BI) architecture in SQL Server 2008
  • Sstrategy for implementing the extract, transform, load (ETL) process by using SQL  Server 2008 Integration Services (SSIS)
  • Strategy for managing packages by using SSIS
  • Online analytical processing (OLAP) solution architecture by using SQL Server 2008 Analysis Services (SSAS)
  • Physical storage for an OLAP solution by using SSAS
  • Design an administration and maintenance strategy for an SSAS solution
  • Doing effective queries for an OLAP solution by using SSAS
  • Develop a SQL Server 2008 Reporting Services (SSRS) solution architecture
  • Develop a strategy for deploying and managing an SSRS solution architecture
  • Data mining solutions by using SQL Server 2008

Certification Exam Track

  • 70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
  • 70-452: PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008