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

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

- Marc Henscheid - AEH
Lackland AFB

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

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

- Joaquin Fuentes
Early Warning

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

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

- Glynn Baron
none

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

- Sergio Silva
Compustar C.A.

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

My instructor was quick to accomodate the learning needs of everyone in the classroom both as a group and on an individual level as well.

- John Godwin
IRS

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:

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

- Vincent Chapman
US Army

My instructor was quick to accomodate the learning needs of everyone in the classroom both as a group and on an individual level as well.

- John Godwin
IRS

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

- Joaquin Fuentes
Early Warning

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

- Sergio Silva
Compustar C.A.

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

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

- Jeff Clemmons
Blood Systems

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

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

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]

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