SQL Server 2008 (70-448) : Integration Services, Reporting Services and Analysis Services Blended Learning

Date & Time: See the above menu near the 'add to cart' button.

Location SmartPath LLC, 2018 156th Ave NE, Bellevue WA 98007

To guarantee your seat, don't wait! There are only 5 available seats per class. This gives you more personal attention and makes learning much easier. Click on the "Register for Class" button above and join the class now! If the class is showing it is still available for you to join, although it is usually necessary to register at least 7 - 14 days before the first day of the class to get a seat.

Instructions: The latest registration is required by 5:00 PM the day before the first day of class begins. Payment will be required at the same time. You may use either a credit card or debit card. Other ways to register and Pay by Cash, Cashier's Check, Employer Check or Purchase Order, or Voucher.

Pre-requisites to class:

From Microsoft: "Candidates for this exam are responsible for creating business intelligence (BI) solutions by using Microsoft SQL Server 2008 for their organizations. Candidates typically work with the full suite of BI technologies in SQL Server 2008, including Reporting Services, Analysis Services, and Integration Services. The qualified candidate for this exam typically has:

• One to two years of experience working with the Microsoft .NET Framework
• Two to three years of experience using SQL Server 2005 BI components
• Six months to one year of experience using SQL Server 2008
• Experience using the SQL Server 2008 Business Intelligence Development Studio (BIDS)
• Experience using Microsoft SQL Server Management Studio (SSMS)
• Knowledge of relational and multi-dimensional database schemas
• Experience creating and deploying a cube in SQL Server Analysis Services (SSAS)
• Experience creating and deploying a data mining model in SSAS
• Experience writing relational and multi-dimensional database queries
• Experience creating and deploying SQL Server Reporting Services (SSRS) reports
• Experience authoring and deploying SQL Server Integration Services (SSIS) packages • Experience debugging, monitoring, and troubleshooting BI solutions"

You Will Receive

• 42.5 hours of Instructor Led Blended Learning
• Certificate of Completion
• Subscription for Microsoft Online Learning for this course that you can practice for up to one year. We will use these labs in class.
• Instructor Led/Blended Learning
• One hour off for lunch
• Free coffee, tea, & free parking


Topics covered in this collection include:

• Introducing BI in SQL Server 2008
• Configuring, deploying, and maintaining SSIS, SSAS, and SSRS
• Implementing Packages, Data Flow and Control Flow in SSIS
• Customizing Cube Functionality, creating a multidimensional solution, and implementing data mining in SSAS
• Creating reports in SSRS


Audience: Technical

Course Outline