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)
Teach online with
Install Mysql
Complete and Continue
Discussion
0
comments
Load more
0 comments