KT-MCITP6 MCITP: SQL 2008 R2 Business Intelligence Developer (2 Cert) - 7 Days Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


MCITP: SQL 2008 R2 Business Intelligence Developer (2 Cert) - 7 Days


Description: 

Course Length: 7 days

Certification:

  • 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

What's Included:

  • 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.

Facilities:

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.

 
Click here to view the Course Outline
     
Prerequisite: 

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.

 
   
     
Duration: 
7 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.