+7 (495) 728-2952
System Center Configuration Manager

Microsoft -> Microsoft SQL Server 2016 | 2014 | 2012 | 2008

: 20767

: Microsoft


5 . | 40 . .


:  29900 .

Busines Intelligence Developer
Business Intelligence Developer
Database Administrator


This 5-day instructor led 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 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

After completing this course, students will be able to:

Describe the key elements of a data warehousing solution

Describe the main hardware considerations for building a data warehouse

Implement a logical design for a data warehouse

Implement a physical design for a data warehouse

Create columnstore indexes

Implementing an Azure SQL Data Warehouse

Describe the key features of SSIS

Implement a data flow by using SSIS

Implement control flow by using tasks and precedence constraints

Create dynamic packages that include variables and parameters

Debug SSIS packages

Describe the considerations for implement an ETL solution

Implement Data Quality Services

Implement a Master Data Services model

Describe how you can use custom components to extend SSIS

Deploy SSIS projects

Describe BI and common BI scenarios

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

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.

: , . . 18 . 1

. +7 (495) 728-2952

Email: edu@ht-edu.ru

© 2012-2017 Hi-TECH Academy