SQL Server Integration Services

5 days
SSIS - Version:1
Description
This course teaches how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages. The course is based on SQL Server 2019, but it is relevant also for previous versions of SQL Server.
Intended audience
The course is intended for SQL Server developers, administrators and analysts who need to migrate and transform data amongst diverse platforms. Students should be familiar with the following topics: Transact-SQL SQL Server Agent SQL Server Security
▼Expand All

  • Introduction to SQL Server Integration Services
    • SSIS Historical Overview
    • SSIS Architecture
    • Tools of the Trade
    • Creating a Simple Package

  • SSIS Tasks
    • Tasks Overview
    • Data Preparation Tasks
    • RDBMS Server Tasks
    • Workflow Tasks
    • Administration Tasks
    • Script Task (.NET)

  • Working with Containers
    • Sequence Containers
    • Groups
    • For Loop Container
    • Foreach Loop Container

  • The Data Flow
    • Understanding the Data Flow
    • Sources & Destinations
    • Common Transformations
    • Other Transformations

  • Using Variables, Parameters and Expressions
    • Dynamic Package Objects
    • Understanding Data Types
    • Using Variables and Parameters
    • Working with Expressions

  • Loading a Data Warehouse
    • Data Profiling
    • Data Extraction and Cleansing
    • Dimension Table Loading
    • Fact Table Loading
    • SSAS Processing

  • Accessing Heterogeneous Data
    • The Connection Managers
    • Excel and Access
    • Oracle
    • Using XML and Web Services
    • Flat Files
    • Other Heterogeneous Sources

  • Scripting in SSIS
    • Introduction to Scripting in SSIS
    • The Script Component
    • The Script Task

  • Error and Event Handling
    • Package Transactions
    • Using Precedence Constraints
    • Event Handling
    • Breakpoints
    • Error Rows
    • Logging

  • SSIS Administration
    • Deployment Models
    • Security
    • Scheduling Packages
    • Monitoring Package Executions
    • High Availability and Disaster Recovery
    • Scale Out
  • Be familiar with SSIS architecture and components
  • Learn how to implement SSIS packages
  • Learn how to implement logging in an SSIS package
  • Be able to debug and implement error handling in an SSIS package
  • Learn how to implement checkpoints and transactions in an SSIS package
  • Learn how to configure and deploy an SSIS package
  • Understand how to manage and secure an SSIS package
Contact Us
03-6176666
03-6176677 info@sela.co.il

SEND