Talend Open Studio for Data Integration Training

Talend is the leading developer of open source data integration systems. Talend Open Studio for Data Integration is a Java based open source tool that has set of 800+ components that helps achieve tremendous ETL capabilities. These vast set of  components helps you establishing connections with all major relational as well as NOSQL databases plus also gives you enhanced performance in data loading operations.

Talend Open Studio for Data Integration Training Curriculum : 

Below mentioned curriculum covers all the concepts required for clearing Talend Open Studio for Data Integration Certification.

Both self-paced as well instructor led trainings are available.

Sample Video for Self Paced Course

              Loading your datawarehouse using Talend

Click Here for more details about Training Curriculum, Free Training Videos and Reviews.

Ø Module 1 : Getting started with Talend Open Studio

·       Studio Definitions

·       Starting the studio

·       Creating the project

·       Everything about Talend GUI

·       Creating an example job

Ø Module 2 : Working with Metadata

·       Creating a Built-in Schema

·       Creating Repository Schema

·       Propagating Schema Changes

·       Dropping Schema to empty components

·       Cutting and pasting schema information

Ø Module 3: Working with Files

·       Reading Delimited files

·       Reading Positional Files

·       Reading Excel Files

·       Reading XML Files

·       Reading Regex Files

Ø Module 4 : Usage of Database Components in Talend

·          tOracleConnection

·         tOracleInput

·         tOracleOutput

·         tOracleRow

Ø Module 5 : Using tMap

·       Overview of  tMap

·       Connecting multiple inputs to tMap

·       Creating joins in tMap

·       Catching Rejects in tMap

·       Using Expression Builder in tMap

·       Using Variables in tMap

·       Performance tuning of look ups in tMap

Ø Module 6 : Usage of Processing Components in Talend

·        tJoin

·        tFilterRow

·        tAggregateRow

·        tSortRow

·       tReplace

·       tAggregateSortedRow

·       tNormalize

·       tDeNormalize

Ø Module 7 : Basics of Java

·        Classes and Objects

·       Writing Hello Java Program

·       OOPS Concepts

v Method overloading

v Static keyword

v Abstract Modifiers

·         Handling Java Strings

Ø Module 8 : Using Java in Talend

·       Creating Routines in Talend

·        Using Custom Code in Talend

·        Using tJava component

·        Using tJavaRow component

·        Using tJavaFlex component

  

Ø Module 9 : Usage of Iterative and Data Quality Components in Talend

·       tFileList

·       tFlowtoIterate

·       tIteratetoFlow

·       tUniqRow

·       tReplaceList

·       tSchemaComplianceCheck

Ø Module10:Configuring Statistics and Logs in Talend

·       Capturing Statistics at Project Level

·       Using tWarn, tDie, tFlowMeter

·       Using tFlowMeterCatcher, tLogcatcher

·       Using Global Variables in Talend

Ø  Module 11 : Preparing for Deployment

·       Creating Context variables

·       Creating Context group

·       Usage of Prompts in Talend Jobs

·       Running Jobs in different contexts

·       Using tContextLoad

·       Using tContextDump

Ø Module 12 : Creating Subjobs

·       Using tRunJob

·       Passing parameters to Sub Job

·       Passing context variables from Parent Job to Child Job

·       Passing context variables from Child Job to Parent Job

ØModule 13: Data warehousing Basics

·        Data warehousing Architecture

·       Dimension Tables

·       Fact Tables

·       Types of Schema

·       Slow Changing Dimension

·       OLAP and OLTP

Ø Module 14: Using SCD Components in Talend

·       Using SCD Type 1 Components

·       Using SCD Type 2 Components

·       Using SCD Type 3 Components

Ø Module 15 : Miscellanous Videos

·       Export and Import Talend Jobs/Projects

·       Running Talend Job using Windows Task Scheduler

·       Performance Tuning in tMap

·       Performance Tuning using Subjobs

·       Using ELT Components

Ø Module 16: Case Study/ Project – Building a Retail Datawarehouse

·       Discussing Business Requirements Document

·       Creating Staging Load Jobs

·       Creating Dimension Load Jobs

·       Creating Fact Load Jobs

Ø Module 17: Designing a Business Models in Talend

•          Opening/Creating a Business Model

•          Modelling a Business Model

•          Assigning Repository elements to a Business Model
                                                         

Some of  unsolicited reviews of training :- 

                                                      
Bharat Khanna
Talend Certified Developer and Corporate Trainer

For training requirements, please email me at bharat3khanna@gmail.com or visit my website www.learntalendonline.com 

Subscribe to MyYouTube Channel Here