Data integration (ETL) with Talend Open Studio

Data integration (ETL) with Talend Open Studio, available at $27.99, has an average rating of 3.5, with 52 lectures, based on 330 reviews, and has 1134 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone who is interested in Data Integration ant ETL or Everyone who wants to make there job easer It is particularly useful for Anyone who is interested in Data Integration ant ETL or Everyone who wants to make there job easer .

Enroll now: Data integration (ETL) with Talend Open Studio

Summary

Title: Data integration (ETL) with Talend Open Studio

Price: $27.99

Average Rating: 3.5

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: ￡29.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Anyone who is interested in Data Integration ant ETL

Everyone who wants to make there job easer

Target Audiences

Anyone who is interested in Data Integration ant ETL

Everyone who wants to make there job easer

If you want to simplify your data interactions than Talend Studio is the right product for you, but if you dont 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.

Course Curriculum

Chapter 1: Talend Basics

Lecture 1: Introduction

Lecture 2: Linux Installation

Lecture 3: Windows Installation

Lecture 4: Talend UI

Lecture 5: Taking a look at the Repository Tab

Lecture 6: Repository Tab in more detail

Lecture 7: Context and Metadata

Lecture 8: More on Context and Metadata

Lecture 9: Headers

Chapter 2: Data Mapping

Lecture 1: Mapping Data

Lecture 2: Data Generation

Lecture 3: Outputing tMap Rejects

Lecture 4: Filtering Mapped Data

Lecture 5: Mapping Database Data

Chapter 3: Conversion, Extraction, Join

Lecture 1: Regex Expressions

Lecture 2: XML to CSV conversion

Lecture 3: CSV to XML conversion

Lecture 4: Advanced XML

Lecture 5: Joining Data

Lecture 6: Splitting Data

Lecture 7: Performing Advanced Data Lookups

Lecture 8: Uniting Data

Chapter 4: Helpful features

Lecture 1: Retreating and working with File Properties

Lecture 2: Row Count

Lecture 3: Temp, Delete, Move, Rename

Chapter 5: Java

Lecture 1: Basics tJava component

Lecture 2: More features of tJava component

Lecture 3: tJavaRow component

Lecture 4: tJavaFlex component

Lecture 5: Custom Routines

Chapter 6: Databases

Lecture 1: Databases in Talend

Lecture 2: Working with Hyper SQL (HSQL)

Lecture 3: Looking at Table Schemas

Lecture 4: Importing Table Schemas

Lecture 5: Reading Data from a Database

Lecture 6: Writing Data to a Database

Chapter 7: Debugging, Logging, Building, Scheduling

Lecture 1: Debugging

Lecture 2: Reject Handling

Lecture 3: Reject Handling with tMsgbox component

Lecture 4: Saving Console Log to a flat file

Lecture 5: tMap Input Reject Handling

Lecture 6: Logging Job Information

Lecture 7: Monitoring Jobs

Lecture 8: Building Talend Jobs

Lecture 9: Adding context from command line

Lecture 10: Additional context variable modifications

Lecture 11: Scheduling Talend Jobs

Chapter 8: Extras

Lecture 1: Sub Jobs

Lecture 2: Custom Components

Lecture 3: Creating a job with tFileExcel* (Custom Components)

Lecture 4: Using tSystem Component

Lecture 5: Using tSCP* components

Instructors

Andrejs Zaharovs
Data Integration Consultant

Rating Distribution

1 stars: 14 votes

2 stars: 18 votes

3 stars: 61 votes

4 stars: 137 votes

5 stars: 100 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!