11 Full Days of MS SQL 2008 Training. This is a combined course of MCTIP Database Administrator SQL 2008 and SQL 2008 Business Intelligence.

You'll receive real world hands-on training and 4 premium Microsoft Database Admin Certifications!

Current public enrollment schedule(note there is a 2 day weekend break in this combined boot camp format):

 

 

The first part of the boot camp will prepare qualified Microsoft professionals to earn the Microsoft Certified IT Professional (MCITP): Database Administrator 2008 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 two exam vouchers for the  Microsoft professional exams.

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 8 days of Official Microsoft Courseware:

• 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (three days)
• 6231: Maintaining a Microsoft SQL Server 2008 Database (five days)

Official MCITP Database Administrator: SQL 2008 Boot Camp - Benefits and Goals
5 days of intense Official MCITP: SQL 2008 Boot Camp provides information technology professionals with the knowledge and skills necessary to design and deploy SQL Server 2008 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.

Professional Exams and Certifications
Intense School’s Official MCITP Enterprise Messaging Administrator Boot Camp extensively prepares students for the following Microsoft Certified Technology Specialist exams:

• Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance
• Exam 70-450: PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution using Microsoft SQL Server 2008

Experienced database admins who have already earned the MCITP: Database Administrator, SQL Server 2005 certification, will take one upgrade exam instead of the two exams listed above:

• Exam 70-453: Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008

By testing and passing both exams onsite during the boot camp, ou will achieve the following premium certification:

• Microsoft Certified IT Professional (MCITP): Database Administrator 2008

 

 

Part 2: BUSINESS INTELLIGENCE

 

In the second half of this boot camp, you will earn the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008 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-448, plus 1 free makeup voucher for that exam to be taken during or after class.  

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 6234: Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 
•    Course 6235: Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 
•    Course 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 


Official MCTS: SQL 2008 Business Intelligence Boot Camp - Benefits and Goals
Our six (6) day intense Official MCTS: SQL 2008 Business Intelligence Boot Camp provides information technology professionals with the knowledge and skills necessary to design and deploy SQL Server 2008 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 2008 Business Intelligence Boot Camp offers you the following benefits:
•    Included - 2 Exam Vouchers: 70-448  and 70-432
•    Bonus - 2 FREE makeup exam voucher for each specific exam
•    In-person access to the top experts in the industry
•    11 nights of hotel accommodations (you will be responsible for the weekend in between the two halves of this course)
•    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 2008 Investment

Here’s what you’ll have access to:
Each student will design their own SQL 2008 Server solutions, configure multi-server connections, and engage in complex troubleshooting exercises that increase pass rates and build Exchange Administration skills. 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.

Each student will be installing SQL Server 2008 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 2008 Business Intelligence Boot Camp extensively prepares students for the following Microsoft Certified Technology Specialist exam:

• Exam 70-448: TS: Microsoft SQL Server 2008 Business Intelligence – Implementation and Maintenance

• Exam 70–432: TS: Microsoft SQL Server 2008 - Implementation and Maintenance

You will achieve the following premium certifications

• MCTS: SQL Server 2008, Business Intelligence Development and Maintenance
• MCTS: SQL Server 2008 

 

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.

Prerequisites:
Students must 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.

 

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 2008 and SQL 2008 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

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