OpenCourser
Learn skills that shape your future
Visit OpenCourser.com
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.
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 See you in the course.
You will get a quick overview of the course structure.
See your first 10 Minutes ETL in Talend Open Studio
Know the key points to get the most out of the course.
You will see why data integration is important.
Test your knowledge on some basics of data integration
You will get an overview of this section.
We review the steps of installing Talend Open Studio on Windows, Mac and Linux.
Change the interface language of Talend Open Studio to English, because translations are incomplete and the whole course project is in English.
Import the complete project for this course. This way you can compare any setting of any job of any video throughout the complete course.
With the archive attached to this lecture you obtain all files for the course.
We take a look at the structure of the course project.
Let's create a very easy "hello world" example to get you going.
Get a brief overview of the UI structure in Talend Open Studio.
Get to know some useful shortcuts and functionalities to start working effectively with Talend.
Some components need external libraries which can easily be installed.
Get some tips and tricks on how to resolve errors easier in Talend.
Shows you how to restore a tab once (accidentally) closed
We will build a more complete job together. It contains data creation, transformation and output.
Read many types of files easily in Talend.
We will see how to write a Excel file. But you can create many other formats as well.
List folder content by using search patterns. This way you can easily process several files with the same structure.
We will read, write and iterate over files. This will be extended by using variables and checking file existence before doing the actual work.
You learn the differences between "BuiltIn" and "Repository" information.
Learn what a "schema" is in Talend and how to use it effectively.
You will get an overview of some important data types.
You will get an overview of the different row and trigger connection types and their usage in Talend.
Learn the most important key shortcut and how to use it properly.
Test your knowledge about Talend Open Studio properties
Lets see which database you'll use for the following examples.
You will learn how to connect to a database using Talend.
You will write some data to a table in a database.
You will read some data from a table in a database.
You will list some some database objects of a certain type.
This scenario shows you how to make a lookup and output the result into a database.
You will learn how to read a JSON file with and without loops.
You will learn how to read XML files with loops.
You will learn how to access Google Drive folders using Talend.
You will learn how to access Google Cloud storage using Talend.
Learn how to use a REST service in Talend.
You will learn how to use Talend to download files from the web.
You will learn how to read RSS feeds in Talend.
Do you know which component is for what?
Learn an easy shortcut to create context variables in Talend.
Create variables and environments for variables (= "contexts") in your job.
You will learn what data types variables can have.
Learn how to store your variables in context groups in a central place.
You will learn to create context groups for metadata items very easily.
Talend allows you to load variables from an external source. Learn how to do that.
With an easy setting you can load variables implicitly. Learn how!
Learn what global variables are and how to use them.
Test your knowledge about variables!
You will see how to filter columns and rows in Talend.
Learn how to sort data of type date, numeric and alphanumeric.
You will learn how to create sums, averages and other aggregate values with Talend.
Learn some important data type conversions and some common traps.
Learn how to split data row-wise or data-wise in Talend
You will learn how to normalize and de-normalize values in Talend.
You will learn how to use tJoin in Talend for simple joins.
You will see how to install Sakila sample database. We will use this data for the next couple of examples.
Learn how to join data over more than 2 levels using tMap.
Learn how to filter data in tMap.
Learn how to transform data in a tMap.
We will do the PreJob and PostJob setup for this scenario.
You will learn how to use tExractJSONFields component to parse JSON data.
You will learn how to use tExractXMLFields component to parse XML data.
You will learn how to use tExractPositionalFields component to parse positional data.
You will learn how to use tExractDelimitedFields component to parse delimited data.
You will learn how to use tExractRegexFields component to parse data using regular expressions.
We will make a short summary of the field extraction components scenario.
Learn how to create JSON and XML fields using the corresponding components.
Learn two ways to generate sample data in Talend.
Learn how to pivot data in Talend.
Test your knowledge by answering this transformations quiz!
Save
Covers a wide range of topics from basics to advanced ETL techniques.
Concepts are presented clearly, making complex topics digestible.
Strong emphasis on real-world scenarios and practical exercises.
Highly accessible and a great starting point for new learners.
Verified partner policies & purchase protections
Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).
30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.
Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
Get offer
