Data integration (ETL) with Talend Open Studio
4.0 (76 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.
310 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data integration (ETL) with Talend Open Studio to your Wishlist.

Add to Wishlist

Data integration (ETL) with Talend Open Studio

Talend - from basics to advanced technics.
4.0 (76 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.
310 students enrolled
Last updated 8/2015
English
Price: $35
30-Day Money-Back Guarantee
Includes:
  • 8.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • A bit of Java
  • A bit of Databases, How RDBMS DB's work
  • SQL syntax
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.

Who is the target audience?
  • Anyone who is interested in Data Integration ant ETL
  • Everyone who wants to make there job easer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
52 Lectures
08:37:09
+
Talend Basics
9 Lectures 01:41:07

This is a quick introduction into the course.

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

Preview 01:40

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.

Linux Installation
07:20

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.

Windows Installation
10:35

We will go though the user interface of Talend.

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

Talend UI
08:04

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

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

Taking a look at the Repository Tab
15:22

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

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

Repository Tab in more detail
13:24

... and a bit more.

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

Context and Metadata
14:46

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

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

More on Context and Metadata
18:13

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.

Headers
11:43
+
Data Mapping
5 Lectures 43:21

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.

Mapping Data
14:17

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.

Data Generation
09:47

Continuing with tMap component.

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

Outputing tMap Rejects
06:25

A couple of more things on tMap.

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

Filtering Mapped Data
02:56

Looking at how tMap can be used with Databases.

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

Mapping Database Data
09:56
+
Conversion, Extraction, Join
8 Lectures 01:13:52

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.

Regex Expressions
11:33

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.

XML to CSV conversion
06:37

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.

CSV to XML conversion
13:18

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.

Advanced XML
14:08

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

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

Joining Data
04:43

Here we will look at how we can split data.

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

Splitting Data
06:50

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

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

Performing Advanced Data Lookups
10:51

Here I will learn of another way to join data.

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

Uniting Data
05:52
+
Helpful features
3 Lectures 22:05

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.

Preview 06:47

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.

Row Count
07: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.

Temp, Delete, Move, Rename
08:09
+
Java
5 Lectures 34:04

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.

Basics tJava component
02:06

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.

More features of tJava component
04:56

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.

tJavaRow component
06:07

Yet another Java custom code component.

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

tJavaFlex component
07:09

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.

Custom Routines
13:46
+
Databases
6 Lectures 01:10:40

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.

Databases in Talend
07:55

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.

Working with Hyper SQL (HSQL)
18:44

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.

Looking at Table Schema's
10:45

More on Table Schemas.

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

Importing Table Schema's
10:47

Here we will look at how read from a database.

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

Reading Data from a Database
10:07

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

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

Writing Data to a Database
12:22
+
Debugging, Logging, Building, Scheduling
11 Lectures 01:40:07

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.

Debugging
10:19

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

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

Reject Handling
05:30

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.

Reject Handling with tMsgbox component
10:22

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.

Saving Console Log to a flat file
12:54

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.

tMap Input Reject Handling
05:30

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

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

Logging Job Information
10:46

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.

Monitoring Jobs
10:09

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.

Building Talend Jobs
06:02

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.

Adding context from command line
07:38

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.

Additional context variable modifications
13:25

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.

Scheduling Talend Jobs
07:32
+
Extras
5 Lectures 01:11:53

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.

Sub Jobs
18:46

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;
Custom Components
11:57

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.

Preview 18:07

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".
Using tSystem Component
16:30

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.

Using tSCP* components
06:33
About the Instructor
Consultant/Developer Andrejs Zaharovs
4.0 Average rating
76 Reviews
310 Students
1 Course
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.