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

01 - Introduction

001 Introduction

002 Your first ETL example - table to table

003 First ETL explained

004 Second ETL example - file to table

005 Thank you, some guide lines

006 ETL-tutorial-files.zip

006 Materials of the course

007 Download links of softwares.html

02 - Installations

001 Installation Intro

002 Install PDI

003 Install JAVA

004 Install MySql

005 Install Dbeaver

006 additionals for mysql8 and Dbeaver

007 Database creation

008 JDBC and connections

03 - PDI Walkthrough

001 PDI Environment

002 kettle.properties

003 PDI jobs

004 PDI shared xml

04 - The Project

001 Dim Date

002 Generate rows step

003 Add sequence step

004 Calculator Step

005 Select Values step

006 String cut step

007 Concat field step

008 String operation step

009 Table ouptput step

010 Dim date homework

011 Dim date homework solution

05 - Dim time

001 Dim time intro

002 Dim time final result

003 Cartesian step

004 String operation step 2

005 Java script step constant step

006 Filter rows step table output step 1

007 Filter rows step table output step 2

008 Dim time summary

009 Dim time homework

010 Dim time homework solution

06 - Dim Customers

001 Dim customers intro

002 Insert update step

07 - Dim film

001 Dim film intro

002 Dim film base

003 Handling nulls

004 Merge join step

005 Stream lookup step

006 De normalizer step

007 Dim film colnclusion

008 Dim film homework

009 Dim film solution

08 - Dim store

001 Dim store intro

002 Lookup step part 1

003 Lookup step part 2

004 Insert update step

005 Dim store homework

006 Dim store homework solution

09 - Fact rentals

001 Fact rental intro

002 Lookups

003 Date handling

004 Fact rental payments

005 Fact rental conclusion

006 Fact rental homework

007 Fact rental solution

10 - Main job

001 The main job part 1

002 The main job part 2

003 Schedule the main job

11 - Theory

001 Analytical structure

002 Data source part 1

003 Data source part 2

004 Data warehouse

005 Etl tools

12 - Whats next

001 Bonus lecture.html

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy