Talend Data Integration Complete Beginner's Course

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Concepts and Principles of Data Integration

Lecture 3: Prerequisite before installing Talend on MAC

Lecture 4: Installing Talend on MAC

Lecture 5: Prerequisite before installing Talend on Windows

Lecture 6: Installing Talend on Windows

Chapter 2: Discovering Talend Open Studio

Lecture 1: Introduction

Lecture 2: Tour of Talend graphical interface

Lecture 3: Talend Components, what are they?

Lecture 4: Creating our first job : Hello World!

Lecture 5: Project Workshop 1

Chapter 3: Designing a Talend Standard Job

Lecture 1: Introduction

Lecture 2: Reading data from a file and logging it

Lecture 3: How to map data: tMap

Lecture 4: Talend Development good practices

Lecture 5: Project Workshop 2

Chapter 4: Context Variables and Global Variables

Lecture 1: Introduction

Lecture 2: What are Context Variables

Lecture 3: Creating context variables

Lecture 4: How to use context variables in a job

Lecture 5: What are Global Variables

Lecture 6: How to use Global variables in a job

Lecture 7: Difference between Context and Global Variables

Lecture 8: Outline Variables

Lecture 9: Context groups

Lecture 10: Project Workshop 3

Chapter 5: Mapping Data

Lecture 1: Introduction

Lecture 2: Simple mapping and tMap tricks

Lecture 3: tMap expressions

Lecture 4: Using the ternary operator for conditional logic

Lecture 5: Using intermediate variables in tMap

Lecture 6: Splitting the input data into multiple outputs based on conditions

Lecture 7: Talend good practices

Lecture 8: tMap functions

Lecture 9: Talend data joins

Lecture 10: Joining data using tMap

Lecture 11: Project Workshop 4

Chapter 6: Using Java in Talend

Lecture 1: Introduction

Lecture 2: tJava

Lecture 3: tJavaRow – Part 1

Lecture 4: tJavaRow – Part 2

Lecture 5: tJavaFlex – Part 1

Lecture 6: tJavaFlex – Part 2

Lecture 7: Project Workshop 5

Chapter 7: Reading and Writing Data to Files

Lecture 1: Introduction

Lecture 2: Reading CSV files

Lecture 3: Reading Excel files

Lecture 4: Reading JSON files

Lecture 5: Reading XML files

Lecture 6: Writing data to a delimited file

Lecture 7: Writing data to an Excel file

Lecture 8: Writing data to a JSON file

Lecture 9: Writing data to an XML file

Lecture 10: Getting the properties of a file

Lecture 11: Listing the files in a directory

Lecture 12: Project Workshop 6

Chapter 8: Managing Files

Lecture 1: Introduction

Lecture 2: Copying and Renaming files

Lecture 3: Deleting files

Lecture 4: Checking if files exist

Lecture 5: Archiving / Unarchiving files

Lecture 6: Project Workshop 7

Chapter 9: Reading and Writing Data to Databases

Lecture 1: Introduction

Lecture 2: Installing MySQL database on MAC

Lecture 3: Installing MySQL database on Windows

Lecture 4: Creating a database connection

Lecture 5: Getting data from a MySQL database

Lecture 6: Writing data to a MySQL database

Lecture 7: Deleting data from a MySQL database

Lecture 8: Project Workshop 8

Chapter 10: Data Processing

Lecture 1: Introduction

Lecture 2: How to sort data

Lecture 3: How to filter data

Lecture 4: How to aggregate data

Lecture 5: How to replace data

Lecture 6: How to filter columns

Lecture 7: How to replicate data

Lecture 8: Project Workshop 9

Chapter 11: Iterating and Looping

Lecture 1: Introduction