Accelerated SQL Server Integration Services with Dejan Sarka

This 4-day instructor led training focuses on developing and managing SSIS 2016 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.

Kurskod

MC043

Pris

35450 kr (exklusive moms)

Längd

4 dagar

Ort och startdatum

Hålls på begäran

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.

About Dejan Sarka

Dejan Sarka focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of nine books about databases and SQL Server and a frequent speaker many local and international events, such as PASS, TechEd, and DevWeek.

Target Audience and Prerequisites

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

Basic experience in business intelligence solutions and SQL Server Server is recommended as prerequisite. No prior experience with SQL Server SSIS is required.

Course Objectives

Create and develop new SSIS projects and packages
Determine when to use project mode versus package mode
Apply SSIS to file and data management
Understand and Apply ETL Concepts in SSIS including dimensions and fact table ETL and loading SSAS dimension and cubes
Administer SSIS for server deployment and production execution

Detaljerad information

Section A: DW and SSIS Overview and SSIS Core Features

Module 01: SSIS Overview and Core Features

Introduction to business intelligence
Microsoft tools for BI
Introduction to data integration
SSIS features overview

Module 02: Data Warehousing

Dimensional modeling
Optimizing a dimensional database
Data preparation for advanced analytics

Module 03: SSIS Control Flow Objects and Features

What is Control Flow
Control Flow Concepts
Control Flow Objects
Control Flow Features

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

The SSIS Data Flow Task
Data Flows and Data Paths
Data Connections and Connection Managers
Data Flow Components

Section B: Applying SSIS to Common Operations

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

Using SSIS to Automate File System Maintenance
Extracting Data from Files
Loading Data into Files
Excel Considerations

Module 06: Optimizing Data Extraction and Data Loading

Data Extraction Optimization Essentials
Determining the „Delta“
Change Tracking
Change Data Capture
Data Loading Optimization Essentials

Module 07: Data Quality and Cleansing

Data quality
Data profiling
Data Quality Services
Fuzzy matching

Module 08: Advanced Enterprise Information Management

Script task and Script Component
Text mining
Advanced Analysis and SSIS

Section C: Applying SSIS in BI and Data Warehouse Solutions

Module 09: Dimension ETL with SSIS

Dimension ETL Theory
SQL Server Temporal Tables
SSIS Slowly Changing Dimension Wizard
Custom Dimension ETL

Module 10: Fact ETL with SSIS

Fact Table ETL Theory
Data preparation for fact tables
Advanced concepts

Module 11: Introducing Personal Enterprise Information Management

Power Pivot
Power Query

Module 12: Processing SSAS Objects in SSIS

SSAS tabular and multidimensional
Processing methods in SSIS
Dynamic processing and partition creation

Section D: Deployment

Module 13: Project Deployment

Project Deployment Model
Deployment to the SSISDB Catalog
Administration, Security, Configuration
Execution
Monitoring
The Master Package Concept

Module 14: Package Deployment

Package Deployment Model
Deployment to the SSIS package store
Administration, Configuration, and Security
Execution
Monitoring and Logging

Section F: SSIS Solution and Performance Considerations

Module 15: Transactions and Restartability

Using Breakpoints in SSDT
Implementing Transactions in SSIS
Using SQL Server Database Snapshots
Restartability of SSIS Packages
Responding to Events

Module 16: Optimization and Scalability

Leveraging SSIS and Transact-SQL
Data Flow Engine Internals
SSIS Optimization Techniques
SSIS Performance Troubleshooting