Data Integration in Microsoft SSIS

Duration: 24 hours / 3 days

Knowledge: Intermediate

Potential trainer(s): Tomislav Hlupić, Tomislav Grudiček

Language: Croatian, English

Possible locations: PI EDU center, At client premises, Virtual education

Training Data Integration in Microsoft SSIS is designed to enable data integration, such as the Extract-Transform-Load (ETL) process, which plays an important role in the data storage process.

Date 1
From 06/11/2023
to 08/11/2023
Duration: 24 hours / 3 days
Price
*
585.00 EUR
4407.68 HRK
* Price per attendee, price without VAT 25%, conversion rate HRK > EUR 7,53450
Early bird price
**
555.75 EUR
4187.30 HRK
** For applications until 20/10/2023, we grant a 5% discount
Apply now
Choose the type of application, provide any optional details and we will contact you back soon.

Company
Individual
I would like more information
By submitting this form, you agree that we may use the data provided to contact you with the information related to your request/submission and products and services of Poslovna inteligencija. You can unsubscribe from Poslovna inteligencija marketing emails at any time by clicking the unsubscribe link in the email. For more information, please see our Privacy Policy.
Please don't insert text in the box below!

The fields marked with * are required

Overview

Training Data Integration in Microsoft SSIS is designed to enable data integration, such as the Extract-Transform-Load (ETL) process, which plays an important role in the data warehousing process. In training, the principles of data integration, basic data transfer and transformation models, data flow management, error management, testing and the principle of extracting data from sources will be presented. Complete exercises will take place on the Microsoft SQL Server database, the market leader in the database market for the last ten years.

Audience

The training is intended for users who have at least basic knowledge of SQL (advanced knowledge is recommended) and use or introduce systems for data integration. It is desirable to know the basics of data storage, but it is not a necessary condition.

What you will learn

After the training, the participant will be ready to create his own integration package in Microsoft SQL Server Integration Services using best practices.

Syllabus

  • 1. Introduction to ETL process

    In this module, you will learn the basics of the ETL process, explain each step in the processes and their role in data warehousing.

  • 2. Data flow

    Through the module the participants will master the basics of data flow, data collection and transfer principles and data transformation within the data flow. An introduction to the module is an overview of SSIS architecture, how to use SSIS, and the importance of reviewing source data.

    • Workshop
  • 3. Control flow

    In the module student will learn data flow management using knowledge from the past module, creating dynamic packages using parameters and variables, and using different containers for advanced data flow management.

    • Workshop
  • 4. Error handling and debugging

    In this module students will master the knowledge of packet debugging, ways of tracking performance, changing data, and writing down different events during packet execution. In addition, the module includes an upgrade over data by adding bug management.

    • Workshop
  • 5. Implementation of data extraction

    This module covers the data extraction area as a part of the ETL process, the data collection principle in the data warehouse, incremental ETL process models, and architecture. Data extraction models include data values, Change Data Capture Process and Change Tracking Processes.

    • Workshop
How can I register for this training?

You can officially register for the training via the registration form at the top of this page. After successfully sending the application, we will get back to you within 24 hours of receiving the application.

I have not received any feedback from you. Who should I contact?

Mistakes in communication always happen, and if we don’t answer you, contact us directly at birdacademy@inteligencija.com

Can training be paid in several installments?

We currently do not support payment in multiple installments.

I don't live in Zagreb, but I would like to attend the training virtually. Is there such a possibility?

Of course, all our trainings can be followed virtually.

Is there a discount for students?

Students are entitled to a 10% discount on the price shown on this page.

I don't have my own laptop for this training. Do you provide me with a computer for training?

BIRD Academy provides a computer, lunch, coffee and water for each participant. We strive to be the best host possible in every segment!

BIRD Academy Trainings

Crafted by the Data Analytics experts