Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

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
Johannesburg
South Africa 1684

You are here

courses popup callback

LIVE LAB:

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.

Overview

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

Exercises

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

    Exercises:
    • 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

    Exercises:
    • 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

    Exercises:
    • 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

    Exercises:
    • 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

    Exercises:
    • 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

    Exercises:
    • 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

    Exercises:
    • 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