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

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

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

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 did a great job, his guidance on the skills of passing the exams was most valuable.

- George Ballane
Unavailable

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

Fantastic instructor! Really knew the material, and was adept at communicating in an understandable manner to those without an IT background. I couldn't ask for a more genuine, concerned instructor who had her students successful learning as the main motivator for everything she did. Simply superb!

- Timothy Dalhouse
Spectrum Training

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

Instructor was very intelligent and had lots of experience to draw on, outside of the written paterial that made it more interesting. I was very pleased with him.

- Sandra L. Speck
Sandra Speck Company

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

- Jeff Clemmons
Blood Systems

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]

My instructor is a freaking genius, however he really enjoys bringing the info and material to life so in a way you do catch a bit of genius by the end of the course.

- Samuel Angura
World Bank

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:

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

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

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 did a great job, his guidance on the skills of passing the exams was most valuable.

- George Ballane
Unavailable

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

Fantastic instructor! Really knew the material, and was adept at communicating in an understandable manner to those without an IT background. I couldn't ask for a more genuine, concerned instructor who had her students successful learning as the main motivator for everything she did. Simply superb!

- Timothy Dalhouse
Spectrum Training

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

Instructor was very intelligent and had lots of experience to draw on, outside of the written paterial that made it more interesting. I was very pleased with him.

- Sandra L. Speck
Sandra Speck Company

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

- Jeff Clemmons
Blood Systems

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]

My instructor is a freaking genius, however he really enjoys bringing the info and material to life so in a way you do catch a bit of genius by the end of the course.

- Samuel Angura
World Bank

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