Data Integration & ETL with Talend Open Studio Zero to Hero

Focused View

Samuel Lenk | Certified Talend Developer & Java/SQL/Data Developer

8:10:14

89 View

01 - Course Overview

001 Course Overview.mp4

02:00

002 10 Minutes Talend.mp4

11:55

003 Udemy Tipps.mp4

01:27

02 - Data Integration and ETL

001 Why Data Integration.mp4

02:10

03 - Setup For The Course

001 Intro.mp4

00:29

002 Installation on Windows, MacOS or Linux.mp4

07:37

003 Language of Talend Open Studio.mp4

01:15

004 Import the Course Project.mp4

01:37

004 talendBasicsProjectExport.zip

005 Download the Course Files.mp4

00:57

005 talendBasicsData.zip

006 Explore the Course Project.mp4

02:06

external-links.txt

04 - Hello World Example

001 Intro.mp4

00:17

002 Hello world in Talend.mp4

02:51

external-links.txt

05 - The User Interface (UI)

001 Intro.mp4

00:31

002 Important Parts of the UI.mp4

04:28

003 Useful Helpers.mp4

08:45

004 Install External Libraries.mp4

01:49

005 Find Errors.mp4

04:03

006 Where is my tab.mp4

01:32

06 - Your First ETL Job

001 Intro.mp4

00:20

002 Your first job.mp4

08:22

003 Get Component Help.html

07 - Process Files

001 Intro.mp4

00:24

002 Read Files.mp4

05:40

003 Write Files.mp4

08:51

004 List Folder Contents.mp4

05:11

005 File Processing Scenario.mp4

12:02

external-links.txt

08 - Properties In Talend

001 Intro.mp4

00:17

002 Built-In vs. Repository.mp4

03:42

003 Schema.mp4

03:24

004 Data Types.mp4

06:33

005 Connection Types.mp4

08:58

006 Ctrl + Spacebar.mp4

01:53

09 - Processing Databases

001 Intro.mp4

00:22

002 Your database.mp4

00:59

003 Connect to a Database.mp4

03:26

004 Write to a Database.mp4

05:03

005 Read from a Database.mp4

04:07

006 Iterate over Database Contents.mp4

04:09

007 Database Processing Scenario.mp4

07:37

10 - Process Cloud, REST, JSON, XML, etc

001 Intro.mp4

00:21

002 Process JSON.mp4

08:24

003 Process XML.mp4

06:33

004 Google Drive.mp4

10:05

005 Google Cloud Storage.mp4

06:00

006 REST Services.mp4

08:25

007 Download Files.mp4

02:38

008 Read RSS feeds.mp4

01:33

external-links.txt

11 - Variables

001 Intro.mp4

00:27

002 Create Context Variables.mp4

03:59

003 Create Variables and Environments.mp4

02:47

004 Data Types for Context Variables.mp4

03:19

005 Central Context Groups.mp4

03:16

006 Context Groups for Metadata.mp4

04:24

007 Write and Load Context.mp4

06:13

008 Implicit Context Load.mp4

02:51

009 Global Variables.mp4

02:25

12 - Transformations

001 Intro.mp4

00:43

002 Filter Data.mp4

05:35

003 Sort Data.mp4

05:37

004 Aggregate Data.mp4

03:15

005 Convert Data Types.mp4

06:43

006 Split Data.mp4

05:20

007 Normalization and De-Normalization.mp4

10:37

008 Simple Joins.mp4

06:36

009 Install Sakila.mp4

05:06

010 Mapping with Join.mp4

08:09

011 Mapping with Filter.mp4

05:08

012 Mapping with Transformation.mp4

05:03

013 Field extraction Intro.mp4

07:32

014 Field Extraction JSON.mp4

04:46

015 Field Extraction XML.mp4

04:38

016 Field Extraction Positional.mp4

04:21

017 Field Extraction Delimited.mp4

03:18

018 Field Extraction Regex.mp4

05:07

019 Field Extraction Outro.mp4

01:31

020 Generate XML and JSON Fields.mp4

04:37

021 Generate Sample Data.mp4

03:10

022 Pivot Data.mp4

01:59

external-links.txt

13 - Data Quality

001 Intro.mp4

00:19

002 Remove Duplicates.mp4

01:37

003 Interval Match.mp4

02:55

004 Make Replacements.mp4

02:05

005 Schema Checking.mp4

02:54

006 Redundancy Key.mp4

01:42

007 Fuzzy Matching.mp4

04:23

external-links.txt

14 - File Management

001 Intro.mp4

00:17

002 Basic Operations.mp4

02:18

003 File Comparison.mp4

02:46

004 File Properties.mp4

03:01

005 File Lists.mp4

01:19

006 File Compression.mp4

01:33

007 Temporary Files.mp4

01:33

external-links.txt

15 - Job Orchestration

001 Intro.mp4

00:16

002 Pre-Job and Post-Job.mp4

03:24

003 MessageBox.mp4

02:07

004 Replicate and Unite.mp4

03:29

005 Flow to Iteration and Iteration to Flow.mp4

03:24

006 Loops.mp4

03:37

007 Wait and Measure.mp4

03:06

008 System Interaction.mp4

02:09

009 Job Hierarchies.mp4

07:25

010 Subjob Triggers.mp4

03:34

011 Component Triggers.mp4

02:21

012 Conditional Triggers.mp4

02:37

16 - Logging

001 Intro.mp4

00:19

002 Debug Data.mp4

01:52

003 Test Assertions.mp4

02:29

004 Log Data Volumes.mp4

02:20

005 Log Errors and Warnings.mp4

02:35

006 Log Executions.mp4

02:24

007 Logging Jobs.mp4

03:39

008 Logging Jobs Better.mp4

02:43

009 Logging Projects.mp4

02:56

17 - Best Practices & Documentation

001 Intro.mp4

00:20

002 Common Best Practices.mp4

07:04

003 Create Documentation.mp4

05:36

18 - Deployment

001 Intro.mp4

00:24

002 Create Job Executables.mp4

04:01

003 Change Parameters for Executables.mp4

01:31

19 - Project Handling

001 Intro.mp4

00:20

002 Create and Delete Projects.mp4

02:54

003 Export and Import Items.mp4

04:28

004 Filtering Projects and Components.mp4

02:55

005 Project Settings.mp4

06:28

20 - Use Cases

001 Intro.mp4

00:25

002 Write an Excel file.mp4

00:51

003 Read a Multi-Schema XML.mp4

02:26

004 Append to a Text File.mp4

02:37

005 Sync Tables with Talend.mp4

06:55

005 tablesSyncJobs.zip

006 Read Vault Credentials.mp4

16:53

21 - Course Summary

001 Congratulations.mp4

00:55

22 - Extra Material

001 Talend Cheatsheet.mp4

00:33

001 Talend-Cheatsheet-ENG.pdf

002 A Small Test.mp4

02:29

003 A Big Test.mp4

02:28

004 Template Job.mp4

00:33

005 Bonus Lecture.html

Description

Add value to your data - with Talend Open Studio for Data Integration, ETL, Data Warehousing, Data Migration, BI

What You'll 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 is this for?

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

What You Need to Know?

Interest in data and bringing it together

Computer/Laptop with 8+GB RAM and Java 11

your database to use in the course (MySQL, PostgreSQL, or similar)

More details

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 /Â 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 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 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

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Samuel Lenk | Certified Talend Developer & Java/SQL/Data Developer

Instructor's Courses

Hi, my name is Samuel.I am solution developer in the data universe and have been working in this field for 12+ years. I started this journey after studying computer sciences, specialized in business informatiuon systems.Now I am constantly getting the most out of data, using Talend, Java, SQL, Python, JSON, and many more.It's a pleasure for me to share my knowledge with you!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.