MCITP: SQL 2005 Business Intelligence Developer Boot Camp

Let us Help

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.

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


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

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

Yes! I would like more information on registering for an Intense School training class.

For detailed pricing information, please complete the following form. If you are ready to register today, please call: (866) 365-8401 to talk with an Intense School Training Solution Specialist.

* Required field


















*



Testimonials

"I was stationed with a unit on Okinawa, in Japan, where we didn't get to do our jobs very much, due to having them sold to a civilian contractor company. When I got to this class, I was way behind everybody else in the class with me. Now I feel like I could do my job just as well as the rest of the guys I work with."

"This class is for the motivated. The days are long with many hours dedicated to study. A great way to advance but only if you have the want."

Ivan Cruz
USMC


“My Vigilar experience was excellent from start to finish. The quality of the instructor, the venue, the curriculum and the flexibility offered were all second to none! I would recommend Vigilar to anyone interested in doing a bootcamp!.”

Stuart Hamilton
Northwest Center

"This course made amazing things happen for our unit in a very short amount of time, right before we were going to need it: during an imminent deployment to Iraq."

"I have attended around 10 different IT/network-related courses and Intense School had the most knowledgeable instructor that I have ever had. He did a fantastic job."

Robert Lee
USMC

"I would love to be able to get more of this type of instruction to my Platoon. If you are will to send instructors to Iraq with us, we will be more than happy to show them a good time and pick their brains while they are in country."

Roman Dain
USMC

I got my MCSE Security+ certification and LEARNED so much. Even though there was a lot of material to cover, the instructor knew exactly how to deliver it and made us learn always through exercises, labs, examples and crystal clear explanations. It was a great experience, no question went unanswered. I´m very satisfied and will take other training courses from you as well as recommend Vigilar and Intense School with my best references."

"I wanted to write the appropriate person at Intense School to let them know how exceptional the instructor is. He is unrelenting in seeking out the answer to any and all questions that are raised. The way he handles a class and his knowledge of the subject matter certainly make Intense School the right choice. The site coordinator also did an excellent job of making himself available whenever needed. His flexibility allowed for a much more custom tailored training environment. And as usual,my account rep made the whole experience flawless. This was my fourth boot camp with Intense School and as usual it was another outstanding performance. Due to these experiences, I would highly recommend Intense School to anyone."

"Intense School's team were great people, very open and easy to communicate with."

"It was a great program for what it was designed for."

"Great instructor. He kept us focused and on track."

"Overall, Intense School has an exceptional program for preparing individuals with varying levels of experience with the essentials for passing the Microsoft Security + Certification tests. The course curriculum is demanding, however, our instructor, was dedicated to keep us focused and greatly increased our chances of success. Intense School's attention to detail is shown through all staff. The course's site administrator made sure that all were afforded the opportunity to focus on the course. All other matters were handled by the site administrator. Intense School is the way to go for accelerated technical learning."

"The MCSE:Security+ class was informative and well planned and carried out. Time went by quickly and information was easily received and understood."

"This course is an excellent opportunity for experienced IT professionals to get that ever important certification within a very short period. I had been getting stagnant in the administrator position I was in, this boot camp will definitely give your brain a jump start to get moving again. Excellent instructor with great real world experiences. The site administrator very helpful in the classroom with many of the extra things that helped get through the busy days."

"This course made amazing things happen for our unit in a very short amount of time, right before we were going to need it: during an imminent deployment to Iraq."

"This was a very challenging two weeks but the reward is your MCSE so you learn to push through the harder subject areas. Get through the 70-291 exam...you're home free. Thanks and I look forward to my next experience with Intense School."

"I highly recommend Intense School for IT training"

"Intense School provided us with a supportive environment during the 14-day training. The instructor was very good. She adequately answered all questions. The facility was available 24X7 for those who needed the classroom and PCs for practicing & studying; drinks & snacks were always available; catered lunch was provided every single day; and the site administrator & instructor were available around the clock."

Debbie Pass

"Kelly and Chris are a great team. I passed every test the first time because of the time that our instructor invested in me. The hours were long and the material can be dry and esoteric but Kelly kept us on track. Her sense of humor was invaluable. Our logistician, Chris was very flexible about scheduling the tests - some as late at 7:00 in the evening - just to make sure that anyone (like me) who needed that extra hour to study. I was really impressed with the skill and the breadth of knowledge that the instructor demonstrated. Thank you so much.

"The Intense School Team were wonderful to work with. They were accommodating in every way. They made the two weeks a memorable experience. I came in with reservation on how I will complete such a big task in only two weeks. They assure me that it can be done with encouragement and positive feedback. Thank you both helping me get through these two weeks."

"The instructor and Site Administrator worked together to provide a great experience over these past two weeks. I would not have been able to pass my MCSE 2003+Security and and MCSE 2008 upgrade without their hard work and help.

"It was a lot of fun. Very exhausting and lots and lots of work and no sleep, but it was all well worth it in the end."

Click here to get more information about this class!



**This program is available for Corporately Sponsored Students only. This program has not been approved by the Florida Commission for Independent Education.