Toll Free: 1.877.290.9507 | Direct:708.689.0131

SQL 2008 AND SQL 2008 Business Intelligence Boot Camp

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

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
  • Learn from a master. Tips, tricks, and hands-on training.
  • Personalized learning styles and formats
  • Up-to-the-minute techniques and releases
award-winning-training

Part 1: SQL 2008

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.

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

    Activate Your Future!

    REDEEM Microsoft SATV Training Vouchers HERE


    Click here to get more information about this class!

    Instantly View Course Syllabus and price

Date: Delivery Format: Location: Info:
08/09/2010 - 08/21/2010 Boot Camp (13 days) Washington Area, DC
11/08/2010 - 11/20/2010 Boot Camp (13 days) Washington Area, DC

There are many of us entering these classes that are managers and not programmers. The step-by-step is very helpful for those that don't know Linux or C as well.

- Brant Bertrand - AEH
Loves

Exceptional instructor and course, I would recommend it to anyone.

- Joaquin Fuentes
Early Warning

Excellent course. The instructor took the time to thoroughly explain the material and makes sure that everyone has a firm grasp of the concepts.

- Digby Morrow
State of Oregon

The course couldn't have been any better. Our instructor was very knowledgeable about the various topics discussed during the training and was able to provide various examples in order to help solidify course concepts.

- Richard Valdez
BNSF Railway Company

The course materials were clear and to the point. The labs really help you understand what was going on. I had an amazing instructor. I was overly impressed by his knowledge and skills.

- Anthony Pierce
ICF International - Jacob & Sundstrom

The material was good and very informative, the instructor was extremely knowledgable

- Marc Henscheid - AEH
Lackland AFB

Awesome! I couldn't have asked for a better teacher.

- Sergio Silva
Compustar C.A.

Good course materials, labs corresponded well to the lecture slides. Highly knowledgeable instructor of the subject matter. Lectures were actually interesting.

- Glynn Baron
none

Great instructor. He was very open to conversation and well versed in the material. Enjoyed his teaching style.

- Jeffrey Wiley
US Census Bureau

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 Instructor
  • High Quality Content
  • Self-Paced Training
Self-Paced

Mentored Online

Most popular self-pace option.

  • Online & Offline Playback (DVD,mobile)
  • Expert Instructor
  • Highest Quality Content
  • Self-Paced Mentored Training
  • Mentor & Live Instructor Support
  • Text books, Pre-Study, and Lab books
  • Complex Sims and Hands-On Exercises
Classroom

Instructor-Led

Our top rated trainign experience

  • Live Classroom
  • Expert Instructor constantly available
  • Highest Quality Content
  • 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 Hands-On Exercises
Classroom

Live Online

As close to the classroom from home

  • Live Classroom
  • Expert Instructor constantly available
  • 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 Hands-On Exercises

See what our students are saying:

The course couldn't have been any better. Our instructor was very knowledgeable about the various topics discussed during the training and was able to provide various examples in order to help solidify course concepts.

- Richard Valdez
BNSF Railway Company

The course materials were clear and to the point. The labs really help you understand what was going on. I had an amazing instructor. I was overly impressed by his knowledge and skills.

- Anthony Pierce
ICF International - Jacob & Sundstrom

I had a terrific instructor. His depth of knowledge was clearly evident. He approached each question raised by the students not only to answer, but to be sure the student understood the answer.

- John Hollan - AEH
GE

Great instructor. He was very open to conversation and well versed in the material. Enjoyed his teaching style.

- Jeffrey Wiley
US Census Bureau

awesome. The course was exciting and not only covered exam prep, but also explained how things work in the wild.

- Vincent Chapman
US Army

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

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

The instructor was very knowledgeable about the pen testing and ethical hacking. He was great in delivering the lectures, lab and was very helpful in having us complete the capture the flag exercises. In addition, he provided valuable insight about security in general and pen testing in particular.

- Tijan Drammeh
University of Maryland University College

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?

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

SQL 2008 AND SQL 2008 Business Intelligence

States