Course Length: 7 days
- MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
- MCITP: Business Intelligence Developer 2008
Number of Exams: 2
- 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
- Airfare To/From Sarasota or Tampa
- 7 Nights of Lodging
- Ground Transportation
- 2 Microsoft Test Vouchers
- 2 Retake Vouchers (If needed)
- Onsite Prometric Testing Center
- Microsoft Training Books
- Microsoft Study Labs & Simulations
- Instructor Led Classroom Training
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.
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.
Our MCITP Program:
Focuses on accelerated learning. We cover concecpts in a clear, condensed fashion. We focus on the important objectives and cut out the "fluff".
Uses real world examples and terminology. Our instructors explain technical concepts in a way students can see and relate to. No two students are alike - and our class is dynamic to cater to the needs of the students.
WE LIMIT OUR CLASS SIZES TO 12 STUDENTS - THIS ALLOWS FOR MORE ATTENTION FROM THE INSTRUCTOR, MORE SPACE FOR STUDENTS TO WORK AND MORE FOCUSED ENVIRONMENT. We have a 96% success rate of students passing these exams the first time.
Our facilities are second to none. We use top end computer equipment - 20in monitors, cpu's with Intel Virtualization, 6 gigs (min) of memory. We use Herman Miller chairs to ensure comfort for bootcamp hours. Our desk allow plenty of room for student computer, your laptop and book - each student has a dedicated 6ft desk workspace.
Student take all test at our campus with Prometric test centers.
Students stay at Marriott & Hilton brand hotels which provide full studio amenities including flat panel tvs, microwave and refrigerator in every room. Students have access to 20+ restaurants within walking distance of the hotel.