Data integration (ETL) with Talend Open Studio

Talend - from basics to advanced technics.
4.0 (37 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
179 students enrolled
$35
Take This Course
  • Lectures 52
  • Contents Video: 8.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

If you want to simplify your data interactions than Talend Studio is the right product for you, but if you don't want to spend a fortune on training or books are not your preferred method than this course is exactly for you.

Within this course over the stretch of 8 hours you will learn how to install Talend how to navigate and use the interface efficiently. How to import data into Talend and then perform various transformation of data, cleansing, filtering, lookups, concatenations and much more. You will also learn some advanced features of Talend and how to work with different databases. Finally you will learn how to debug, log job information and monitor statistics of jobs that you build and schedule to run automatically.

This course will provide more than 8 hours of video material in 720p with full voice over and every example showcased will be available to you as a zip file attachment.

So if you want to quickly learn how to efficiently use Talend sign up.

Promise:

In addition to the 7 main sections of the course, each week a new video will be uploaded after the course is published for at list 13 weeks.

Those videos will cover advanced topics, obscure Talend features you might find useful and tips and tricks. For instance – How to inject other application functionality into Talend.

What are the requirements?

  • A bit of Java
  • A bit of Databases, How RDBMS DB's work
  • SQL syntax

What am I going to get from this course?

  • Create ETL jobs that connect to almost any data source
  • Filter, Modify, Unite data
  • Build standalone jobs that run on a schedule or based on an event
  • Make jobs more user-friendly for non technical users

What is the target audience?

  • Anyone who is interested in Data Integration ant ETL
  • Everyone who wants to make there job easer

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Talend Basics
01:40

This is a quick introduction into the course.

Note: All materials of a section are attached to the first lesson.

07:20

In this lesson we will be looking at how to install Talend on Linux.

For my example I am using Ubuntu, but you can use any other Linux flavour.

Note: All materials of a section are attached to the first lesson.

10:35

In this lesson we will be looking at how to install Talend on Windows.

I will be using Windows 7 as an example.

Note: All materials of a section are attached to the first lesson.

08:04

We will go though the user interface of Talend.

Note: All materials of a section are attached to the first lesson.

15:22

In this lesson we will be looking at context variables and metadata.

Note: All materials of a section are attached to the first lesson.

13:24

We are continuing our examination of context and metadata in Talend.

Note: All materials of a section are attached to the first lesson.

14:46

... and a bit more.

Note: All materials of a section are attached to the first lesson.

18:13

This is the final lesson on context and metadata. I promise.

Note: All materials of a section are attached to the first lesson.

11:43

In this lesson we will take a look at different ways of creating Headers.

Note: All materials of a section are attached to the first lesson.

Section 2: Data Mapping
14:17

In this lesson we will be looking at one of the most important components in Talend - tMap

Note: All materials of a section are attached to the first lesson.

09:47

In this lesson I will show you how to quickly generate dummy data.

Note: All materials of a section are attached to the first lesson.

06:25

Continuing with tMap component.

Note: All materials of a section are attached to the first lesson.

02:56

A couple of more things on tMap.

Note: All materials of a section are attached to the first lesson.

09:56

Looking at how tMap can be used with Databases.

Note: All materials of a section are attached to the first lesson.

Section 3: Conversion, Extraction, Join
11:33

In this lesson we will look at ways we can use Regex expresions to extract required data from differnt types of files.

Note: All materials of a section are attached to the first lesson.

06:37

In this lesson we will look at how to convert XML to a CSV file.

Note: All materials of a section are attached to the first lesson.

13:18

In this lesson we will do the reverse and convert a csv file into an XML file.

Note: All materials of a section are attached to the first lesson.

14:08

In this lesson we will take a look at some of the advanced XML features present in Talend.

Note: All materials of a section are attached to the first lesson.

04:43

In this lesson we will look at other ways of joining data.

Note: All materials of a section are attached to the first lesson.

06:50

Here we will look at how we can split data.

Note: All materials of a section are attached to the first lesson.

10:51

This lesson will show you how to perform advanced data lookups.

Note: All materials of a section are attached to the first lesson.

05:52

Here I will learn of another way to join data.

Note: All materials of a section are attached to the first lesson.

Section 4: Helpful features
06:47

In this lesson we will look at how we can retrieve helpful file information.

Note: All materials of a section are attached to the first lesson.

07:09

In this lesson I will show you how to perform the fastest possible row counts on a file.

Note: All materials of a section are attached to the first lesson.

08:09

We will talk about how to use temp files, how to delete, move and rename files using Talend.

Note: All materials of a section are attached to the first lesson.

Section 5: Java
02:06

In this lesson we will look at how to use tJava component in Talend.

Note: All materials of a section are attached to the first lesson.

04:56

In this lesson we will look at more examples on how to use tJava.

Note: All materials of a section are attached to the first lesson.

06:07

tJavaRow is another component in which you can write custom Java code and in this example we will look at how it can be used.

Note: All materials of a section are attached to the first lesson.

07:09

Yet another Java custom code component.

Note: All materials of a section are attached to the first lesson.

13:46

In this lesson we will look at how custom routines are created in Talend.

The example will showcase how to make a routine that will convert EPOCH time to human readable and vice versa.

Note: All materials of a section are attached to the first lesson.

Section 6: Databases
07:55

In this lesson we will have a quick overview of different Database connectors that Talend offers out of the box.

Note: All materials of a section are attached to the first lesson.

18:44

HSQL or Hyper SQL is a fully supported RDBMS database within Talend and in this lesson we will look at ways we can use it to quickly create a database without running any DB Servers locally or remotely.

Note: All materials of a section are attached to the first lesson.

10:45

In this lesson we will look at how we can import Table Schemas in to Talend repository.

Note: All materials of a section are attached to the first lesson.

10:47

More on Table Schemas.

Note: All materials of a section are attached to the first lesson.

10:07

Here we will look at how read from a database.

Note: All materials of a section are attached to the first lesson.

12:22

Here we will look at how to write to a database.

Note: All materials of a section are attached to the first lesson.

Section 7: Debugging, Logging, Building, Scheduling
10:19

In this lesson we will examine the various ways we can debug our jobs when something goes wrong.

Note: All materials of a section are attached to the first lesson.

05:30

This lesson will show you different ways of handling data rejects.

Note: All materials of a section are attached to the first lesson.

10:22

This lesson will show you another way you can handle data rejects, which is more userfrandly.

Note: All materials of a section are attached to the first lesson.

12:54

In this lesson we will look at how we can save the console log to a file.

Note: All materials of a section are attached to the first lesson.

05:30

In this lesson we will quickly go back to tMap component and look at how to capture input rejects.

Note: All materials of a section are attached to the first lesson.

10:46

In this lesson we will look at how to log job information.

Note: All materials of a section are attached to the first lesson.

10:09

In this lesson we will look at how to monitor parts of the job.

Note: All materials of a section are attached to the first lesson.

06:02

In this lesson we will finally take a look at how we can build a job in Talend so that it can work standalone.

Note: All materials of a section are attached to the first lesson.

07:38

In this lesson we will look at ways to add context values for a build job without using Talend Studio.

Note: All materials of a section are attached to the first lesson.

13:25

Here we will look at some other ways we can modify the context of a built job.

Note: All materials of a section are attached to the first lesson.

07:32

In this lesson we will look at how we can schedule a job in windows using Task Scheduler.

Note: All materials of a section are attached to the first lesson.

Section 8: Extras
18:46

In this lesson we will take a look at sub jobs and how you can link multiple jobs together. In addition we will take a quick look at another component called tRestClient with which you can make REST calls.

The example will show how to rerun the job with the previos context value without the need to save it manualy.

11:57

In this lesson we will take a look at custom components.

  • The lesson will cover how to:
  • Ways to install custom components;
  • How to delete custom components;
18:07

In this lesson we will continue looking at custom components we installed in lesson 49 - Custom Components and take a closer look at tFileExcel* components created by Jan Lolling.

We will create a job based on these components using a client scenario that you might run into.

16:30

In this lesson we will take a look at how you can inject other application functionality into Talend Open Studio using the standard tSystem component. The example will also require that you run this on a Windows machine and have PuTTY installed.

You can download PuTTY from thelink provided. Make sure you download "A Windows installer for everything except PuTTYtel".
06:33

This lesson is a folow up lesson to "Using tSystem Component" and it will show a simpler way of uploading/downloading data between two computers.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Aleksandr Eleynik, Data Integration Consultant

I started my career in IT by working as a System Administrator for TELE2 and Datametrix. During that time, I got my first Degree in Computer Science. I then acquired a second Degree in Business Information Systems and continued my career as a Data Services Technical Consultant at Lumesse.

Currently I am working as a Data Integration Consultant.

In the more than 5 years of combined experience within the tech sector I have obtained both practical and theoretical knowledge of all the main operating systems, databases, several programming languages and leading ETL and data visualisation tools.

My current work requires switching between multiple projects, from satellite data analysis, to Data Lake creation, to SAP financial data integration and KPI automation. Over the years, I worked with companies such as Sony, Astra Zeneca, Puma, and Vodafone to name a few.

I would like to share the knowledge of Data Integration and Analysis I have attained over the years with you.

Ready to start learning?
Take This Course