Talend Data Integration Course : Beginner to Expert
3.9 (118 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.
391 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Talend Data Integration Course : Beginner to Expert to your Wishlist.

Add to Wishlist

Talend Data Integration Course : Beginner to Expert

Complete Guide to Learn Talend For Data Integration
Bestselling
3.9 (118 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.
391 students enrolled
Last updated 3/2017
English
Price: $95
30-Day Money-Back Guarantee
Includes:
  • 12.5 hours on-demand video
  • 65 Articles
  • 10 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn Basic concepts of ETL
  • Use Talend Open Studio for Data Integration for real work as quickly as possible.
  • Write Talend Open Studio for Data Integration 6.0 Consultant Certification
View Curriculum
Requirements
  • Basic Knowledge in ETL.
  • Familiarity with Java or SQL (Not mandatory).
  • General Concepts of Databases.
Description

Course Description

Talend is an open Source ETL Tool, which means small companies or businesses can use this tool to perform Extract Transform and Load their data into Databases or any File Format (Talend supports many file formats and Database vendors).

If you want to learn how to use Talend from SCRATCH or If you want to IMPROVE your skills in designing Talend Jobs, then this course is right for you.

Its got EVERYTHING, covers almost all the topics in Talend.

Talks about Real Time use CASES.

Prepares you for the Certification Exam.

By the end of the Course you will Master developing ETL Jobs with Talend.

Who are the Target Audience ?

  • Anyone Willing to Learn an ETL Tool thats Hot in current Market.
  • People Who want to use Talend Studio to perform data integration and management tasks.
  • People Who want to earn 110K + by working as a Talend Developer.

Are there Any Prerequisites ?

  • Basic Knowledge in ETL.
  • Familiarity with Java or SQL (Not mandatory).
  • General Concepts of Databases.

What Am I going to get from this Course ?

  • Over 300 Lectures and 11 Hours of Content !
  • Over 100 Exercises and Quiz Questions!
  • Once you finish this Course I guarantee, you will Pass the Certification Exam. (Offcourse you have to practice what ever I teach in this course  :-)).
  • You will get Source code and Data Used in all 100 + Exercises.
  • You will get Source code and Data Used in all 200 + Jobs Designed in the Course.
  • You will get a discount on Talend on Big Data Course. (Future Course).
  • I will respond to all your questions within 24 hours.
  • 40 % Off on my next course (Talend For Big Data Integration Course : Beginner to Expert)

What Are the System Requirements ?

  • PC or Mac.
  • Talend Software Which is FREE.
  • MYSQL Database Which is FREE.
Who is the target audience?
  • Anyone Willing to Learn an ETL Tool thats Hot in current Market.
  • People Who want to use Talend Studio to perform data integration and management tasks.
  • People Who want to earn 110K + by working as a Talend Developer.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
268 Lectures
12:40:29
+
What Does the Course Cover ?
2 Lectures 11:06

Explains the topics that will be covered in this Course.

Preview 04:54

Will walk you through how to download all the data files, job designs and exercise jobs which are part of this course.

How to Download The Data files and Job files ?
06:12
+
Introduction To Talend Open Studio
5 Lectures 24:29
Introduction
00:53

Discusses what Data Integration is and its principles.

Preview 02:50

Gives an Introduction to what Talend is and Why it is better than other similar tools.

Introduction to Talend Open Studio
09:33

Walks you through how to Download & install Java and Talend Open Studio for Data Integration on Windows.

Installing Talend Open Studio DI on Windows
05:32

Walks you through how to Download & install Java and Talend Open Studio for Data Integration on Mac/Linux.

Installing Talend Open Studio DI on Linux and Mac
05:41
+
Talend Open Studio GUI
7 Lectures 56:17
Introduction
00:41

Shows how to Launch Talend Open Studio.

Launching Talend Studio
01:51

Explains all the options available on Menu Bar and Tool Bar.

MainWindow, MenuBar and ToolBar
19:24

Explains all the options on Repository Panel.

Repository Panel
07:15

Explains all options related to Workspace and Pallete.

WorkSpace And Pallete Panels
07:22

Shows all the options available on Views and Summary Panels.

Views And Summary Panels
12:53

Walks you through how to Design a Simple Talend Job.

Preview 06:51
+
Designing a Business Model
8 Lectures 30:21
Introduction
00:43

Explains what a Business Model is.

What is a Business Model ?
02:07

Walks you through how to create a Business model using Talend Open Studio.

How to Create a Business Model ?
03:08

Discusses about what shapes are and different shapes that are available to design a Business Model.

What are the different types of shapes and How are they Used ?
05:34

Discusses about what Links are and different links that are available to connect shapes in a Business Model.

What are Different Relationship Types in a Business Model ?
06:07

Explains some advanced options available to a Business Model.

Deep Dive into Business Model View
05:04

Explains why you should assign a Repository object to a business model and shows you how to do it.

How to Assign any Repository Object to A Business Model ?
02:24

Shows you how to edit a business model. By the end of this section you should be comfortable to answer what a Business model is, why you need one and how to design one.

How to Edit a Business Model ?
05:14
+
All about Metadata Management and Database Schemas
16 Lectures 01:14:41
Introduction
01:14

Describes what metadata means and what kind of metadata schemas can be created in Talend and what are the advantages of creating metadata.

What is Metadata ?
08:57

Walks you through on how to create metadata for a Delimited File.

Creating Metadata For a Delimited File
11:47

Walks you through on how to create metadata for a Positional File.

Creating Metadata For a Positional File
06:42

Walks you through on how to create metadata for a Regex File.

Creating Metadata For a Regex File
03:26

Walks you through on how to create metadata for a XML File.

Creating Metadata For a XML File
13:41

Walks you through on how to create metadata for an Excel File.

Creating Metadata For an Excel File
04:16

Walks you through on how to create metadata for a LDIF File.

Creating Metadata For a LDIF File
03:25

Walks you through on how to create metadata for a JSON File.

Creating Metadata For a Json File
04:27

Walks you through on how to Create Generic Schema.

Creating Generic Schema
07:16

Walks you through on how to create metadata for a Web Service.

Creating Metadata For a Web Service
03:23

Walks you through on how to create metadata for a Database Connection.

Creating a Database Connection
05:45

[Exercise: 01] Create Builtin Schema
00:04

[Exercise: 02] Create Generic Schema
00:02

[Exercise: 03] Make Changes to Repository Schema and Propagate Changes
00:13

[Exercise: 18] Create Database Connection & Retrieve Schema
00:02
+
Contexts And Global Variables
17 Lectures 38:51
Introduction
01:06

Describes what are Context Variables.

What are Context Variables ?
05:11

Walks you through on how to create a Context Group.

Creating a context group
03:08

Shows you how to apply/use existing contexts in a Job.

How to apply context variables to a Job
04:55

Explains a Real time scenario, on how to load context values from a file or database.

How to Load context Values Dynamically from a flow or File or Database ?
03:35

Explains on how to load context values implicitly.

Using implicit context loading to load contexts
05:59

Show you how to use System Global Variables in a job.

How to Use Studio global variables
06:26

Explains how to create user defined Global Variables using Java and how to read them.

How to Create User defined global variables
03:16

Explains how to create user defined Global Variables using tSetGlobalVar and how to read them.

Using tSetGlobalVar to create Global Variable
04:08

[Exercise: 13] Create a Context and Create a globalMap Value Using tJava
00:23

[Exercise: 16] Load Context Values from a file
00:11

[Exercise: 17] Setup Implicit Context File Location
00:03

[Exercise: 48] Create a User Defined Global Variable and Pass it as a parameter
00:04

[Exercise: 62] Create a User Defined Global Variable and Use it
00:05

[Exercise: 63] Load a Context Value from a Properties File
00:05

[Exercise: 64] Use and Print any Global Variable to Console
00:04

[Exercise: 65] Create a Global Variable Using tSetGlobalVar
00:09
+
Designing a Talend Standard Job
8 Lectures 37:10
Introduction
00:39

Explains what a job design is.

What is a Job Design ?
02:32

Walks yo through on how to create a job.

How to Create a Job ?
02:08

Explains steps involved in Designing a job.

Preview 06:59

Explains how to Link different components in a job and why.

How to Link different Components ?
13:44

Explains different properties of components.

How to Define Component Properties ?
02:28

Shows you how to use existing contexts and variables in a job design.

How to Use Contexts and Variables in a Job ?
04:25

Explains different ways you can optimize a jobs performance.

How to optimize Job Performance ?
04:15
+
Managing Talend Jobs
5 Lectures 19:08
Introduction
00:35

Shows you how to import or export items/jobs.

How to Import/Export Items and Build Jobs ?
08:06

Describes how to manage items in repository.

How to Manage Repository Items ?
03:44

Walks you through how to document a job design.

How to Document a Job ?
03:48

Explains the different ways you can execute a job.

How to Handle Job Execution ?
02:55
+
File Management
47 Lectures 02:17:27
Introduction
01:22

Walks you through on how to create a job that reads data from an Apache Log File.

How to Read Data From an Apache Log File ?
07:49

Walks you through on how to create a job that reads data from an ARFF File.

How to Read Data From an ARFF File ?
03:01

Walks you through on how to create a job that reads data from a Delimited File.

How to Read Data From a Delimited File ?
05:54

Walks you through on how to create a job that reads data from an Excel File.

How to Read Data From an Excel File ?
03:08

Walks you through on how to create a job that reads the entire row of a file as a column.

How to Read Data Complete Row as a Column From a File ?
03:08

Walks you through on how to create a job that reads data from a JSON File.

How to Read Data From a JSON File ?
03:47

Walks you through on how to create a job that reads data from a LDIF File.

How to Read Data From a LDIF File ?
01:50

Walks you through on how to create a job that reads an Email File.

How to Read Data From an Email File ?
03:32

Walks you through on how to create a job that reads data from a Multi Structured Delimited File.

How to Read Data From a Multi Structured Delimited File ?
06:23

Walks you through on how to create a job that reads data from a Positional File.

How to Read Data From a Positional File ?
03:31

Walks you through on how to create a job that reads data from a Multi Structured Positional File.

How to Read Data From a Multi Structured Positional File ?
02:50

Walks you through on how to create a job that reads data from an XML File.

How to Read Data From a XML File ?
02:27

Walks you through on how to create a job that reads data from a Multi Structured XML File.

How to Read Data From a Multi Structured XML File ?
03:29

Walks you through on how to create a job that reads data from a Properties File.

How to Read Data From a Properties File ?
02:03

Walks you through on how to create a job that reads all the content of a file as single column.

How to Read all the content of a file and Send it to a Single column ?
01:40

Walks you through on how to create a job that reads data from a Regex File.

How to Read Data From a Regex File ?
01:42

Walks you through on how to create a job that Writes data to an ARFF File.

How to Write Data To an ARFF File ?
03:47

Walks you through on how to create a job that Writes data to a Delimited File.

How to Write Data To a Delimited File ?
01:08

Walks you through on how to create a job that Writes data to an Excel File.

How to Write Data To an Excel File ?
01:34

Walks you through on how to create a job that Writes data to a JSON File.

How to Write Data To a JSON File ?
01:41

Walks you through on how to create a job that Writes data to a LDIF File.

How to Write Data To a LDIF File ?
02:56

Walks you through on how to create a job that Writes data to a Multi Structured Delimited File.

How to Write Data To a Multi Structured Delimited File ?
03:33

Walks you through on how to create a job that Writes data to a Positional File.

How to Write Data To a Positional File ?
02:21

Walks you through on how to create a job that Writes data to a Multi Structured Positional File.

How to Write Data To a Multi Structured Positional File ?
02:50

Walks you through on how to create a job that Writes data to an XML File.

How to Write Data To a XML File ?
09:14

Walks you through on how to create a job that Writes data to a Multi Structured XML File.

How to Write Data To a Multi Structured XML File ?
13:25

Walks you through on how to create a job that Writes data to a Properties File.

How to Write Data To a Properties File ?
02:09

Walks you through on how to create a job that Writes complete files data as a single row single column.

How to Handle Single Column Output Data ?
01:30

Walks you through on how to create a job that creates a file where rows are changed into columns.

How to Change Rows into Columns ?
05:14

Walks you through on how to create a job that Changes Encoding of a File.

How to Change Encoding of a File ?
01:24

Walks you through on how to create a job that creates a Temporary File and explains how and when to use it.

How to Create a Temporary File ?
04:01

Walks you through on how to create a job that Archives a File/Directory.

How to Archive a File ?
02:40

Walks you through on how to create a job that Compares two Files.

How to Compare Two Files ?
03:50

Walks you through on how to create a job that copies Files.

How to Copy Files ?
01:08

Walks you through on how to create a job that deletes a File.

How to Delete a File ?
01:13

Walks you through on how to create a job that checks for whether a file exists or not and then triggers the rest of the process.

How to Check whether a File Exist or not ?
02:37

Walks you through on how to create a job that Lists files in a directory and processes those files.

How to List files in a Directory ?
03:08

Walks you through on how to create a job that finds properties of a file.

How to find properties of a File ?
01:54

Walks you through on how to create a job that Counts rows in a file.

How to Count the rows in a File ?
01:56

Walks you through on how to create a job that Touches a file.

How to Touch a File ?
02:05

Walks you through on how to create a job that unzips a file.

How to UnArchive or UnZip a File ?
01:50

[Exercise: 04] Read From a Delimited File and Capture Rejects
00:05

[Exercise: 31] Create a Temporary File
00:14

[Exercise: 37] Capture a File Information and Log it
00:06

[Exercise: 38] Read Multiple Files Using tFileList and Append to a Single File
00:14

[Exercise: 58] Create a Job to Archive a File/Directory
00:03
+
Processing The Data
42 Lectures 01:38:13
Introduction
00:49

Walks you through on how to create a job that performs an aggregation on specified columns.

How to Aggregate Data to Find Max,Min,Avg ?
05:44

Walks you through on how to create a job that performs an aggregation on specified columns where the data is pre sorted.

How to Aggregate PreSorted Data ?
04:41

Walks you through on how to create a job that performs java type conversions on specified fields or all.

How to Auto Cast Data Types ?
03:36

Walks you through on how to create a job that sorts data on specified fields.

How to Sort Data ?
02:49

Walks you through on how to create a job that sorts data on specified fields using a sort algorithm/program of you r choice.

How to Sort Data Using External Sort Program ?
02:39

Walks you through on how to create a job that filters specified columns.

How to Filter Columns ?
01:42

Walks you through on how to create a job that filters rows based on filter condition specified.

How to Filter Input Rows ?
04:31

Walks you through on how to create a job that joins two tables.

How to Join two Tables ?
04:41

Walks you through on how to use tMap component and in which scenario. - Part 1

How to Transform and Route Data from Single/Multiple Sources to Targets ? -Part1
13:49

Walks you through on how to use tMap component and in which scenario. - Part 2

How to Transform and Route Data from Single/Multiple Sources to Targets ? -Part2
13:15

Walks you through on how to design a job that replaces certain string/character in data on specified fields.

How to Search & Replace Data in input columns?
03:12

Walks you through on how to design a job that samples rows based on specified row numbers.

How to Get Sample of Data ?
01:45

Walks you through on how to use tXMLMap component and in which scenario.

How to Transform and Route XML data flows ?
04:42

Walks you through on how to design a job to denormalize, normalized data.

How to Denormalize Source Data on a single column ?
03:38

Walks you through on how to design a job to normalize, denormalized data.

How to Normalize input flow ?
01:12

Walks you through on how to design a job to denormalize, normalized pre sorted data.

How to Denormalize PreSorted Source Data on a single column ?
03:37

Walks you through on how to design a job where the input data has a field with multiple fields delimited by a a character.

How to Generate Multiple Columns from a Delimited String Column ?
03:05

Walks you through on how to design a job where the input data has a field with multiple JSON fields.

How to extract Data from JSON fields Stored in a file or Database Table ?
04:10

Walks you through on how to design a job where the input data has a field with multiple positional fields.

How to Generate Multiple Columns from a Positional String Column ?
01:46

Walks you through on how to design a job where the input data has a field with multiple Regex fields.

How to Generate Multiple Columns from a Column using Regex Matching ?
02:23

Walks you through on how to design a job that splits one row into several rows.

How to Split one Row into Several Rows ?
02:27

Walks you through on how to design a job that transforms input data of any form into JSON fields.

How to Transform Input Data into JSON Fields ?
02:31

Walks you through on how to design a job that transforms input data of any form into XML fields.

How to Transform Input Data into XML Fields ?
02:36

[Exercise: 07] Capture Rejects from tMap
00:09

[Exercise: 08] Use Multiple Filter Conditions in tMap
00:09

[Exercise: 10] Create Variables in tMap
00:21

[Exercise: 11] Use Multiple Outputs with Filter Conditions in tMap
00:31

[Exercise: 12] Connecting to Mysql & Lookup/Join Using tMap
00:08

[Exercise: 32] Create a Job that writes to and reads from cache memory
00:06

[Exercise: 33] Read and Parse a File with Header,Trailer,Detail Record Types
00:10

[Exercise: 34] Read and Parse a File with Header,Trailer,Detail Record Location
00:12

[Exercise: 35] Create a Job that validates File Using Trailer Count
00:18

[Exercise: 49] Count Number of Orders a Customer made
00:06

[Exercise: 50] Create a Job to Denormalize Data
00:05

[Exercise: 51] Create a Job to Extract Delimited Data from a Field
00:04

[Exercise: 52] Create a Job to Filter Data Using tFilterRow
00:06

[Exercise: 53] Create a Job to Replicate Input Flow and Apply Filter
00:07

[Exercise: 54] Create a Job to Search and Replace a word/character
00:04

[Exercise: 55] Create a Job to Normalize Data
00:04

[Exercise: 56] Create a Job to Sample few Rows from Input Flow
00:02

[Exercise: 57] Create a Job to Sort Data Using tSortRow
00:04
10 More Sections
About the Instructor
Mr. Kapil Chaitanya Kasarapu
4.0 Average rating
135 Reviews
414 Students
2 Courses
ETL Architect

8 years experience in the area of DataStage, Talend ETL Design and Architecture, data analysis, and/or reporting, data management, modeling.

5 Years of experience in the area of Big Data.

Functional work in and familiarity with enterprise architecture concepts.

Passionate about data, technology, and innovation.

Certified Talend Open Studio for Data Integration 6.0 Consultant

Certified Talend Big Data 6.0 Developer

Certified Talend Real Time Big Data 6.0 Developer

HDP Certified Developer