Talend Data Integration Course : Beginner to Expert

Course Curriculum

Chapter 1: What Does the Course Cover ?

Lecture 1: What does the course cover ?

Lecture 2: How to Download The Data files and Job files ?

Chapter 2: Introduction To Talend Open Studio

Lecture 1: Introduction

Lecture 2: Concepts and Principles of Data Integration

Lecture 3: Introduction to Talend Open Studio

Lecture 4: Installing Talend Open Studio DI on Windows

Lecture 5: Installing Talend Open Studio DI on Linux and Mac

Chapter 3: Talend Open Studio GUI

Lecture 1: Introduction

Lecture 2: Launching Talend Studio

Lecture 3: MainWindow, MenuBar and ToolBar

Lecture 4: Repository Panel

Lecture 5: WorkSpace And Pallete Panels

Lecture 6: Views And Summary Panels

Lecture 7: Designing a Simple Job

Chapter 4: Designing a Business Model

Lecture 1: Introduction

Lecture 2: What is a Business Model ?

Lecture 3: How to Create a Business Model ?

Lecture 4: What are the different types of shapes and How are they Used ?

Lecture 5: What are Different Relationship Types in a Business Model ?

Lecture 6: Deep Dive into Business Model View

Lecture 7: How to Assign any Repository Object to A Business Model ?

Lecture 8: How to Edit a Business Model ?

Chapter 5: All about Metadata Management and Database Schemas

Lecture 1: Introduction

Lecture 2: What is Metadata ?

Lecture 3: Creating Metadata For a Delimited File

Lecture 4: Creating Metadata For a Positional File

Lecture 5: Creating Metadata For a Regex File

Lecture 6: Creating Metadata For a XML File

Lecture 7: Creating Metadata For an Excel File

Lecture 8: Creating Metadata For a LDIF File

Lecture 9: Creating Metadata For a Json File

Lecture 10: Creating Generic Schema

Lecture 11: Creating Metadata For a Web Service

Lecture 12: Creating a Database Connection

Lecture 13: [Exercise: 01] Create Builtin Schema

Lecture 14: [Exercise: 02] Create Generic Schema

Lecture 15: [Exercise: 03] Make Changes to Repository Schema and Propagate Changes

Lecture 16: [Exercise: 18] Create Database Connection & Retrieve Schema

Chapter 6: Contexts And Global Variables

Lecture 1: Introduction

Lecture 2: What are Context Variables ?

Lecture 3: Creating a context group

Lecture 4: How to apply context variables to a Job

Lecture 5: How to Load context Values Dynamically from a flow or File or Database ?

Lecture 6: Using implicit context loading to load contexts

Lecture 7: How to Use Studio global variables

Lecture 8: How to Create User defined global variables

Lecture 9: Using tSetGlobalVar to create Global Variable

Lecture 10: [Exercise: 13] Create a Context and Create a globalMap Value Using tJava

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

Lecture 12: [Exercise: 17] Setup Implicit Context File Location

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

Lecture 14: [Exercise: 62] Create a User Defined Global Variable and Use it

Lecture 15: [Exercise: 63] Load a Context Value from a Properties File

Lecture 16: [Exercise: 64] Use and Print any Global Variable to Console

Lecture 17: [Exercise: 65] Create a Global Variable Using tSetGlobalVar

Chapter 7: Designing a Talend Standard Job

Lecture 1: Introduction

Lecture 2: What is a Job Design ?

Lecture 3: How to Create a Job ?

Lecture 4: How to Design a Talend Job ?

Lecture 5: How to Link different Components ?

Lecture 6: How to Define Component Properties ?

Lecture 7: How to Use Contexts and Variables in a Job ?

Lecture 8: How to optimize Job Performance ?

Chapter 8: Managing Talend Jobs

Lecture 1: Introduction

Lecture 2: How to Import/Export Items and Build Jobs ?

Lecture 3: How to Manage Repository Items ?

Lecture 4: How to Document a Job ?

Lecture 5: How to Handle Job Execution ?

Chapter 9: File Management

Lecture 1: Introduction

Lecture 2: How to Read Data From an Apache Log File ?

Lecture 3: How to Read Data From an ARFF File ?

Lecture 4: How to Read Data From a Delimited File ?

Lecture 5: How to Read Data From an Excel File ?

Lecture 6: How to Read Data Complete Row as a Column From a File ?

Lecture 7: How to Read Data From a JSON File ?

Lecture 8: How to Read Data From a LDIF File ?

Lecture 9: How to Read Data From an Email File ?

Lecture 10: How to Read Data From a Multi Structured Delimited File ?

Lecture 11: How to Read Data From a Positional File ?

Lecture 12: How to Read Data From a Multi Structured Positional File ?

Lecture 13: How to Read Data From a XML File ?

Lecture 14: How to Read Data From a Multi Structured XML File ?

Lecture 15: How to Read Data From a Properties File ?

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

Lecture 17: How to Read Data From a Regex File ?

Lecture 18: How to Write Data To an ARFF File ?

Lecture 19: How to Write Data To a Delimited File ?

Lecture 20: How to Write Data To an Excel File ?

Lecture 21: How to Write Data To a JSON File ?

Lecture 22: How to Write Data To a LDIF File ?

Lecture 23: How to Write Data To a Multi Structured Delimited File ?