SQL Server Integration Services (SSIS) Basic kursus

You will learn

In course in Integration Services (SSIS) you will learn how to create ETL (Extract Transform and Load) solutions with Microsoft SQL Server Integration Services. You will learn how to extract data from different data sources and consolidate and cleanse the data before loading it into dimension - and fact tables in a Data Warehouse or Data Mart. You will also learn how to create robust packages and projects with logging and error handling and you will learn how to design and plan a deployment strategy for your projects. You will also learn how to manage and configure a SSIS catalog and secure access to your projects.

After completing this course you will be able to:

  • Create SQL Server Integration Services solutions
  • Create and implement Control Flows
  • Create and implement Data Flows
  • Create Event Handlers
  • Manage error handling
  • Design and plan a Deployment Strategy
  • Schedule Execution of Packages
  • Secure Access to Packages and Projects

You get

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off cause Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.

After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This course is a part of 4D's unique collection of English conducted courses and the primary audience for this course are Business Intelligence Developers who wants to be able to implement and maintain business intelligence solutions.

This is a technical course and we expect that you have attended our "Business Intelligence Grundlæggende" and SQL Basic course or have acquired similar experience about business intelligence, dimensional data modelling and SQL. Knowledge of programming with e.g. VB scripting is an advantage as well.

Course Details

Module 1 - Introducing Microsoft SQL Server Integration Services

In this module you will get an overview of SQL Server Integration Services and the ETL process. You will be introduced to SQL Server Data Tools and learn how to create SQL Server Integration Services projects.

The following will be covered:
  • The ETL Process
  • SQL Server Data Tools
  • SQL Server Integration Services Projects
  • SQL Server Integration Services Packages
  • SQL Server Integration Services Architecture

Module 2 – Introducing the Control Flow
In this module you will learn how to design and implement control flows in SQL Server Integration Services packages. You will learn how to connect tasks with precedence constraints and you will learn how to connect to data with connection managers. You will also learn how to use create flexible and dynamic packages using variables, parameters, and expressions. You will also learn how to use the Execute SQL Task with parameters.

The following will be covered:
  • Connection Managers
  • Precedence Constraints
  • Variables
  • Parameters
  • Introduction to Expressions
  • Execute SQL Task

Module 3 - Control Flow Tasks
In this module you will learn how to use the most commonly used Control Flow Tasks.

The following will be covered:
  • Script Task
  • Send Mail Task
  • File System Task
  • For Loop Containers
  • Expression Task

Module 4 – Introducing the Data Flow

In this module you will learn how to use different types of data sources and you will learn about the different types of data destinations. You will also learn how to use some of the most commonly used data transformation tasks and you will learn some best practices for data transformations and implementing data flows.

The following will be covered:
  • Script Task
  • Send Mail Task
  • File System Task
  • For Loop Containers
  • Web Service Task

Module 5 – Advanced Data Flows
In this module you will learn how to use some of the advanced data transformation tasks. You will learn how to use data transformation tasks that are typically used for data warehouse solutions, like inserting and updating data in dimension - and fact tables.

The following will be covered:
  • The Lookup Transformation Task
  • Union All and Merge
  • Merge Join
  • Fuzzy Lookup

Module 6 – Incremental Data Loads
In this module you will learn how to implement and handle incremental data loads (delta loads). You will learn how to use different techniques like the slowly changing dimension task and how to use a datetime column when loading data to fact tables.

The following will be covered:
  • Data Warehouse Load Cycle
  • Introduction to Change Data Capture (CDC)
  • Slowly Changing Dimensions
  • MERGE statement

[oModule 7 - Debugging, Logging, and Error Handling [/o]In this module you will learn how to implement logging and error handling in SQL Server Integration Services packages. You will learn how to handle errors both in the control flow and the data flow.

The following will be covered:
  • Debugging
  • Error Handling in Control Flow
  • Error Handling in Data Flow
  • Event Handlers
  • Custom Logging
Module 8 – Checkpoints and Transactions
In this module you will learn how to use checkpoints as restarting points in packages. You will also learn how to group data modifications with transactions.

The following will be covered:
  • Checkpoints
  • Transactions

Module 9 – Deployment
In this module you will learn how to design and plan a deployment strategy for your projects. You will also learn how to create and configure a SSIS Catalog and you will learn how to use parameters and user defined environments on the production server.

The following will be covered:
  • Package Deployment Model
  • Project Deployment Model
  • SSIS Catalog
  • Configuring the SSIS Catalog
  • Parameters
  • Environments

Module 10 - Administration and Security
In this module you will learn how to secure access to your projects in the SSIS Catalog. You will also learn how to schedule execution of your packages and how to configure execution context.

The following will be covered:
  • SQL Server Integration Services Security
  • Scheduling packages
  • Proxy Accounts and Execution Context

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K