Masterclass: Accelerated SQL Server 2016 Integration Services with Herbert Albert

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.

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 the trainer

Herbert Albert is a Mentor with SolidQ. Since version 6.0 he works with SQL Server as developer and trainer. He helped developing official Microsoft courses about Administering and Developing SQL Server as well as the SolidQ training “Troubleshooting and Performance Tuning for SQL Server.” Furthermore, he coo-authored the “Upgrade Technical Reference Guide” and was technical editor of a couple of Microsoft Press books. As a trainer, consultant and speaker he is focused on T-SQL Programming, Performance Tuning, High Availability and Integration Servers- In these areas he delivers projects successfully Europe-wide.

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

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

Course outline

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

Prerequisites

  • Basic experience in business intelligence solutions and SQL Server
  • No prior experience with SQL Server SSIS is required

Boka kursen

Boka din plats redan idag.

Om kursen

Pris: 32 950,00 kr

exklusive moms

Längd 4 dagar
Kurskod MC043
Boka kursen

Välj ort och kursstart

29 januari

Kunduppgifter

Kursanmälan är bindande. För mer information och avbokningsregler se våra allmänna villkor.