Duration

2 days

 

 

Next session

February 7-8, 2024

 

Price

Indicative price: €1 excluding tax

Intra price: on estimate

 

 

 

SQL Server tool

Talend Open Studio Training - Level 1

Talend Open Studio is an Open Source ETL solution to effectively respond to a very wide range of needs: extraction of source data, injection of target data, multiplicity of data formats used, transformation and control of data, etc.
This training allows you to understand the concepts and operation of Talend Open Studio and to gain autonomy on your projects.

 

TALEND TRAINING : AUDIENCE AND PREREQUISITES

  • This beginner level training is aimed at any professional who needs to manipulate data with Talend Open Studio
  • Basics in SQL and/or JAVA are a plus

 

TRAINING TALEND : GOALS 

  • Know how to create a flow from A to Z
  • Learn to manage different source data, extract them, manipulate them, transform them and integrate them

 

TRAINING TALEND : THE PROGRAM

Accompanied by our trainer, you will see during these courses:

DAY 1 “Hello Talend”
What is Talend?
  • Talend: an ETL tool
  • A little bit of history
  • The reasons for success
The main concepts
  • Data flow
  • Repository
IDE Overview
  • Metadata
  • Groups of variables and contexts
  • The codes
  • SQL models
  • The jobs
DAY 2 The heart of Talend
Feeding methods
  • BULK method
  • ETL method
  • ELT method
  • ….And many others
The main components
  • Orchestration, code and miscellaneous
  • files
  • Data base
  • Data processing
  • Log and error
Tips and tricks
  • Talend limitation and prerequisites
  • A few tips
  • Trades

 

TRAINING TALEND : THE DURATION 

Two day training

 

Practical information : Our computer training courses are maintained from one participant and they can be carried out with us or with you.

To discover our other courses, click here

 

Accessibility for people with disabilities

PEAKS training courses are accessible to everyone. Our training sites have access for people with reduced mobility and tailor-made support is offered to allow anyone with a disability, whatever it may be, to follow our training courses in the best conditions.
Please contact Kildine Tan, our training referent who will study your request and its feasibility with our disability referent, Emmanuelle Mort-Bontemps.

Our training courses are rated 9,16/10 by our participants

How to finance your training project? Pratical information

Feedback

OUT

“The training, delivered in a small group, was dynamic, balanced and very interesting. “ 

“The trainer was able to answer all our questions and take the time to come and help us if we were stuck during practice”

“Great to be able to directly put into practice the concepts presented via exercises between each chapter. »

“Trainer mastering his subject, who explains well with content adapted to my objective of discovering Kubernetes. »

“The trainer was enthusiastic and pedagogical. The progressive structure of the information and its pedagogy allowed us to assimilate all the notions seen. In our professional daily life, we are now able to use TS in the Alfresco environment! »

“Trainers available to answer all our questions and help us overcome our blockages during practice times. »

“A lot of practice, and straight to the point. »