MOC On-Demand: Implementing a Data Warehouse with Microsoft SQL Server 2012-14

The following is a list of available MOC On-Demand: Implementing a Data Warehouse with Microsoft SQL Server 2012-14 classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15


Course Number: 20463MOD

Description

This on-demand 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.

This 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

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Any labs associated with courses are delivered on the Microsoft Labs Online (MLO) platform via web browser. Students launch the labs directly from within the course; no additional set-up is required.

Please contact ISInc to purchase your license, each class license is valid for 3 months. Licenses are non-refundable.

Visit www.Microsoft-On-Demand.com for more information and ordering options.

Prerequisites

This 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.

List Price

$995.00