Toll Free: 1.877.290.9507 | Direct:708.689.0131

Microsoft MCTS: SQL

Microsoft MCTS: SQL 2005 Business Intelligence

Six Intense Days of Hands-on training is focused on providing the necessary training for IT Professionals who want to become skilled on designing, implementing and managing SQL Server 2005 solutions.

This Boot Camp will prepare qualified Microsoft professionals to earn the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2005 Business Intelligence 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-455, 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.

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
award-winning-training

SPECIAL OFFER:  FREE RETAKES for each specific Microsoft exam in this Boot Camp

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

Get MCTS: 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 Microsoft Official Courseware:

  • Course 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
  • Course 2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
  • Course 2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Official MCTS: SQL 2005 Business Intelligence Boot Camp - Benefits and Goals:

Our six (6) day intense Official MCTS: SQL 2005 Business Intelligence 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 MCTS: SQL 2005 Business Intelligence 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-445
  • Bonus - 1 FREE makeup exam voucher for each specific 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 MCTS
  • 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 be installing SQL Server 2005 Analysis Services, developing Analysis Services Solutions, debugging error handling in an Integration Services package, administering Reporting Services and learn how to implement custom Reporting Services applications.. Evening Sessions are not mandatory, but our world-class instructors are there to see the concepts of the day are reinforced through proper self paced exercises and practice materials.

Professional Exams and Certifications

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

  • Exam 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
  • You will achieve the following premium certification:
  • MCTS: SQL Server 2005 Business Intelligence
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-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance.


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


















*



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

Click here to get more information about this class!

Instantly View Course Syllabus and price

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

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

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 very knowledgeable in the subject area. his broad range of experience helped him inject real world scenerios into the training

- Bill Robinson
DHS

Incredible instructor. The coursework covered 300 topics in 10 domains, and he was able to speak intelligently on all of them. Better, his teaching style was relaxed and informal, which lessened the feelings of impending doom about the exam we were about to undertake. He knew exactly which sections of the material to emphasize, when we needed a break, and in many cases was speaking ahead of the slides (he knew exactly what was coming up before turning the slides). Rare gem.

- Thomas Dunn
Georgia Tech Research Institute

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

Instructor was to the point, and stayed on topic. Appreciated that he doesn't get led off tangents by students questions.

- Mark Yu
MBL Technologies

Instructor did a fantastic job of delivering a large set of very dense course material cogently to the class. She obviously had the material down cold and could easily break down elements of the different knowledge domains in clear explanations.

- Byron Caswell
Scitor

Excellent instructor. One of the best I have had in over 27 years in the IT business. Genuinely cared about the students understanding the subject material and their success in passing the exam. She taught how to think and reason to pass the test. That is something not found in any text book.

- Craig Calder
[[Unknown]]

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]

Instructor demonstrated advanced knowledge of the subject matter as well as INFOSEC in general. He provided us with all of the tools and reference materials we needed to perform the DIACAP process. The course materials are great!

- TR Piller
none

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

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

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 very knowledgeable in the subject area. his broad range of experience helped him inject real world scenerios into the training

- Bill Robinson
DHS

Incredible instructor. The coursework covered 300 topics in 10 domains, and he was able to speak intelligently on all of them. Better, his teaching style was relaxed and informal, which lessened the feelings of impending doom about the exam we were about to undertake. He knew exactly which sections of the material to emphasize, when we needed a break, and in many cases was speaking ahead of the slides (he knew exactly what was coming up before turning the slides). Rare gem.

- Thomas Dunn
Georgia Tech Research Institute

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

Instructor was to the point, and stayed on topic. Appreciated that he doesn't get led off tangents by students questions.

- Mark Yu
MBL Technologies

Instructor did a fantastic job of delivering a large set of very dense course material cogently to the class. She obviously had the material down cold and could easily break down elements of the different knowledge domains in clear explanations.

- Byron Caswell
Scitor

Excellent instructor. One of the best I have had in over 27 years in the IT business. Genuinely cared about the students understanding the subject material and their success in passing the exam. She taught how to think and reason to pass the test. That is something not found in any text book.

- Craig Calder
[[Unknown]]

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]

Instructor demonstrated advanced knowledge of the subject matter as well as INFOSEC in general. He provided us with all of the tools and reference materials we needed to perform the DIACAP process. The course materials are great!

- TR Piller
none

Prerequisites?

In 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:

  • Conceptual understanding of OLAP solutions.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Windows services (starting and stopping).
  • Experience creating service accounts and permissions.
  • Experience with Microsoft SQL Server, including:
  • SQL Server Agent.
  • SQL Server accounts (users and permissions).
  • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
  • SQL Server System tables.
Certifications

Microsoft MCTS