Talend Open Studio for Data Integration Training Course

Course Code

TalendDI

Duration

28 hours (usually 4 days including breaks)

Requirements

  • An understanding of relational databases
  • An understanding of data warehousing
  • An understanding of ETL (Extract, Transform, Load) concepts

Overview

Talend Open Studio for Data Integration is an open-source data integration product used to combine, convert and update data in various locations across a business.

In this instructor-led, live training, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig.
 
By the end of this training, participants will be able to

  • Explain the concepts behind ETL (Extract, Transform, Load) and propagation
  • Define ETL methods and ETL tools to connect with Hadoop
  • Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements
  • Upload to and extract large records from Hadoop, Hive, and NoSQL databases

Audience

  • Business intelligence professionals
  • Project managers
  • Database professionals
  • SQL Developers
  • ETL Developers
  • Solution architects
  • Data architects
  • Data warehousing professionals
  • System administrators and integrators

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline

Introduction

Understanding Data Integration, Data Modeling and Propagation

Setting up Talend Open Studio

Creating a Job in Talend

Carrying Out Basic Transformations

Building a Business Model

Creating Metadata in Talend

Creating and Managing Joins

Carrying Out Advance Transformations

Executing Jobs remotely

Handling Errors in Talend

Connecting Talend with a Database

Querying Data with Hive

Using Talend with Hadoop

Using Talend with Pig and Kafka

Using Talend with Web Services

Advanced WSDL Processing

Documenting the Job

Exporting a Job

Troubleshooting

Summary and Conclusion

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £5000

Private Remote

From £4400 (103)

Public Classroom

Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.