Talend Advanced for Big Data, Cloud and Database Integration

Name: Talend Advanced for Big Data, Cloud and Database Integration
Rating: 4.7 (199 reviews)

Advanced Talend course with Talend Open Studio for Big Data, Cloud, ELT, SCD, Java, Amazon, Performance, Kafka, MongoDB

Highest Rated

Created bySamuel Lenk, Diamond Training

Last updated 3/2026

English

What you'll learn

connect to Big Data and Cloud systems like Snowflake, Amazon S3 and MongoDB
use advanced database features, such as stored procedures, bulk loading, ELT, SCD
use custom Java code, libraries and external components
use existing routines and learn many types of data conversions

Course content

12 sections • 58 lectures • 8h 2m total length

Course Overview3:25
Udemy Tipps1:27

Install Talend Open Studio for Big Data7:37
Quick Tip: Change Console Text Font and Size1:29
Setting the Language of Talend Open Studio1:25
Import And Explore The Course Project3:33
Import the Talend advanced course project by downloading the archive and importing it into Talend Studio. Then explore how sections map to job designs to compare component settings.
Project import fails - Solutions1:18
If the project import doesn't work for you, you can find help in this article.
Download The Sample Files2:21

Database Connection8:25
Schema Handling8:08
Data Type Mappings3:57
Bulk Load15:58
ELT vs. ETL18:21
Learn how to build ELT jobs in Talend by loading data into a database and transforming in-database using ELT components, including mapping, self-joins, and generated SQL.
Stored Procedures (SP)9:24
Slowly Changing Dimensions (SCD)18:55
Transactions21:37
Output Rejects13:20
Output Rejects for other databases than MySQL0:16

Apache Kafka12:56
Learn to integrate Apache Kafka with Talend using the quickstart, creating a Kafka consumer and producer, configuring zookeeper and brokers, and exchanging messages on the quickstart-events topic.
Apache Cassandra15:01
MongoDB15:40
Google BigQuery13:16
Snowflake10:18
Amazon S38:18
Learn how to connect to Amazon S3, upload a local file to a bucket, and list bucket objects with S3List, using static credentials in a Talend job workflow.

General Conversions10:19
Learn data type conversions in Talend and Java, including widening and narrowing conversions, precision concerns with doubles and floats, and using BigDecimal plus string formatting.
Convert Strings5:40
Learn to convert strings in Talend by leveraging Java's string methods, such as length, toLowercase, trim, and strip, in tJava and tMap workflows.
Avoid NullPointerExceptions10:37

tJava Component3:02
tJavaRow Component6:47
tJavaFlex Component9:37
Java Properties3:58
Learn to use and access system and Java properties in Talend, including retrieving user names, environment variables, and file separators, to adapt jobs across OSes and environments.
Use External Libraries7:48
Learn to load an external Java library in Talend using the library load component from a Maven repository or internal source; apply string utils to reverse, capitalize, and handle nulls.
Use External Components7:11

Nested Conditions with Ternary Operator and If Statements17:32
Read Large XML Files quickly15:23
Iterate Over Date And Time13:06
Currency Conversion With REST Service13:33
Convert euros to USD using a rest service in Talend by calling the api layer convert endpoint with current exchange rate, and processing the json response using an api key.
Access Previous Row in a data flow5:42
Cancel Jobs With tJavaRow9:38
Add File Header And Footer3:38
Learn to add a file header and footer in Talend, including header lines, a separator, and a meta footer for multiple data sets using a single output file.
Data Tests4:50

Requirements

you finished my Talend basics course or have good foundational knowledge of Talend Open Studio
you want to use Talend Open Studio professionally
Laptop with 8+GB RAM and Java 11
your database to use in the course (MySQL, PostgreSQL, or similar)

Description

You already know the basics of data integration and ETL. But that's not enough for you. Here's where you deepen your knowledge in this area with Talend. This way you will have a steep learning curve.

The course on advanced Talend topics is extremely hands-on. From start to finish, you can work on your own. Each video is accompanied by the corresponding example. You import the complete course project into your environment at the beginning. This ensures that you can always compare your own jobs designs with a sample solution.

The range of advanced topics is wide, but well structured in the best possible way for you. Among other things, the following points await you:

use Big Data and Cloud components to connect to Amazon S3, Google BigQuery, Snowflake, MongoDB, Apache Cassandra, Apache Kafka
design ELT processes and know the difference to ETL
build Slowly Changing Dimensions (SCD) to historize data
call stored procedures on a database from Talend
use memory components like tBufferInput and tHashOutput
deepen your knowledge of converting data types
get started with Java code in Talend
learn if-conditions with their abbreviated notation
learn to avoid NullPointerExceptions
convert strings in many forms easily
include your own code via routines
use Java components like tJava, tJavaRow and tJavaFlex
add external components to Talend
learn how to load and use external libraries
access other sources, such as FTP, eMail, etc.

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

Who this course is for:

anyone who really wants to use Talend professionally
developers with a basic Talend know how who want to continue on a steep learning curve
ambitious developers who want to get more out of their data

Talend Advanced for Big Data, Cloud and Database Integration

What you'll learn

Explore related topics

Course content

Course Introduction2 lectures • 5min

Setup Your Environment6 lectures • 18min

Using Advanced Database Techniques10 lectures • 1hr 58min

Big Data And Cloud6 lectures • 1hr 15min

More Integrations Types2 lectures • 16min

Convert Data Types3 lectures • 27min

Use Talend And Custom Routines5 lectures • 58min

Custom Java Code6 lectures • 38min

Performance7 lectures • 41min

Use Cases8 lectures • 1hr 23min

Requirements

Description

Who this course is for: