Insider Training MCTS SQL 2008 Live Online Training

Untitled 1

	Watch the TV Review of Insider Training (WMV - 4 minutes)
Call us toll free at (866) 509-7511 or from outside the US at (208) 765-8290

HOME

ABOUT US

" It seems that the new exams from Microsoft are very buggy when it comes to simulations with Prometric. In the end, thanks to your excellent courses and provided materials, I felt confident engough to skip the simulation questions all together. I scored 871, skipping 10 simulations. Funny thing is, I knew all the simulation questions, and would have score much higher. Just wanted to say thanks and keep up the great work. "

Live, Online Instructor-led MCTS: SQL 2008 Business Intelligence Training

Microsoft Certified Technology Specialist (MCTS): SQL 2008 Business Intelligence Certification Training Packages

Course Overview
Our complete MCTS: SQL 2008 Business Intelligence training packages give you the expert knowledge and hands-on experience you need to master SQL Server 2008 core Business Intelligence technologies and pass the Microsoft exam for this important certification. Passing the MCTS SQL 2008 Business Intelligence Development and Maintenance exam is a prerequisite for attaining the advanced level MCITP: SQL 2008 Business Intelligence Developer certification.

For one low price, you‘ll tap into the most powerful learning system available anywhere. The Insider Training Multi-Path Learning System will maximize what you learn, and more importantly, how much you retain.

Important Notes: Although it is not required, we STRONGLY recommend that students who are not already well versed in SQL 2008 database design and development skills should attend the MCTS SQL 2008 Database Developer class prior to enrolling in any Business Intelligence course.

This course provide a comprehensive learning track for both new and experienced database developers to understand business intelligence implementation, maintenance, and design using SQL Server 2008 technologies. The courses include a detailed focus on SQL Server 2008 core topics required to be a successful business intelligence specialist including SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

Available Course Formats:

	Available Formats
Key Benefits	+LIVE Premium	On Demand *
Expert instructors	X	X
Flexible scheduling	X	X
No travel required	X	X
No out of office days	X	X
Key Features
+LIVE class hours	20	20
+LIVE class duration	5 weeks	5 weeks
+LIVE class recordings	X	X
Live hands-on labs on your schedule	30 hours	*
1 year of online access	X	6 months
Ongoing instructor mentoring	X	*
1 Transcender test prep product (included in reg. fee)	$149 value	*
1 Premium course book (included in reg. fee)	$69 value	*
Guaranteed certification	X
1 Premium headset with microphone (included in reg. fee)	$75 value	$75 value

* On Demand Premium is currently not available for this course

PREPARATION FOR EXAMS: MCTS: SQL 2008 Business Intelligence

70-448: TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

	+LIVE Online Instructor Led Sessions We know you‘re busy. That‘s why we‘ve designed a flexible training schedule that works around you! The +LIVE course meets twice a week for two hours at a time for live, online, instructor-led sessions. Our unique 7-step program starts with hand-picked, certified trainers with extensive consulting and training backgrounds. Each week you‘ll attend live, information-packed sessions that cover three to four major topics in depth. Because it‘s live, you‘ll be able to get your toughest questions answered right away. In-class quizzes and surveys will ensure that you‘re absorbing the key points along the way.
	24/7 Access to Class Recordings Need to miss a class? No problem! All class sessions are digitally recorded and automatically indexed so that you can review the material at any time. You‘ll be able to tap into your class recordings immediately after the live sessions and have extended access for a full twelve months starting from when your course begins.
	Hands-On Lab Time Insider Training‘s remote lab gives you the ability to put your knowledge to work on real systems on your own schedule. Your private lab time is scheduled in advance at any time convenient for you. When you connect in, you‘ll be in total control of multiple real systems.
	Ongoing Instructor Mentoring Your instructor is available to answer your questions inside and outside of class. You‘ll have email access for twelve months starting from when your course begins.
	Highest-Rated Transcender Practice Exam Simulations Before tackling the real exam, you‘ll know you‘re prepared by taking these hard-hitting practice exams. Each simulation provides three complete practice exams with questions that closely match the style and wording of the real thing. Each question explains both the right and wrong answers with references to supporting documentation.

	Exam ID	Price	Transcender Product
1	70-448	$149.00	MCTS Microsoft SQL Server 2008 Business Intelligence Development and Maintenance
	TOTAL VALUE	$149.00	This is included in your +Live Premium and On Demand Premium registration fees.

Microsoft Press Self-Paced Training Kit
Each kit includes hands-on practice labs, and sample test questions. They‘re clearly written and highly regarded by our instructors and students alike.

	Publisher	Price	Name
1	Microsoft Press	$69.99	MCTS Self-Paced Training Kit (Exam Exam 70-448): Microsoft SQL Server 2008 - Business Intelligence Development and Maintenance
	TOTAL VALUE	$69.99	This is included in your +Live Premium and On Demand Premium registration fees.

Certification Guarantee
If you purchase the +LIVE Premium and you meet the course prerequisites, we guarantee that you will pass your certification exams. If you do not pass an exam, we will assign an instructor to work with one-on-one you until you succeed.

PREREQUISITES:

Broadband Internet connectivity (DSL, Cable or other high-speed connection)
AND EITHER
1 year of hands-on experience as a database developer
OR
1 year of hands-on experience as a systems administrator or support specialist
AND enrollment in the MCTS SQL 2008 Database Developer course

Course Overview

MCTS SQL 2008 Business Intelligence

SQL Server Integration Services (SSIS)
Install and configure SSIS components
Developing SSIS Packages
Understanding package logic
Implement control flow and data flow
Implement dynamic packages
Using .NET code to extent SSIS packages
Manage SSIS package execution
Deploying SSIS packages
Configure SSIS security
SQL Server Analysis Services (SSAS)
Install and configure SSAS components
Building SSAS cubes
Implementing dimensions and measures
Using data mining
Configure SSAS security and roles
Troubleshooting SSAS performance problems
SQL Server Reporting Services (SSRS)
Install and configure SSRS components
Designing report layouts
Configuring report data sources and datasets
Using report parameters and interactivity
Controlling report execution and delivery
Using SSRS reports in custom applications
Configure SSRS security
Designing high availability for SSRS
Gathering Performance Information