Talend Training

BY
Mindmajix Technologies

Become a Certified Talend Professional by joining the Mindmajix-offered online training.

Mode

Online

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course overview

Talend Training course is an online training programme offered by Mindmajix to provide the learners with an in-depth understanding of Talend. The course will equip the students with a thorough knowledge of various concepts related to Talend. The learners will develop the skills and knowledge of using Talend Studio for Big Data integration and will be able to clear the  Talend certification through this online training.

Talend Training online course will cover a wide range of Talend-related topics such as Data integration and Talend Studio, Mapping Data Flows, Data analytics,  Mapping variables, Managing Routines and  Metadata, ELT concepts and whatnot through various real-time examples, practical projects and case studies. The candidates who want to learn the  Talend Training certification must have the knowledge of Data warehousing and a basic understanding of big data to be eligible for the training. The learners can enrol in the online training by the modes of corporate training, the Self-Paced Videos and Live Online sessions.

The highlights

  • 100%  online course
  • Offered by Mindmajix
  • FREE Demo on Request
  • Flexible Schedule
  • Online Live and Self-paced Training Options
  • 24/7 Lifetime Support
  • Life-Time Self-Paced Videos Access
  • One-on-One Doubt Clearing
  • Certification Oriented Curriculum

Program offerings

  • One-on-one doubt clearing sessions
  • Certification oriented curriculum
  • Real-time project use cases
  • 20 hours of labs
  • Free demo on request
  • 24/7 lifetime support
  • 30 hours of sessions
  • Online live and self-paced training options

Course and certificate fees

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

What you will learn

Database management Sql knowledge

Through the Talend Training online certification, the learners will learn the concepts of Datasource connection, Installation of Talend, Multidimensional Data Modeling, Data Management techniques, Data Modeling, fundamental basics of Talend, Schema and Data aggregation. Plus, the students will be able to build a deep knowledge of HDFS, Pig, Hive, Sqoop, HBase, automatic configuration of files and the manual creation of cluster Metadata.

The syllabus

Data integration and Talend Studio

  • Data analytics 
  • Operational integration 
  • Execution monitoring

Getting started with Talend Studio

  • Important concepts in Talend Open Studio for Data Integration 
  • Launching Talend Open Studio for Data Integration 
  • How to launch the Studio for the first time 
  • How to set up a project 
  • Working with different workspace directories 
  • How to create a new workspace directory 
  • Working with projects 
  • How to create a project 
  • How to import the demo project 
  • How to import projects 
  • How to open a project 
  • How to delete a project 
  • How to export a project 
  • Migration tasks 
  • Setting Talend Open Studio for Data Integration preferences 
  • Java Interpreter path
  • External or User components 
  • Exchange preferences 
  • Language preferences 
  • Debug and Job execution preferences 
  • Designer preferences
  • Adding code by default 
  • Performance preferences 
  • Documentation preferences 
  • Displaying special characters for schema columns 
  • SQL Builder preferences 
  • Schema preferences
  • Libraries preferences 
  • Type conversion 
  • Usage Data Collector preferences 
  • Customizing project settings 
  • Palette Settings 
  • Version management
  • Status management
  • Job Settings 
  • Stats & Logs 
  • Context settings 
  • Project Settings use 
  • Status settings 
  • Security settings

Designing a Business Model

  • What is a Business Model
  • Opening or creating a Business Model 
  • How to open a Business Model 
  • How to create a Business Model 
  • Modeling a Business Model
  • Shapes 
  • Connecting shapes 
  • How to comment and arrange a model 
  • Business Models 
  • Assigning repository elements to a Business Model
  • Editing a Business Model
  • How to rename a Business Model 
  • How to copy and paste a Business Model 
  • How to move a Business Model 
  • How to delete a Business Model 
  • Saving a Business Model

Designing a Data Integration Job

  • What is a Job design
  • Getting started with a basic Job design 
  • How to create a Job
  • How to drop components to the workspace 
  • How to search components in the Palette 
  • How to connect components together 
  • How to drop components in the middle of a Row link 
  • How to define component properties 
  • How to run a Job 
  • How to customize your workspace 
  • Using connections 
  • Connection types 
  • How to define connection settings 
  • Using the Metadata Manager 
  • How to centralize the Metadata items 
  • How to centralize contexts and variables 
  • How to use the SQL Templates 
  • Handling Jobs: advanced subjects 
  • How to map data flows 
  • How to create queries using the SQLBuilder 
  • How to download/ upload Talend Community components 
  • How to install external modules 
  • How to launch a Job periodically 
  • How to use the tPrejob and tPostjob components 
  • How to use the Use Output Stream feature 
  • Handling Jobs: miscellaneous subjects 
  • How to share a database connection 
  • How to define the Start component 
  • How to handle error icons on components or Jobs 
  • How to add notes to a Job design 
  • How to display the code or the outline of your Job 
  • How to manage the subjob display 
  • How to define options on the Job view 
  • How to find components in Jobs 
  • How to set default values in the schema of an component

Managing Data Integration Jobs

  • Activating/Deactivating a Job or a sub-job 
  • How to disable a Start component 
  • How to disable a nonStart component 
  • Importing/exporting items or Jobs 
  • How to import items
  • How to export Jobs to an archive 
  • How to export items
  • How to change context parameters in Jobs 
  • Managing repository items
  • How to handle updates in repository items 
  • Searching a Job in the repository 
  • Managing Job versions 
  • Documenting a Job 
  • How to generate HTML documentation 
  • How to update the documentation on the spot
  • Handling Job execution 
  • How to deploy a Job on SpagoBI server

Mapping Data Flows

  • tMap and tXMLMap interfaces 
  • tMap operation 
  • Setting the input flow in the Map Editor 
  • Mapping variables 
  • Using the expression editor 
  • Mapping the Output setting Talend Open Studio
  • Setting schemas in the Map Editor 
  • Solving memory limitation issues in tMap use 
  • Handling Lookups 
  • tXMLMap operation 
  • Using the document type to create the XML tree
  • Defining the output mode 
  • Editing the XML tree schema

Managing Metadata

  • Objectives 
  • Setting up a DB connection
  • Step 1: General properties 
  • Step 2: Connection 
  • Step 3: Table upload
  • Step 4: Schema definition   
  • Setting up a JDBC schema
  • Step 1: Generalproperties 
  • Step 2: Connection 
  • Step 3: Table upload
  • Step 4: Schema definition 
  • Setting up a SAS connection  Prerequisites 
  • Step 1: General properties 
  • Step 2: Connection 
  • Setting up a File Delimited schema 
  • Step 1: General properties 
  • Step 2: File upload 
  • Step 3: Schema definition 
  • Step 4: Final schema
  • Setting up a File Positional schema 
  • Step 1: General properties 
  • Step 2: Connection and file upload 
  • Step 3: Schema refining 
  • Step 4: Finalizing the end schema 
  • Setting up a File Regex schema 
  • Step 1: General properties 
  • Step 2: File upload 
  • Step 3: Schema definition 
  • Step 4: Finalizing the end schema 
  • Setting up an XML file schema 
  • Setting up an XML schema for an input file 
  • Setting up an XML schema for an output file 
  • Setting up a File Excel schema 
  • Step 1: General properties 
  • Step 2: File upload 
  • Step 3: Schema refining 
  • Step 4: Finalizing the end schema 
  • Setting up a File LDIF schema 
  • Step 1: General properties 
  • Step 2: File upload
  • Step 3: Schema definition 
  • Step 4: Finalizing the end schema 
  • Setting up an LDAP schema 
  • Step 1: General properties 
  • Step 2: Server connection 
  • Step 3: Authentication and DN fetching 
  • Step 4: Schema definition 
  • Step 5: Finalizing the end schema 
  • Setting up a Salesforce connection 
  • Step 1: General properties 
  • Step 2: Connection to a Salesforce account 
  • Step 3: Retrieving Salesforce modules 
  • Step 4: Retrieving Salesforce schemas 
  • Step 5: Finalizing the end schema 
  • Setting up a Generic schema 
  • Step 1: General properties 
  • Step 2: Schema definition 
  • Setting up an MDM connection 
  • Step 1: Setting up the connection 
  • Step 2: Defining MDM schema 
  • Setting up a Web Service schema 
  • Setting up a simple schema 
  • Setting up an FTP connection 
  • Step 1: General properties 
  • Step 2: Connection

Managing Routines

  • What are routines 
  • Accessing the System Routines 
  • Customizing the system routines 
  • Managing user routines 
  • How to create user routines 
  • How to edit user routines 
  • How to edit user routine libraries 
  • Calling a routine from a Job 
  • Use case: Creating a file for the current date

Using SQL templates

  • What is ELT 
  • Introducing Talend SQL templates 
  • Managing Talend SQL templates 
  • Types of system SQL templates 
  • How to access a system SQL template 
  • How to create userdefined SQL templates 
  • A use case of system SQL Templates

Datawarehousing Concepts

  • ETL Concepts
  • tsortrow
  • tunite
  • tuniqerow
  • tbufferinput
  • tbuffer output
  • thashinput
  • thashoutput
  • tfilelist
  • tsleep
  • tloop
  • file input output components
  • database input output components
  • tsendmail
  • treplicate
  • tfiltercolumns
  • tfilterrows
  • treplace
  • tconverttype
  • tdie
  • tcontextload
  • tmemorizerow
  • trowgenerator
  • trunjob
  • prejob
  • postjob
  • tsamplerows
  • tnormalize
  • tdenormalize
  • tmap
  • taggrigator
  • tjoin
  • tsystem
  • Dynamic
  • tjava
  • tjavarow
  • tjavaflex
  • tschemacompliancecheck
  • tlogrow
  • tlogcatcher
  • t ststcatcher
  • tparallelize
  • tsendmail
  • tfilecopy
  • tfilearchive
  • tfileProperties
  • tfileunarchive
  • tfiletouch
  • tfiledelete
  • tfileexist
  • tfiletouch
  • tfilecopy
  • tftpfilelist
  • tftpput
  • tftpget
  • tftpdelete
  • tftpfileexist
  • tftpConnection
  • tftpRename
  • tftpfileproperties
  • toracleInput
  • toraclerow
  • toracleoutpt
  • toracleconnection
  • toracleBulk
  • toracleBulkexec
  • toracleClose
  • toracleRollback
  • toraclecommit
  • tmssqlInput
  • tmssqlrow
  • tmssqloutpt
  • tmssqlconnection
  • tmssqlBulk
  • tmssqlBulkexec
  • tmssqlClose
  • tmssqlRollback
  • tmssqlcommit
  • tDb2Input
  • tDb2row
  • tDb2outpt
  • tDb2connection
  • tDb2Bulk
  • tDb2Bulkexec
  • tDb2Close
  • tDb2Rollback
  • tDb2commit
  • OnsubJobOK
  • OnSubjobError
  • OnComponentOk
  • OnComponentError
  • runif
  • tExcelInput
  • tExceloutput
  • tfileInputdelimited
  • tfileoutputDelimited
  • tfileInputXml
  • tfileoutputXml
  • tfileinputPositional
  • tfileOutputPositional
  • SCD1
  • SCD2
  • SCD3
  • stage loading
  • Dimension Loading 
  • fact Loading 
  • project Explanation

Practice Test & Interview Questions

Instructors

Mr Mahesh
Instructor
Mindmajix Technologies

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books