$595.00$1,595.00 Software Assurance Training Vouchers Accepted On-Demand Learning

Clear
  • Overview

    On-Demand combines high-quality video, reading and knowledge checks in a self-paced format to help you build skills as your schedule allows all at once or five minutes at a time.

    Basic Package Standard Package Premium Package
    • 1-year access to training video
    • 1-year access to hands-on exercises, labs, games and practice tests*
    • Email Help Desk Support
    • *Labs and practices tests may not be available for certain courses
    • *Includes reading materials and study guides, but official vendor courseware not included
    • Includes digital license for official vendor courseware
    • 1-year access to training video
    • 1-year access to hands-on exercises, labs, games and practice tests*
    • Email Help Desk Support
    • *Labs and practices tests may not be available for certain courses
    • Standard Package plus:
    • Premium Certification Prep Package:
      • Lifetime License to premium online test simulator
      • Official Exam Voucher
    • 3 hours of Instructor Time:
      • One-on-one live instructor time geared towards your specific needs
      • Scheduled in 1-hour increments
    $595 or 2 SATVs $995 or 5 SATVs $1595 or 5 SATVs + $595

    Description

    About this Microsoft SQL Server On-Demand Training Course

    This Microsoft SQL Server On-Demand Training Course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

    Note: This Microsoft SQL Server On-Demand Training Course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform

    Audience Profile

    This Microsoft SQL Server On-Demand Training Course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:

    • Implementing a data warehouse.
    • Developing SSIS packages for data extraction, transformation, and loading.
    • Enforcing data integrity by using Master Data Services.
    • Cleansing data by using Data Quality Services.

    Prerequisites

    This Microsoft SQL Server On-Demand Training Course requires that you meet the following prerequisites:

    • At least 2 years€™ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

    At Microsoft SQL Server On-Demand Training Course Completion

    After completing this Microsoft SQL Server On-Demand Training Course, students will be able to:

    • Describe data warehouse concepts and architecture considerations.
    • Select an appropriate hardware platform for a data warehouse.
    • Design and implement a data warehouse.
    • Implement Data Flow in an SSIS Package.
    • Implement Control Flow in an SSIS Package.
    • Debug and Troubleshoot SSIS packages.
    • Implement an ETL solution that supports incremental data extraction.
    • Implement an ETL solution that supports incremental data loading.
    • Implement data cleansing by using Microsoft Data Quality Services.
    • Implement Master Data Services to enforce data integrity.
    • Extend SSIS with custom scripts and components.
    • Deploy and Configure SSIS packages.
    • Describe how BI solutions can consume data from the data warehouse.