HOT

Data Integration & ETL with Talend Open Studio Zero to Hero

Development

Rating4.5
Enroll Now

Data Integration & ETL with Talend Open Studio Zero to Hero, available at $84.99, has an average rating of 4.53, with 138 lectures, 7 quizzes, based on 1493 reviews, and has 10597 subscribers.

You will learn about connect your data sources, such as files, databases, XML, web services, Google Drive and more formats build your own integration processes using practical examples and comprehensive scenarios master the most important transformations like mappings, joins, aggregations and sorting orchestrate processes into larger units by using preJobs, postJobs, variable and hierachies This course is ideal for individuals who are you want to bring together different data sets quickly and easily or you have challenges to let your data talk to each other or you are interested in a career in data space or future ETL developers It is particularly useful for you want to bring together different data sets quickly and easily or you have challenges to let your data talk to each other or you are interested in a career in data space or future ETL developers.

Enroll now: Data Integration & ETL with Talend Open Studio Zero to Hero

Summary

Title: Data Integration & ETL with Talend Open Studio Zero to Hero

Price: $84.99

Average Rating: 4.53

Number of Lectures: 138

Number of Quizzes: 7

Number of Published Lectures: 138

Number of Published Quizzes: 7

Number of Curriculum Items: 152

Number of Published Curriculum Objects: 152

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

  • connect your data sources, such as files, databases, XML, web services, Google Drive and more formats
  • build your own integration processes using practical examples and comprehensive scenarios
  • master the most important transformations like mappings, joins, aggregations and sorting
  • orchestrate processes into larger units by using preJobs, postJobs, variable and hierachies

Who Should Attend

  • you want to bring together different data sets quickly and easily
  • you have challenges to let your data talk to each other
  • you are interested in a career in data space
  • future ETL developers

Target Audiences

  • you want to bring together different data sets quickly and easily
  • you have challenges to let your data talk to each other
  • you are interested in a career in data space
  • future ETL developers

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 valuewith 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 / REST

  • 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 matchingand 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!

Course Curriculum

Chapter 1: Course Overview & 10 Minutes Talend

Lecture 1: Course Overview

Lecture 2: 10 Minutes Talend

Lecture 3: Udemy Tipps

Chapter 2: Data Integration and ETL

Lecture 1: Why Data Integration?

Chapter 3: Setup For The Course

Lecture 1: Intro

Lecture 2: Installation on Windows, MacOS or Linux

Lecture 3: Language of Talend Open Studio

Lecture 4: Import the Course Project

Lecture 5: Download the Course Files

Lecture 6: Explore the Course Project

Chapter 4: "Hello World" Example

Lecture 1: Intro

Lecture 2: "Hello world" in Talend

Chapter 5: The User Interface (UI)

Lecture 1: Intro

Lecture 2: Important Parts of the UI

Lecture 3: Useful Helpers

Lecture 4: Install External Libraries

Lecture 5: Find Errors

Lecture 6: Where is my tab?

Chapter 6: Your First ETL Job

Lecture 1: Intro

Lecture 2: Your first job

Lecture 3: Get Component Help

Chapter 7: Process Files

Lecture 1: Intro

Lecture 2: Read Files

Lecture 3: Write Files

Lecture 4: List Folder Contents

Lecture 5: File Processing Scenario

Chapter 8: Properties In Talend

Lecture 1: Intro

Lecture 2: Built-In vs. Repository

Lecture 3: Schema

Lecture 4: Data Types

Lecture 5: Connection Types

Lecture 6: Ctrl + Spacebar

Chapter 9: Processing Databases

Lecture 1: Intro

Lecture 2: Your database

Lecture 3: Connect to a Database

Lecture 4: Write to a Database

Lecture 5: Read from a Database

Lecture 6: Iterate over Database Contents

Lecture 7: Database Processing Scenario

Chapter 10: Process Cloud, REST, JSON, XML, etc.

Lecture 1: Intro

Lecture 2: Process JSON

Lecture 3: Process XML

Lecture 4: Google Drive

Lecture 5: Google Cloud Storage

Lecture 6: REST Services

Lecture 7: Download Files

Lecture 8: Read RSS feeds

Chapter 11: Variables

Lecture 1: Intro

Lecture 2: Create Context Variables

Lecture 3: Create Variables and Environments

Lecture 4: Data Types for Context Variables

Lecture 5: Central Context Groups

Lecture 6: Context Groups for Metadata

Lecture 7: Write and Load Context

Lecture 8: Implicit Context Load

Lecture 9: Global Variables

Chapter 12: Transformations

Lecture 1: Intro

Lecture 2: Filter Data

Lecture 3: Sort Data

Lecture 4: Aggregate Data

Lecture 5: Convert Data Types

Lecture 6: Split Data

Lecture 7: Normalization and De-Normalization

Lecture 8: Simple Joins

Lecture 9: Install Sakila

Lecture 10: Mapping with Join

Lecture 11: Defining the match model for an explicit Join in tMap

Lecture 12: Mapping with Filter

Lecture 13: Mapping with Transformation

Lecture 14: Field extraction: Intro

Lecture 15: Field Extraction: JSON

Lecture 16: Field Extraction: XML

Lecture 17: Field Extraction: Positional

Lecture 18: Field Extraction: Delimited

Lecture 19: Field Extraction: Regex

Lecture 20: Field Extraction: Outro

Lecture 21: Generate XML and JSON Fields

Lecture 22: Generate Sample Data

Lecture 23: Pivot Data

Chapter 13: Data Quality

Instructors

  • Samuel Lenk
    Samuel Lenk
    Talend • SQL • Java • Linux • Google Cloud Platform (GCP)

Rating Distribution

  • 1 stars: 17 votes
  • 2 stars: 20 votes
  • 3 stars: 145 votes
  • 4 stars: 543 votes
  • 5 stars: 768 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Master Lead Generation: Grow Subscribers & Sales with Popups

Create CONVERTING UGC Content So Brands Will Pay You More

TikTok Marketing Mastery: Learn to Grow & Go Viral