Toll Free: 1.877.290.9507 | Direct:708.689.0131

MCITP: SQL 2005

MCITP: SQL 2005 Business Intelligence Developer Boot Camp

This six day program is an immersion into designing and developing a SQL 2005 Business Intelligence solution, complete with hands-on and guaranteed certification success!

This Boot Camp will prepare qualified Microsoft professionals to earn the Microsoft Certified Technology Specialist (MCITP): Microsoft SQL Server 2005 Business Intelligence Developer certification. This program is truly dual purpose: for cutting-edge skills development, we provide you with expert instruction and our Intense School brand of hands-on Labs that are accelerated and based on real-world scenarios; for test-preparation, you will practice sample questions and take simulated exams using Intense School’s time-tested proprietary practice exams. During class, each student will be given one exam voucher the 70-446, plus 1 free makeup voucher for that exam to be taken during or after class.

Information about this course:

This course is offered as:

  • Classroom Instructor-led Boot Camp
  • Live Online Instructor-led Boot Camp
  • Mentored Self-Paced Online
  • Streaming-Only Self-Paced Online

$-,---

View Course Pricing

and what is included with your enrollment

Course Highlights
  • Expert Microsoft Instructor - Extended availability
  • Highest Certification Pass Rates
  • Complex sims & exercises, gives you practical hands-on experience

This class currently is offered as on on-site opportunity only.

Your company will save big on group on-sites of 6 or more students.

Get MCITP: SQL 2005 Business Intelligence Certification Training FAST on-site at your location for a fraction of the price of our public scheduled Boot Camps!

Activate Your Future!

REDEEM Microsoft SATV Training Vouchers HERE

 

This course includes Official Microsoft Learning Product (OMLP) materials fortified with Intense School’s accelerated Supplemental materials, allowing for you to get more intensive hands-on experience during class, as well as providing you an integrated approach toward certification success.

The program accelerates the following 9 days of Official Microsoft Courseware:

  • Course 2794: Designing a Business Intelligence Solution Architecture for the Enterprise Using MS SQL
  • Course 2795: Designing an ETL Solution Architecture Using MS SQL 2005 Integration Services
  • Course 2796: Designing an Analysis Solution Architecture Using MS SQL 2005 Analysis Services
  • Course 2797: Designing a Reporting Solution Architecture Using MS SQL 2005 Reporting Services
TOfficial MCITP: SQL 2005 Business Intelligence Developer Boot Camp - Benefits and Goals:

Our six (6) day intense Official MCITP: SQL 2005 Business Intelligence Developer Boot Camp provides information technology professionals with the knowledge and skills necessary to design and deploy SQL Server 2005 database solutions to the enterprise. This is an accelerated immersion course, designed for computer professionals that require effective, real-world skill-building and timely certification.

Only Intense School’s Official MCITP: SQL 2005 Business Intelligence Developer Boot Camp offers you the following benefits:

  • Our definitive, TOTAL immersion boot camp experience
  • 6 full days of intense instruction with no outside distractions
  • Included Exam Voucher for 70-446
  • Bonus: 1 FREE makeup exam voucher for each exam
  • In-person access to the top experts in the industry
  • 6 nights of hotel accommodations
  • Lunch and snacks provided on each day of class
  • Highly accomplished status as a distinguished MCITP
  • Provides tangible evidence of career growth for potential salary increase and/or promotion
  • Provides TCO for your Microsoft SQL 2005 Investment
Here’s what you’ll have access to:

Each student will learn how to work in enterprise environments to design a BI solution architecture, and how to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production. You will also design a reporting solution architecture that supports your BI solution.

Professional Exams and Certifications

Intense School’s Official MCITP: SQL 2005 Business Intelligence Developer Boot Camp extensively prepares students for the following Microsoft Certified Technology Specialist exam:

  • Exam 70-446: PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005
  • You will achieve the following premium certification:

  • MCITP: Business Intelligence Developer
Who Should Attend:

The audience for this course includes people with experience administering, supporting or designing relational databases and a working knowledge of Transact-SQL. Preferably, students have already taken training towards and have passed Exam 70-445: TS: Microsoft SQL Server 2005 – Business Intelligence.

Click here to get more information about this class!

Our instructor displayed exceptional knowledge and expertise with the material he was teaching. He was very patient with the class, who did not have a lot of experience with material being covered.

- Dale Wamsley
Brooke Army Medical Center (CTR)

He was very knowledgable in the course material and presented it in a very methodical way. The course materials were great and are resources we will use in the future.

- Ralph Polk
Brooke Army Medical Center (CTR)

The instructor was very knowledgeable, and was able to explain complicated technologies in a way that was easy to comprehend. I was given everything I needed to learn and complete my course with confidence.

- Travis Drennan

The instructor was able to not only answer all the questions we had in class and after hours he was able explain the technologies and real world reasons behind using technology A vs B. He adapted the class as needed for all students. I have only had one other instructor at his level in my 15 year career in IT.

- Doug Lloyd - MESA
University of Georgia

The instructor was very knowledgeable in the subject area. his broad range of experience helped him inject real world scenerios into the training

- Bill Robinson
DHS

The class more than exceeded my expectations. The material was exactly what i needed to get my certifications and more. There was not one question the professor could not answer.

- George Embrey
IMC

Course was outstanding as always. All material was covered well and all questions were answered. I am thoroughly satisfied.

- Bill Ross
Precision Fabricating & Cleaning Inc.

Instructor was very knowledgeable in all subjects of the course and tailored his lessons and labs to the student's weaknesses. Very eager to help students in any way he can.

- Scott Masury
MA Army National Guard

I had an above-average instructor. Not only did he instruct, he mentored us with real-world experience. The knowledge he had of the applications was beyond comprehensible. Outstanding!

- Weston Flowers
Brooke Army Medical Center (CTR)

Select the type of training that best fits your schedule and learning style!

Live, Online, Self-Paced, Classroom - contact us for details on each.

Self-Paced

Streaming Only

Base Course. Best for refresher courses

  • Easy Online Access
  • Expert Microsoft Instructor
  • Exam Review
  • Highest Quality Content - 90% Pass
  • Self-Paced Training
Self-Paced

Mentored Online

Most popular self-pace option.

  • Online & Offline Playback (DVD,mobile)
  • Expert Microsoft Instructor
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Self-Paced Mentored Training
  • Mentor & Live Instructor Support
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Instructor-Led

Our top rated training experience

  • Live Classroom
  • Expert Instructor constantly available
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Self-Paced Training (optional add-on)
  • Extensive Live Instructor Support
  • Our highest pass rate course version
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files
Classroom

Live Online

As close to the classroom from home

  • Live Classroom
  • Expert Instructor constantly available
  • Intense Proprietary Exam Prep
  • Highest Quality Content - 90% Pass
  • Self-Paced Training (optional add-on)
  • Extensive Live Instructor Support
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Exercise Files

See what our students are saying:

Our instructor displayed exceptional knowledge and expertise with the material he was teaching. He was very patient with the class, who did not have a lot of experience with material being covered.

- Dale Wamsley
Brooke Army Medical Center (CTR)

The instructor did a great job, his guidance on the skills of passing the exams was most valuable.

- George Ballane
Unavailable

I had an above-average instructor. Not only did he instruct, he mentored us with real-world experience. The knowledge he had of the applications was beyond comprehensible. Outstanding!

- Weston Flowers
Brooke Army Medical Center (CTR)

The instructor was able to not only answer all the questions we had in class and after hours he was able explain the technologies and real world reasons behind using technology A vs B. He adapted the class as needed for all students. I have only had one other instructor at his level in my 15 year career in IT.

- Doug Lloyd - MESA
University of Georgia

The instructor was very knowledgeable, and was able to explain complicated technologies in a way that was easy to comprehend. I was given everything I needed to learn and complete my course with confidence.

- Travis Drennan

One of the most intelligent and well-spoken instructors I have ever had the privilege to work with. His in depth knowledge of the 10 domains in CISSP surpassed my expectations as well as the expectations of my classmates. His teaching style kept the otherwise dry information very memorable and exciting. I would HIGHLY recommend this course to my peers.

- Student
National Institutes of Health

My instructor is an excellent instructor. knowledgeable and good in the Net+, generally in computer training and other related area. he is very good. The quality of the course materials are perfect.

- Lucy Fakeye - Net+
[not provided]

A great instructor, very intelligent and well spoken and excellent course materials.

- Jeff Clemmons
Blood Systems

Prerequisites?

IIn addition to having 2 years or more working with SQL 2000 or 2005, and preferably the MCTS: Microsoft SQL Server 2005 – Business Intelligence certification, students should have:

  • Experience working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS)
  • At least one year of experience designing both relational and multidimensional database schemas
  • Experience designing and building cubes to support business requirements
  • One to two years of experience writing both relational and multidimensional queries
  • Experience in applying data mining algorithms to business problem domains
  • Experience designing and creating reports to support business requirements
  • Experience aggregating data into a data warehouse from multiple sources in a heterogeneous data environment
  • Experience in designing enterprise-level solutions for very large multidimensional databases
Certifications

WINDOWS SERVER 2008 MCITP / MCSA

States