SCN GmbH

Pentaho Data Integration

Seminar / Training Pentaho Data Integration

Module 1: Introduction to Pentaho Data Integration

Lesson 1: Goals & Class Logistics

Lesson 2: What is Pentaho Data Integration (PDI)?

Module 2: Transformation Basics

Lesson 1: Learning the PDI User Interface

Lesson 2: Creating Transformations

Lesson 3: Error Handling and Logging Introduction

Lesson 4: Introduction to Repositories

Module 3: Reading & Writing Files

Lesson 1: Input & Output Steps

Lesson 2: Parameters & kettle.properties

Module 4: Working with databases

Lesson 1: Connecting to a database & Explore

Lesson 2: Tables Input & Output

Lesson 3: Inserting, Updating & Deleting Steps

Lesson 4: Data Cleansing

Lesson 5: Using parameters and arguments in SQL

Module 5: Data Flows & Lookup

Lesson 1: Copying and distributing data

Lesson 2: Lookups

Lesson 3: Merging Data

Module 6: Calculations

Lesson 1: Using the Group By Step

Lesson 2: Calculators

Lesson 3: Regular Expression

Lesson 4: Custom Java Expression

Lesson 5: JavaScript

Module 7: Orchestrating Jobs

Lesson 1: Introduction to Jobs

Lesson 2: Sending Alerts

Lesson 3: Looping Conditions

Lesson 4: Running Jobs from a Terminal Window

Module 8: Scheduling

Lesson 1: Setting up the Scheduler

Lesson 2: Monitoring Scheduled Tasks

Module 9: Examining Data Integration Repositories

Lesson 1: The Pentaho Data Integration Repository

Module 10: Detailed Logging

Lesson 1: Detailed logging of the entire execution

This seminar has the level "User / Setup".

If you are not sure if this course is the right level for you, you can discuss this with the trainer in advance.

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

Réservation


Das Seminar wurde auf die Merkliste gesetzt


Das von Ihnen gewählte Seminar wurde bereits auf die Merkliste gesetzt


Bitte wählen Sie einen freien Termin aus


Bitte geben Sie Ihren Wunschtermin im Format tt.mm.jjjj ein


Bitte wählen Sie einen freien Termin aus


Bitte geben Sie den gewünschten Termin im Format tt.mm.jjjj der Schulung ein

Duration 3 Days, approx. 6h/Day
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 948.707,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Choose a free date for Aba




















Duration 3 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 2.484.710,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Enter your preferred date for Aba



Duration 3 Days, approx. 6h/Tag
1. Day: 10:00 Clock, more from 09:00 Clock
Price ₦ 948.707,00 plus VAT.
Seminar documents Original documentation of the manufacturer on data carrier / download / weblink
Certificate of attendance yes, of course
Barrier free access Available at most locations
Catering Cold / hot drinks, lunch (optional vegetarian) - not for company and online seminars
Support 3 calls included in the seminar price
Methods Lecture, demonstration, practical exercises on the system
Seminar types With trainer on site: Public or in-house - Alternatively orderable as webinar
Implementation guarantee yes, from 2 participants, max. 8 participants, Details

Please select a free date