Data Warehousing with Microsoft SQL (SSIS)

DURATION:
5 Days
ID:
TFA-00026
PRICE
₦180,000.00

Address

3, Allen Lane, Capable People Africa Building, Allen Lane, Ikeja, Lagos State.   View map

Categories

Microsoft , Microsoft SQL

Data Warehouse with Microsoft SQL Server (SSIS) training course will show you how to implement a data warehouse platform to support a BI solution. The training course is designed for those who are interested in learning SQL Server 2012 or SQL Server 2014 and covers the new features in SQL Server 2014 but also the important capabilities across the SQL Server data platform.

Learning Objectives:

This 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 2012/2014/2016
  • Implement ETL with SQL Server Integration Services
  • Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Program Outline

Introduction to Data Warehousing

Planning Data Warehouse Infrastructure

Designing and Implementing a Data Warehouse

Columnstore Indexes

Implementing an Azure SQL Data Warehouse

Creating an ETL Solution

Implementing Control Flow in an SSIS Package

Debugging and Troubleshooting SSIS Packages

Implementing a Data Extraction Solution

Enforcing Data Quality

Master Data Services

Extending SQL Server Integration Services

Deploying and Configuring SSIS Packages

Consuming Data in a Data Warehouse

Prerequisite

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

Leave a Reply

Your email address will not be published. Required fields are marked *

Consulting

Training

Software Development

Project Management

TERIBITE CONSULTING

We are a privately-owned business incorporated by the Corporate Affairs Commission of Nigeria to provide ready made and tailored I.T., Management, Financial and Branding Consulting services and solutions to a broad spectrum of clients.

Opening Hours

Monday – Friday: 8:00 am – 5:00 pm

Saturday, Sunday: Closed

CONTACT

Email: info@teribiteng.com
Telephone: (+234) 0803 358 8649, 0908 069 9264
Address: 3, Allen Lane, Capable People Africa Building Allen, Ikeja, Lagos, Nigeria

TOP