Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
South Africa 1684

You are here

courses popup callback


Microsoft 70-448: Microsoft SQL Server 2008 BI Development and Maintenance

Practical exercises in a live environment to help you get real-world, hands-on experience.


The 70-448 Practice-Lab will provide you with the necessary platform to gain hands on skills in SQL Server 2008. By completing the lab tasks you will improve your practical skills in Deploying, Configuring & Maintaining SSIS solutions, SSRS Reports, Caching & Snapshots, Deploying, Implementing & Configuring SSAS solutions. These same tasks will help you understand the objectives and competencies required by the MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance certification exam.

Vendor:   Microsoft
Vendor Id:   70-448
Version:   1
Level:   Intermediate
Learning Time:   660  Minutes


  1. Implementing an SSIS Solution
  2. Total Learning Time is 70  Minutes and module version is 1

    • Introduction
    • Implement control flow
    • Implementing package configurations
    • Implement package logic by using variables
    • Implement dynamic package behaviour by using property expressions
    • Transactions
    • Summary
  3. Configuring and Deploying and Maintaining SSIS
  4. Total Learning Time is 90  Minutes and module version is 1

    • Introduction
    • Install and maintain SSIS components
    • Deploying SSIS packages by using the deployment utility
    • Scheduling package execution by using SQL Server Agent
    • Running a package from SQL Server Management Studio
    • Implement disaster recovery for SSIS
    • Configure SSIS security settings
    • Deploy SSIS packages by using DTUTIL
    • Summary
  5. Implementing an SSAS Solution
  6. Total Learning Time is 150  Minutes and module version is 1

    • Introduction
    • Implement cube
    • Storage modes
    • Implement processing options
    • Implement data mining structures
    • Query data mining structures by using DMX
    • Data Mining Model Viewers
    • Attribute relations
    • Translations
    • Actions
    • Calculated members
    • KPIs
    • Partitions
    • Aggregation
    • Summary
  7. Deploying and Configuring SSAS
  8. Total Learning Time is 120  Minutes and module version is 1

    • Introduction
    • Install Analysis Services
    • Implementing an SSAS Solution
    • Creating a Report Model Using Report Manager
    • Configure permissions and roles in SSAS
    • Deploy SSAS databases and objects
    • SSAS disaster recovery
    • Diagnose and resolve performance issues
    • Performance monitor counters
    • DMVs
    • Usage Based Optimization Wizard
    • Summary
  9. Creating Reports in SSRS
  10. Total Learning Time is 90  Minutes and module version is 1

    • Introduction
    • Creating a report in SQL Server Business Intelligence Development Studio
    • Using SQL Reporting Services to View Reports
    • Implement Specific Report Layout
    • Implement Report Items
    • Implement Interactivity in Reports
    • Drillthrough
    • Interactive Sorting
    • Summary
  11. Extending SSRS reports with code
  12. Total Learning Time is 50  Minutes and module version is 1

    • Introduction
    • Creating the SSRS report
    • Create the custom assembly
    • Referencing assemblies and building reports
    • Summary
  13. Parameters Caching and Snapshots in SSRS
  14. Total Learning Time is 90  Minutes and module version is 1

    • Introduction
    • Creating a report with Parameters
    • Report Caching
    • Report Snapshots
    • Working with subscriptions
    • Deploy an SSRS web farm
    • RS.exe utility
    • Migrate SSRS databases
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • Gain practical experience with real-world scenarios
  • Access to real hardware & software in real time
  • Experiment & put theory to practice
  • Includes exercises designed to prepare for exams.
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top