Training

Accelerated SQL Server 2016 Integration Services.

About This Course

Course Code
TPISACL16

Course Type
Specialist

Vendor
SolidQ

Duration
4 Days

RRP
£2,235.00

Course Overview
Download

Overview

This 4-day instructor led training focuses on developing and managing SSIS 2012 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.

Target Audience

This course is intended for database professionals that are responsible for ETL or DBA activities related to data processing, data architecture planning, or SSIS administration.

The target audience for this session is IT professionals, DBAs and developers who want to learn the details of how to use SSIS to accomplish data integration, data warehouse loading, and how to administer SSIS through the development lifecycle to production.

Objectives

Course Outline

SECTION A: DW and SSIS Overview and SSIS Core Features

Module 01: SSIS Overview and Core Features


Module 02: Data Warehousing


Module 03: SSIS Control Flow Objects and Features


Module 04: Extracting, Transforming and Loading data using SSIS Data Flows


SECTION B: Applying SSIS to Common Operations

Module 05: Working with Files, Importing and Exporting File Data


Module 06: Optimizing Data Extraction and Data Loading


Module 07: Data Quality and Cleasing


Module 08: Advanced Enterprise Information Management


SECTION C: Applying SSIS in BI and Data Warehouse Solutions

Module 09: Dimension ETL with SSIS


Module 10: Fact ETL with SSIS


Module 11: Project Deployment Model: Execution and Reporting


Module 12: Processing SSAS Objects in SSIS


SECTION D: Deployment

Module 13: Project Deployment


Module 14: Package Deployment


SECTION F: SSIS Solution and Performance Considerations

Module 15: Transactions and Restartability


Module 16: Optimization and Scalability

Prerequisites

Dates & Prices

Monday 20th September 2021

£2,235.00

Monday 20th September 2021

£2,235.00

Monday 6th December 2021

£2,235.00

Monday 6th December 2021

£2,235.00