Hands-On Talend ETL - Zero to Hero - Add value to your data

Click here to start the Course

What you'll learn
lconnect your data sources between to each other
build your own integration processes using practical examples and scenarios
learn the most important transformations
process files, databases, XML, web services and many other formats
use variables to control the execution
Establish best practices
Create comprehensive documentation

Description
Data. Everywhere. All well-behaved in their own environment. But who actually lets them talk to each other? You do. With data integration. Become a data savant and add value with ETL and your new knowledge!

Talend Open Studio is an open, flexible data integration solution. You build your processes with a graphical editor and over 600 components provide flexibility.

Each section has a practical example and you will receive this complete material at the beginning of the course. So you can not only view each section, but also compare it to your own solution. There are also extensive practical scenarios included. So you'll be well equipped for practice!

What are the biggest topics you can expect?

Installation on different operating systems (Windows, Linux, Mac)

understanding and using important data types

reading and writing from databases

process different file formats, like Excel, XML, JSON, delimited, positional

create and use metadata

build schemas

use helpful keyboard shortcuts

retrieve data from WebServices

connect to GoogleDrive and fetch data

using iteration and loops

convert data flows into iterations

build and understand job hierarchies

All major transformations: Map, join, normalize, pivot, and aggregate data

create and extract XML and JSON

use regular expressions

Orchestrate components in processes

Check and improve data quality

Use fuzzy matching and interval matching

Use variables for different environments

Perform schema validation

Handle reject data separately

Find and fix errors quickly

Write meaningful logs

Include and react to warnings and aborts

Build job hierarchies and pass data between different levels

implement and test your own assumptions

configure your project for logging, versioning and context loading

learn best practices and establish your own

document items and have documentation generated

What are you waiting for? See you in the course!

Who this course is for:
you dream of data
you're a data nerd
you are interested in a career in data space
you want to get more out of your data quickly and easily
you want to get added value from your data
you have challenges to let your data talk to each other
you finally master the data chaos
you finally want to understand ETL