Talend Training in Bangalore

Talend Training

LIVE

30 Hours

Book a Free Demo

Course offered by Uplatz

0 review

overview batches reviews

Talend Data Integration Basics

Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. With integrated connectors to source and target systems, it enables rapid deployment and reduces maintenance costs. It supports all types of data integration, migration, and synchronization.

This course helps you use Talend Studio for Data Integration as quickly as possible. It focuses on the basic capabilities of Studio and how you can use it to build reliable, maintainable data integration tasks that solve practical problems, including extracting data from common database and file formats, transforming it, and integrating it into targets.

This course serves as a prerequisite for many other Talend courses, and the skills learned apply to most Talend products.

Duration	2 days (14 hours)
Target audience	Anyone who wants to use Talend Studio to perform data integration tasks: software developers and development managers
Prerequisites	Basic knowledge of computing, including familiarity with Java or another programming language, SQL, and general database concepts
Course objectives	After completing this course, you will be able to: Create a project Create and run a Job that reads, converts, and writes data Merge data from several sources within a Job Save a schema for repeated use Create and use metadata and context variables within Jobs Connect to, read from, and write to a database from a Job Access a web service from a Job Work with master Jobs and subJobs Build, export, and test-run Jobs outside Studio Implement basic error-handling techniques Use best practices for Job and component naming, hints, and documentation
Course agenda	Getting started with Talend Data Integration Starting Talend Studio Creating your first Job Running a Job Using the component help Designing a Job using best practices Documenting a Job Working with files Working with delimited files Working with hierarchical files Working with databases Creating tables in MySQL databases Reading data from MySQL database tables Applying best practices Using repository metadata Using delimited file metadata Using XML file metadata Using database metadata Using generic schemas Updating metadata Processing data Mapping data using tMap Joining data using tMap Capturing join rejects Filtering data and capturing filtering rejects Using other data processing components Using contexts and context variables Creating a built-in context variable Connecting to databases using context variables Creating a context group in the repository Loading context variables from a flow Building executables and Docker images from data integration Jobs Building a stand-alone Job Building a new version of the Job Building a Docker image Controlling execution Managing files Processing files Managing Job execution using a master Job Handling errors Detecting and handling basic errors Raising a warning Working with web services Accessing a SOAP web service Use case: Creating a master sales table from different data sources Setting up a customer table First challenge Setting up a sales table Joining data Performing calculations Second challenge Creating a master Job

Talend Data Integration Advanced

Talend Data Integration provides an extensible, highly scalable set of tools for accessing, transforming, and integrating data from any business system. This course enables you to use the more advanced features of Talend Data Integration as quickly as possible. Participants can work in teams on projects shared on a remote repository to monitor Jobs and database changes.

Duration	1 day (7 hours)
Target audience	Anyone who wants to use Talend Data Integration to perform data integration and management tasks: software developers and development managers
Prerequisites	Completion of Talend Data Integration Basics and knowledge of computing, including familiarity with Java or another programming language, SQL, and general database concepts
Course objectives	After completing this course, you will be able to: Start Talend Studio and connect it to a remote repository Use SVN branches in Studio Run a Job in Studio or on a remote JobServer Monitor host CPU and JVM memory in real time during Job execution Use debugging features in Studio Configure a Talend project to capture statistics and logs, and monitor them from Activity Monitoring Console (AMC) Implement several methods of parallel execution in a Talend Job Create Joblets Create a unit test from a working Job Configure a database to monitor and log changes in a separate change data capture (CDC) database Use the CDC database to perform incremental updates between the source and target Set up a reference project in order to use items from another project
Course agenda	Connecting to a remote repository Creating a remote connection SVN in Studio Copying a Job to a branch Comparing Jobs Resetting a branch Reference project Setting up and using a reference project Remote Job execution Creating and running a Job remotely Resource usage and basic debugging Using Memory Run to view real-time resource usage Debugging Jobs using Debug Run Activity Monitoring Console (AMC) Configuring statistics and logging Using Activity Monitoring Console (AMC) Parallel execution Writing large files Writing to databases Automatic parallelization Partitioning Joblets Creating a Joblet from an existing Job Creating a Joblet from scratch Triggering Joblets Unit test Creating a unit test Change data capture Examining databases Configuring the CDC database Monitoring changes Updating a warehouse Resetting the database