Learn to master ETL data integration with Pentaho kettle PDI

Learn how to develop ETL with Pentaho PDI 8 (2nd edition) 2020 #1 - full Project, hands on, tips and tricks and homework

4.45 (285 reviews)
Udemy
platform
English
language
IT Certification
category
2,465
students
10 hours
content
Apr 2020
last update
$69.99
regular price

What you will learn

Install and Set up PDI and environment

Transformations and Jobs

Connect to data sources

Introduce Sakila case study and goals

Develop our case study hand-on

Learn the building blocks

schedule the ETL

Theory of data integration

Description

Pentaho kettle Development course with Pentaho 8 - 08-2019 #1

  • Learn how to Develop real pentaho kettle projects

  • Get a lot of tips and tricks.

  • Become master in transformation steps and jobs

  • Know how to set Pentaho kettle environment

  • Be familiar with the most used steps of Pentaho kettle

  • Solve issues

  • Start making money as an ETL developer


What is the target audience?

  • SQL developers, ETL developers, code developers (Python, PHP...), Automation developers, BI developers, software project managers and anyone who like to understand what is ETL

  • the Pentaho kettle course is meant for people who have some background with SQL syntax, Queries, and database design, you don't need to be expert on that, I will guide you through

  • in case you don't know SQL at all, I suggest you take a course-specific for that before you enroll in this course

  • this course is only for students who are serious in working hands-on, practice and some more practice. it is not reading or watching. you will be an expert but only if you try everything I show by your self

Content

Introduction

Introduction
Your first ETL example - table to table
First ETL explained
Second ETL example - file to table
Thank you, some guide lines
Materials of the course
Download links of softwares

Installations

Installation Intro
Install PDI
Install JAVA
Install MySql
Database creation
Install Dbeaver
JDBC and connections

PDI Walkthrough

PDI Environment
kettle.properties
PDI jobs
PDI shared xml

The Project

Dim Date
Generate rows step
Add sequence step
Calculator Step
Select Values step
String cut step
Concat field step
String operation step
Table ouptput step
Dim date homework
Dim date homework solution

Dim time

Dim time intro
Dim time final result
Cartesian step
String operation step 2
Java script step | constant step
Filter rows step | table output step 1
Filter rows step | table output step 2
Dim time summary
Dim time homework
Dim time homework solution

Dim Customers

Dim customers intro
Insert update step

Dim film

Dim film intro
Dim film base
Handling nulls
Merge join step
Stream lookup step
De normalizer step
Dim film colnclusion
Dim film homework
Dim film solution

Dim store

Dim store intro
Lookup step part 1
Lookup step part 2
Insert update step
Dim store homework
Dim store homework solution

Fact rentals

Fact rental intro
Lookups
Date handling
Fact rental payments
Fact rental conclusion
Fact rental homework
Fact rental solution

Main job

The main job part 1
The main job part 2
Schedule the main job

Theory

Analytical structure
Data source part 1
Data source part 2
Data warehouse
Etl tools

What's next

Bonus lecture

Screenshots

Learn to master ETL data integration with Pentaho kettle PDI - Screenshot_01Learn to master ETL data integration with Pentaho kettle PDI - Screenshot_02Learn to master ETL data integration with Pentaho kettle PDI - Screenshot_03Learn to master ETL data integration with Pentaho kettle PDI - Screenshot_04

Reviews

Lynn
July 18, 2023
This is great for doing a data warehouse, but my need is for transformations between various sources to .xml or .csv formats.
Lotte
July 4, 2023
hard to understand as I feel you are jumping around 'you just do this and look here - and voila' I have no clue were information used for this excersixe came from
Nour
May 2, 2023
poor explanation and outdated course. spend a lot of time installing the necessary software. The teacher jumps from topic to topic and there is no logical structure in the course.
Alberto
March 19, 2023
Antes de empezar el curso no tenía conocimientos en ETL. Ahora considero que tengo unas bases sólidas para evolucionar
Archisman
May 4, 2022
More examples required, steps like 'Block this step' and 'Block this step until steps finish' should have been explained. Performance improvement and optimisation features should have been included.
Sandro
November 25, 2020
the dimensions are explained, but many sources don't come with a update field at all (considering flat file sources)
Karamveersingh
July 2, 2020
The course is decent enough. But still there is lot to be learned as not everything is covered in the course was expecting more contend.The instructor has good knowledge of Pentaho tool.
Richard
June 24, 2020
It is an excellent course which explains the basic concepts and demonstrates them through real-life exercises.

Charts

Price

Learn to master ETL data integration with Pentaho kettle PDI - Price chart

Rating

Learn to master ETL data integration with Pentaho kettle PDI - Ratings chart

Enrollment distribution

Learn to master ETL data integration with Pentaho kettle PDI - Distribution chart
2305334
udemy ID
4/3/2019
course created date
10/16/2019
course indexed date
Bot
course submited by