Home > Training > Microsoft > SQL8BID

MCITP: SQL 2008 R2 Business Intelligence Developer (SQL8BID)

Download PDF Download Course Outline (PDF)
Course Description Schedule Course Outline
 

What's Included?

  • 7 days of intensive boot-camp style training with no distractions
  • After Hours Sessions: Instructors remain into the evening hours in order to help students in need.
  • Authorized Microsoft Curriculum
  • Pre-class Study Guide, shipped to your home
  • Supplemental Exam Prep material and Practice Exams
  • Both 2 Exams Delivered during class
  • 7 Nights of Stay
  • Make-up exam vouchers if necessary
  • Breakfasts, Lunch, snacks and beverages all day, every day
  • Flight to and from Sarasota from anywhere in the Continental U.S.
  • Shuttle to and from the Airport
  • Shipment of course books back home after the program (we provide you a lot of materials, and want to save you the headache, the back ache and the cost for extra baggage fees)
  • Top-notch training facilities with cutting edge computers and 20 inch monitors
  • Student Work areas with executive chairs and 5 ft of desk area
  • Small class sizes: no more than 16 students per class
  • Ground transportation

Who should attend

Microsoft Certified IT Professional: SQL Server 2008 R2 Business Intelligence bootcamp is the premier certification for DBAs looking to build end to end BI solutions. The certification confirms that you are fully qualified to configure and implement a complete BI Solution.

Certifications:

  • MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
  • MCITP: Business Intelligence Developer 2008

Exams:

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

Prerequisites

The candidate works in a development environment that uses SQL Server technologies. The candidate should have at least one year of experience developing SQL objects and understanding of normalization.

Course Objectives

In this course we teach you how to take data from a Relational OLTP system and transform it into Star and/or SnowFlake schemas and store it within a DataMart/DataWarehouse. Next, we demonstrate how to build an Integration Services (SSIS) package to automate the ETL process from the Relational OLTP to the DataMart / DataWarehouse. Then , we spend several days exploring the features of Analysis Services (SSAS) including cube designer, dimensions, measures, KPIs, Perspectives, Translations, MDX and Data Mining. Finally, our camp looks at the different ways to present our data to different users - from Reporting Services (SSRS) to more interactive solutions like Excel PowerPivot and Sharepoint 2010 built in BI solutions.

Microsoft Certified IT Professionals focusing on the SQL Server 2008 R2 Business Intelligence certification demonstrate their understanding of a complete life cycle of Business Intelligence.

Our MCITP: SQL Server 2008 R2 Business Intelligence bootcamp is a very hands on environment. Our instructors guide you through step by step examples and demonstrations, not just long lectures. Your instructor will create real world scenarios for lab environments.

Duration: 7 days

Price:
  • US$ 5,495
 
Click City Name To BookSchedule
This green checkmark in the Upcoming Schedule below indicates that this date/time is Guaranteed To Run in accordance with Fast Lane's terms and conditions.
United States
 Jun 16-22, 2012 Guaranteed to Run Sarasota 6 days Partner Delivery Partner Delivery Enroll
Jul 7-13, 2012 Sarasota 6 days Partner Delivery Partner Delivery Enroll