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 (optional), Hive (optional), 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

Note

  • To request a customized training for this course, please contact us to arrange.

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 (optional)

Using Talend with Hadoop (optional)

Using Talend with Pig and Kafka

Using Talend with Web Services

Advanced WSDL Processing

Documenting the Job

Exporting a Job

Troubleshooting

Summary and Conclusion

Testimonials

★★★★★
★★★★★

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £5000

Private Remote

From £4400 (96)

Public Classroom

Location Date Course Price [Remote/Classroom]
Leeds2018-10-30 09:30£ N/A / £ 5800
Cardiff2018-11-05 09:30£ N/A / £ 5600
Reading TVP2018-11-05 09:30£ N/A / £ 5460
Belfast City Centre2018-11-05 09:30£ N/A / £ 6200
Portsmouth2018-11-05 09:30£ N/A / £ 5000
Glasgow2018-11-06 09:30£ N/A / £ 5800
Newcastle2018-11-06 09:30£ N/A / £ 5200
Manchester, King Street2018-11-06 09:30£ N/A / £ 5700
Swindon2018-11-12 09:30£ N/A / £ 5100
Swansea- Princess House2018-11-13 09:30£ N/A / £ 5000
St Helier, Jersey, Channel Isles2018-11-13 09:30£ N/A / £ 6300
Plymouth Drake Circus2018-11-19 09:30£ N/A / £ 5000
York - Priory Street Centre 2018-11-19 09:30£ N/A / £ 5000
Exeter - The Senate2018-11-26 09:30£ N/A / £ 5600
Birmingham 2018-12-03 09:30£ N/A / £ 5700
Bristol, Temple Gate2018-12-04 09:30£ N/A / £ 5400
Southampton2018-12-04 09:30£ N/A / £ 5400
Cambridge2018-12-04 09:30£ N/A / £ 5300
Bradford - Carlisle Business Centre2018-12-04 09:30£ N/A / £ 5400
Edinburgh Training and Conference Venue2018-12-10 09:30£ N/A / £ 5200
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Jenkins: Continuous Integration for Agile Development Manchester, King Street Thu, 2018-10-18 09:30 £2574 / £3224
Introduction to Recommendation Systems Swansea- Princess House Thu, 2018-10-18 09:30 £990 / £1140
Advanced Statistics using SPSS Predictive Analytics Software Birmingham Mon, 2018-10-22 09:30 £5148 / £6448
Building Augmented Reality Applications with Vuforia and Unity Glasgow Wed, 2018-10-24 09:30 £2178 / £2878
Impact Evaluation – Quantitative Analysis London, Hatton Garden Wed, 2018-10-24 09:30 £2574 / £3324
Statistics with SPSS Predictive Analytics Software Cambridge Thu, 2018-11-01 09:30 £2574 / £3024
Programming in Scala Cambridge Thu, 2018-11-01 09:30 £2178 / £2628
CakePHP: Rapid Web Application Development Birmingham Tue, 2018-11-06 09:30 £4356 / £5656
AWS: A Hands-on Introduction to Cloud Computing Brighton Wed, 2018-11-07 09:30 £1287 / £1487
JMeter Fundamentals and JMeter Advanced Edinburgh Training and Conference Venue Mon, 2018-12-03 09:30 £2178 / £2578
HAProxy Administration London, Hatton Garden Mon, 2018-12-03 09:30 £2178 / £2928
Social Media Marketing Oxford Wed, 2018-12-12 09:30 N/A / £1364
Test Automation with Selenium Manchester, King Street Wed, 2018-12-12 09:30 £3267 / £4242

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.

Some of our clients

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!