Learn to master ETL data integration with Pentaho kettle PDI

Focused View

Itamar Steinberg (inflow systems)

9:59:29

26 View

01 - Introduction

001 Introduction.mp4

05:27

002 Your first ETL example - table to table.mp4

06:39

003 First ETL explained.mp4

06:22

004 Second ETL example - file to table.mp4

09:03

005 Thank you, some guide lines.mp4

03:02

006 ETL-tutorial-files.zip

006 Materials of the course.mp4

01:04

007 Download links of softwares.html

02 - Installations

001 Installation Intro.mp4

01:36

002 Install PDI.mp4

04:08

003 Install JAVA.mp4

03:37

004 Install MySql.mp4

04:09

005 Install Dbeaver.mp4

06:11

006 additionals for mysql8 and Dbeaver.mp4

05:12

007 Database creation.mp4

08:21

008 JDBC and connections.mp4

05:28

03 - PDI Walkthrough

001 PDI Environment.mp4

11:20

002 kettle.properties.mp4

08:36

003 PDI jobs.mp4

07:52

004 PDI shared xml.mp4

02:42

04 - The Project

001 Dim Date.mp4

02:24

002 Generate rows step.mp4

05:49

003 Add sequence step.mp4

01:49

004 Calculator Step.mp4

05:48

005 Select Values step.mp4

07:16

006 String cut step.mp4

02:59

007 Concat field step.mp4

02:38

008 String operation step.mp4

02:58

009 Table ouptput step.mp4

09:49

010 Dim date homework.mp4

07:50

011 Dim date homework solution.mp4

21:54

05 - Dim time

001 Dim time intro.mp4

00:47

002 Dim time final result.mp4

02:19

003 Cartesian step.mp4

08:17

004 String operation step 2.mp4

05:39

005 Java script step constant step.mp4

08:30

006 Filter rows step table output step 1.mp4

12:07

007 Filter rows step table output step 2.mp4

15:15

008 Dim time summary.mp4

04:13

009 Dim time homework.mp4

09:50

010 Dim time homework solution.mp4

32:34

06 - Dim Customers

001 Dim customers intro.mp4

04:21

002 Insert update step.mp4

21:30

07 - Dim film

001 Dim film intro.mp4

07:27

002 Dim film base.mp4

06:47

003 Handling nulls.mp4

06:10

004 Merge join step.mp4

05:27

005 Stream lookup step.mp4

03:27

006 De normalizer step.mp4

06:56

007 Dim film colnclusion.mp4

09:39

008 Dim film homework.mp4

03:27

009 Dim film solution.mp4

32:36

08 - Dim store

001 Dim store intro.mp4

04:19

002 Lookup step part 1.mp4

15:45

003 Lookup step part 2.mp4

11:04

004 Insert update step.mp4

09:42

005 Dim store homework.mp4

02:55

006 Dim store homework solution.mp4

07:35

09 - Fact rentals

001 Fact rental intro.mp4

09:06

002 Lookups.mp4

10:14

003 Date handling.mp4

18:33

004 Fact rental payments.mp4

16:03

005 Fact rental conclusion.mp4

03:33

006 Fact rental homework.mp4

02:17

007 Fact rental solution.mp4

08:56

10 - Main job

001 The main job part 1.mp4

11:29

002 The main job part 2.mp4

07:11

003 Schedule the main job.mp4

14:20

11 - Theory

001 Analytical structure.mp4

12:33

002 Data source part 1.mp4

14:11

003 Data source part 2.mp4

16:46

004 Data warehouse.mp4

05:37

005 Etl tools.mp4

17:59

12 - Whats next

001 Bonus lecture.html

Description

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

What You'll 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

Who is this for?

SQL developers, ETL developers, Automation developers, BI developers,software project managers and anyone who like to understand what is ETL

What You Need to Know?

You should have basic SQL knowledge

understand the basic idea od relational databases

More details

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
Who this course is for:
SQL developers, ETL developers, Automation developers, BI developers,software project managers and anyone who like to understand what is ETL

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Itamar Steinberg (inflow systems)

Instructor's Courses

My name is Steinberg itamar, I am in the field of information technology is for more than 15 years now, I have a Master's degree (MBA) in information technology is an management. My BA is also in the area of information technology from the University of Manchester. During those years I was serving as manager and information technology expert especially in the field of business intelligence and data integration. all that time i used Pentaho kettle as the leading Data integration tool. I started as a developer through team manager of development, head of the application department - responsible for all software, business processes and implementations, also as project manager, my last role as an employee I was the CIO of the large company. I was dealing with ERP, CRM business intelligence of course from all aspects of running a business. sales, transportation, customer service, imports, inventory, suppliers and manufacturing. All of these areas gave me a unique perspective on business processes and how to analyze a company by looking at one large picture – that is the BI. Of course that in order to combine all of those systems together you'll need data integration. I have more than eight years working with pentaho kettle. Six years ago I decided to start my own company - inflow systems and focus myself to business intelligence and data integration. On those six years I, as CEO, was leading large business intelligence projects. I hired several employees, very gifted, specific oriented to data integration and business intelligence. We have developed tens of projects from scratch at large companies like Alcatel Lucent (embedded solution), online gaming, binary options (stock market) and traditional businesses like food supplementary and organic food. Today, I want to give from my knowledge to you because I believe that to share is the right way to go, during my learning phase I was reading a lot of books, struggling with the technology and I think I can make your life easier.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.