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-463: Implementing a Data Warehouse with SQL Server 2012

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

Overview

The 70-463 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012 Data Warehouse concepts. By completing the lab tasks you will improve your practical skills in implementing Microsoft SQL Server data warehouse, managing connection manager's, data flows, deploy SSIS solutions, control flows, data loads, data quality services, data management solutions and managing data quality. These same tasks will help you understand the objectives and competencies required by the Implementing a Data Warehouse with Microsoft SQL Server 2012 certification exam. Exam retired July 31, 2015.

Vendor:   Microsoft
Vendor Id:   70-463
Version:   1
Level:   Intermediate
Learning Time:   830  Minutes

Exercises

  1. Design and Implement a Data Warehouse
  2. Total Learning Time is 40  Minutes and module version is 4

    Exercises:
    • Introduction
    • Working with Dimensions
    • Working with Fact Tables
    • Summary
  3. Define Connection Managers
  4. Total Learning Time is 50  Minutes and module version is 4

    Exercises:
    • Introduction
    • Configuring Flat File Connection Manager
    • Configuring OLE DB Connection Manager
    • Creating ADO.NET Connection Manager
    • Summary
  5. Implementing Data Flow
  6. Total Learning Time is 70  Minutes and module version is 11

    Exercises:
    • Introduction
    • Data Flow Task with Transformations
    • Adding and Configuring a Lookup Transformation
    • Using Fuzzy Lookup Transformation
    • Adding and Configuring Data Correction Transformation
    • Optimizing Integration Services Packages
    • Summary
  7. Managing SSIS Package Execution
  8. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Executing SSIS Packages using SQL Server Agent
    • Executing SSIS Packages using SQL Server Management Studio and PowerShell Script
    • Executing SSIS Packages using SSIS Utilities
    • Validating SSIS Projects and Packages using SQL Server Management Studio
    • Summary
  9. Implementing Script Tasks
  10. Total Learning Time is 30  Minutes and module version is 4

    Exercises:
    • Introduction
    • Configuring and Adding a Script Task to Control Flow
    • Summary
  11. Implement Control Flow
  12. Total Learning Time is 80  Minutes and module version is 2

    Exercises:
    • Introduction
    • Using SSIS Tasks to Solve a Problem and Debugging the Control Flow through Breakpoints
    • Working with Checkpoints
    • Using Data Profiling Tasks
    • Working with Loop Containers
    • Working with Sequence Containers by Implementing Package Transactions
    • Creating SSIS Package Template
    • Summary
  13. Implement Data Load Options
  14. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Performing Data Loads
    • Incremental Data Load
    • Performing Incremental Data Load with Change Data Capture
    • Summary
  15. Troubleshoot Data Integration Issues
  16. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Implementing Data Viewer
    • Troubleshooting Data Quality
    • Summary
  17. Install and Maitain SSIS Components
  18. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Install SQL Server 2012 Integration Services and Set up Service Accounts
    • Configure Integration Services
    • Summary
  19. Implement Auditing Logging and Event Handling
  20. Total Learning Time is 60  Minutes and module version is 2

    Exercises:
    • Introduction
    • Implement Row Level Auditing in an SSIS Package
    • Configuring SSIS Container for Event Logging
    • Create Custom Logging to Track Errors using Event Handlers
    • Implement Alerts and Notification Mechanism
    • Summary
  21. Deploy SSIS Solutions
  22. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Deploy SSIS Package using the Deployment Wizard
    • Create and Configure SSISDB Catalog and Inspect SSIS Package Metadata
    • Use DTUTIL and Deploy Packages on Multiple Servers
    • Summary
  23. Install and maintain Data Quality Services
  24. Total Learning Time is 40  Minutes and module version is 2

    Exercises:
    • Introduction
    • Install Data Quality Services and Assign DQS Roles
    • Enable Data Quality Services Feature
    • Summary
  25. Implement Master Data Management Solutions
  26. Total Learning Time is 70  Minutes and module version is 2

    Exercises:
    • Introduction
    • Install and Configure Master Data Services
    • Enable Master Data Services Feature
    • Using MDS Configuration Manager
    • Create MDS Model and Basic Objects
    • Populate Entities in an MDS Model and Deploy the Model
    • Summary
  27. Manage Master Data Management Solutions
  28. Total Learning Time is 50  Minutes and module version is 3

    Exercises:
    • Introduction
    • Create MDS Model and its Objects
    • Import Data using Staging Process
    • Export MDS Data by Creating Subscription Views
    • Summary
  29. Create a Data Quality Project to Clean Data
  30. Total Learning Time is 50  Minutes and module version is 2

    Exercises:
    • Introduction
    • Working with Data Quality Services to Clean Data
    • Using DQS Cleansing Transformation
    • Performing Data Match using Data Quality Services
    • Summary
  31. Manage Data Quality Project to Clean Data
  32. Total Learning Time is 50  Minutes and module version is 8

    Exercises:
    • Introduction
    • Install MDS Add-in for Excel
    • View Master Data in Excel
    • Use Data Quality Services to Match MDS Data in Excel
    • Summary
LIVE LAB Access to real hardware and software in real time and with full administrator privileges to gain real-world practical experience.
  • 830+ Minutes of practical exercises
  • 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