This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn ETL with Pentaho kettle PDI - dev course #1
Welcome to the course
Thank you, some guide lines (3:02)
Your first ETL example - table to table (6:39)
First ETL explained (6:22)
Second ETL example - file to table (9:03)
Materials of the course (1:04)
Installations
Installations intro (1:36)
Download links of softwares
Install PDI (4:08)
Install JAVA (3:37)
Install Mysql (4:09)
Databases creation (8:21)
Install navicat (4:07)
Jdbc and connection (5:28)
Install notepad (1:03)
PDI Walkthrough
PDI Environment (11:20)
PDI jobs (7:52)
kettle.properties (8:35)
PDI shared.xml (2:42)
The Project
The project (6:06)
homework database (5:08)
Homework PDF
dim date
Dim date intro (2:24)
Generate rows step (5:49)
Add sequence step (1:49)
Calculator step (5:47)
Select values step (7:16)
String cut step (2:59)
Concat fields step (2:38)
String operation step (2:58)
Table output step (9:48)
Dim date homework (7:49)
Dim date homework answers (21:54)
Dim Time
Dim time intro (0:47)
Dim time final result (2:19)
Cartesian step (8:17)
String operation step (5:39)
Javascript / constant steps (8:30)
filter rows / table output steps part 1 (12:07)
filter rows / table output steps part 2 (15:15)
Dim time conclusion (4:13)
Dim time homework (9:50)
Dim time homework answers (32:34)
Dim Customers
Dim customers intro (4:21)
insert update step (21:30)
Dim Film
Dim film intro (7:27)
Dim film base (6:46)
Handling nulls (6:10)
Merge join step (5:27)
Stream lookup step (3:27)
De normilzer step (6:56)
Dim film consclution (9:39)
Dim film homework (3:27)
Dim film homework answers (32:35)
Dim store
Dim store intro (4:19)
lookup step part 1 (15:45)
lookup step part 2 (11:04)
insert update step (9:42)
Dim store homework (2:55)
Dim store homework answers (7:35)
Fact rental
Fact rentals intro (9:05)
lookups (10:14)
dates handling (18:32)
Fact rental payments (16:03)
Fact rental conclusion (3:33)
Fact rental homework (8:56)
Fact rental homework answers (2:16)
Main job
The main job part 1 (11:29)
The main job part 2 (7:11)
Schedule the main job (14:20)
Theory
analytical structure (12:33)
data sources part 1 (14:11)
data sources part 2 (16:46)
data warehouse (5:37)
etl_tools (17:59)
Theory section comments
Whats next...
Congrats and surprise (0:27)
Dim film homework answers
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock