Learn to master ETL data integration with Pentaho kettle PDI

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Your first ETL example – table to table

Lecture 3: First ETL explained

Lecture 4: Second ETL example – file to table

Lecture 5: Thank you, some guide lines

Lecture 6: Materials of the course

Lecture 7: Download links of softwares

Chapter 2: Installations

Lecture 1: Installation Intro

Lecture 2: Install PDI

Lecture 3: Install JAVA

Lecture 4: Install MySql

Lecture 5: Install Dbeaver

Lecture 6: additionals for mysql8 and Dbeaver

Lecture 7: Database creation

Lecture 8: JDBC and connections

Chapter 3: PDI Walkthrough

Lecture 1: PDI Environment

Lecture 2: kettle.properties

Lecture 3: PDI jobs

Lecture 4: PDI shared xml

Chapter 4: The Project

Lecture 1: Dim Date

Lecture 2: Generate rows step

Lecture 3: Add sequence step

Lecture 4: Calculator Step

Lecture 5: Select Values step

Lecture 6: String cut step

Lecture 7: Concat field step

Lecture 8: String operation step

Lecture 9: Table ouptput step

Lecture 10: Dim date homework

Lecture 11: Dim date homework solution

Chapter 5: Dim time

Lecture 1: Dim time intro

Lecture 2: Dim time final result

Lecture 3: Cartesian step

Lecture 4: String operation step 2

Lecture 5: Java script step | constant step

Lecture 6: Filter rows step | table output step 1

Lecture 7: Filter rows step | table output step 2

Lecture 8: Dim time summary

Lecture 9: Dim time homework

Lecture 10: Dim time homework solution

Chapter 6: Dim Customers

Lecture 1: Dim customers intro

Lecture 2: Insert update step

Chapter 7: Dim film

Lecture 1: Dim film intro

Lecture 2: Dim film base

Lecture 3: Handling nulls

Lecture 4: Merge join step

Lecture 5: Stream lookup step

Lecture 6: De normalizer step

Lecture 7: Dim film colnclusion

Lecture 8: Dim film homework

Lecture 9: Dim film solution

Chapter 8: Dim store

Lecture 1: Dim store intro

Lecture 2: Lookup step part 1

Lecture 3: Lookup step part 2

Lecture 4: Insert update step

Lecture 5: Dim store homework

Lecture 6: Dim store homework solution

Chapter 9: Fact rentals

Lecture 1: Fact rental intro

Lecture 2: Lookups

Lecture 3: Date handling

Lecture 4: Fact rental payments

Lecture 5: Fact rental conclusion

Lecture 6: Fact rental homework

Lecture 7: Fact rental solution

Chapter 10: Main job

Lecture 1: The main job part 1

Lecture 2: The main job part 2

Lecture 3: Schedule the main job

Chapter 11: Theory

Lecture 1: Analytical structure

Lecture 2: Data source part 1

Lecture 3: Data source part 2

Lecture 4: Data warehouse

Lecture 5: Etl tools

Chapter 12: What's next

Lecture 1: Bonus lecture