Course Pre-Requisite

    • Basic SQL
    • Interest in data and in bringing it together

Talend Basic

LESSON 1 Getting Started with Talend Studio

  • Concepts
  • Overview
  • Starting Talend Studio
  • Creating a First Job
  • Running a Job
  • Review

LESSON 2 Working with Files

  • Concepts
  • Overview
  • Reading an Input File
  • Transforming Data
  • Running a Job
  • Combining Columns
  • Duplicating a Job
  • Challenges
  • Solutions
  • Review

LESSON 3 Joining Data Sources

  • Concepts
  • Overview
  • Creating Metadata
  • Creating a Join
  • Capturing Rejects
  • Correcting a Lookup
  • Review

LESSON 4 Filtering Data

  • Concepts
  • Overview
  • Filtering Output Data
  • Using Map for Multiple Filters
  • Review

LESSON 5 Using Context Variables

  • Concepts
  • Overview
  • Understanding and Using Context Variables
  • Using Repository Context Variables
  • Challenges
  • Solutions
  • Review

LESSON 6 Error Handling

  • Concepts
  • Overview
  • Detecting and Handling Basic Errors
  • Raising a Warning
  • Review

LESSON 7 Generic Schemas

  • Concepts
  • Overview
  • Setting Up Sales Data Files
  • Creating Customer Metadata
  • Creating Product Metadata
  • Review

LESSON 8 Working with Databases

  • Concepts
  • Overview
  • Creating Database Metadata
  • Creating a Customer Table
  • Creating a Product Table
  • Setting Up a Sales Table
  • Joining Data
  • Finalizing the Job
  • Challenges
  • Solutions
  • Review

LESSON 9 Creating Master Jobs

  • Concepts
  • Overview
  • Controlling Job Execution Using a Master Job
  • Review

LESSON 10 Working with Web Services

  • Concepts
  • Overview
  • Accessing a Web Service
  • Review

LESSON 11 Running a Standalone Job

  • Concepts
  • Overview
  • Building a Job
  • Modifying a Job
  • Challenges
  • Solutions
  • Review

LESSON 12 Documenting a Job

  • Concepts
  • Overview
  • Using Best Practices While Documenting a Job 303
  • Review

Talend Advance

LESSON 1 Introduction

  • Concepts

LESSON 2 Connect to a Remote Repository

  • Concepts
  • Overview
  • Create a Remote Connection
  • Review

LESSON 3 SVN in Studio

  • Concepts
  • SVN in Studio
  • Copying a Job to a Branch
  • Comparing Jobs
  • Resetting a Branch
  • Review

LESSON 4 Reference Project

  • Concepts
  • Reference Project
  • Setting Up and Using a Reference Project
  • Review

LESSON 5 Remote Job Execution

  • Concepts
  • Remote Job Execution
  • Creating and Running a Job Remotely
  • Review

LESSON 6 Resource Usage and Basic Debugging

  • Concepts
  • Resource Usage and Basic Debugging
  • Using Memory Run to View Real Time Resource Usage
  • Debugging Jobs Using Debug Run
  • Review

LESSON 7 Activity Monitoring Console (AMC)

  • Concepts
  • Activity Monitoring Console (AMC)
  • Configuring Statistics and Logging
  • Using the Activity Monitoring Console (AMC)
  • Challenge
  • Solution
  • Review

LESSON 8 Parallel Execution

  • Concepts
  • Parallel Execution
  • Writing Large Files
  • Writing to Databases
  • Automatic Parallelization
  • Partitioning
  • Review

LESSON 9 Joblets

  • Concepts
  • Joblets
  • Creating a Joblet from an Existing Job
  • Creating a Joblet from Scratch
  • Triggering Joblets
  • Review

LESSON 10 Unit Test

  • Concepts
  • Unit Test
  • Creating a Unit Test
  • Review

LESSON 11 Change Data Capture

  • Concepts
  • Change Data Capture
  • Examining Databases
  • Configure the CDC Database
  • Monitoring Changes
  • Updating a Warehouse
  • Challenge
  • Solutions
  • Review
  • Resetting the Databases
  • Click here for view the session Recording.