Data Engineering and Data Integration Tools

Data Engineering and Data Integration Tools, available at $49.99, has an average rating of 4.3, with 21 lectures, 1 quizzes, based on 52 reviews, and has 423 subscribers.

You will learn about End-to-end training on the modern ETL tool – Talend DW and ETL concepts Role of Open Source ETL Technologies in Big Data Introduction to Talend TOS (Talend Open Studio) for Data Integration Architecture, Features, Advantages, Installation, GUI Layout Read & Write various Types of Source/Target System How to Transform Your Business with Talend Advanced components – tMap, tJoin, tFilter, tSortRow, tAggregateRow, tReplicate, tSplit, Lookup, tRowGenerator Triggers, Row Types, Context Variables, Functions, Job-level/Component-level Information Type Casting, Looping Components, tFileList, tRunJob How to schedule and run Talend DI jobs externally Working with Hierarchical File Structures Context Variables and Global Variables Best Practices Working with files (excel, delimited, JSON, XML etc.) Working with databases and implementing data warehousing concepts Orchestration and Controlling Execution Flow Files – Use components to List, Archive, and Delete Files from a Directory Database – Controlling Commit and Rollback Orchestrate several jobs in master jobs Handling Errors in Talend This course is ideal for individuals who are Talend ETL Application Developers or Talend Application Support Analysts or Anyone aspiring for a career as DW/ETL Specialist or Talend Developers and Engineers or Specialists App Dev – Big data (Talend) – Analytics & Business Intelligence or Newbies and Beginners interested in Data Engineering and modern ETL tools or Data Analysts and Data Consultants or Data Integration Engineers or Data Engineers and Data Scientists or Solution Architects or Data Warehousing / Big Data Professionals or Talend Big Data Developers or Individuals wishing to learn Talend ETL or Strategic Architects or Talend DI Developers or Talend Support Engineers or Talend Developers – Azure/ETL or Data Integration Leads or Talend Architects or Technology Consultants (Talend ETL Developer) It is particularly useful for Talend ETL Application Developers or Talend Application Support Analysts or Anyone aspiring for a career as DW/ETL Specialist or Talend Developers and Engineers or Specialists App Dev – Big data (Talend) – Analytics & Business Intelligence or Newbies and Beginners interested in Data Engineering and modern ETL tools or Data Analysts and Data Consultants or Data Integration Engineers or Data Engineers and Data Scientists or Solution Architects or Data Warehousing / Big Data Professionals or Talend Big Data Developers or Individuals wishing to learn Talend ETL or Strategic Architects or Talend DI Developers or Talend Support Engineers or Talend Developers – Azure/ETL or Data Integration Leads or Talend Architects or Technology Consultants (Talend ETL Developer).

Enroll now: Data Engineering and Data Integration Tools

Summary

Title: Data Engineering and Data Integration Tools

Price: $49.99

Average Rating: 4.3

Number of Lectures: 21

Number of Quizzes: 1

Number of Published Lectures: 21

Number of Published Quizzes: 1

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

End-to-end training on the modern ETL tool – Talend

DW and ETL concepts

Role of Open Source ETL Technologies in Big Data

Introduction to Talend

TOS (Talend Open Studio) for Data Integration

Architecture, Features, Advantages, Installation, GUI Layout

Read & Write various Types of Source/Target System

How to Transform Your Business with Talend

Advanced components – tMap, tJoin, tFilter, tSortRow, tAggregateRow, tReplicate, tSplit, Lookup, tRowGenerator

Triggers, Row Types, Context Variables, Functions, Job-level/Component-level Information

Type Casting, Looping Components, tFileList, tRunJob

How to schedule and run Talend DI jobs externally

Working with Hierarchical File Structures

Context Variables and Global Variables

Best Practices

Working with files (excel, delimited, JSON, XML etc.)

Working with databases and implementing data warehousing concepts

Orchestration and Controlling Execution Flow

Files – Use components to List, Archive, and Delete Files from a Directory

Database – Controlling Commit and Rollback

Orchestrate several jobs in master jobs

Handling Errors in Talend

Who Should Attend

Talend ETL Application Developers

Talend Application Support Analysts

Anyone aspiring for a career as DW/ETL Specialist

Talend Developers and Engineers

Specialists App Dev – Big data (Talend) – Analytics & Business Intelligence

Newbies and Beginners interested in Data Engineering and modern ETL tools

Data Analysts and Data Consultants

Data Integration Engineers

Data Engineers and Data Scientists

Solution Architects

Data Warehousing / Big Data Professionals

Talend Big Data Developers

Individuals wishing to learn Talend ETL

Strategic Architects

Talend DI Developers

Talend Support Engineers

Talend Developers – Azure/ETL

Data Integration Leads

Talend Architects

Technology Consultants (Talend ETL Developer)

Target Audiences

Talend ETL Application Developers

Talend Application Support Analysts

Anyone aspiring for a career as DW/ETL Specialist

Talend Developers and Engineers

Specialists App Dev – Big data (Talend) – Analytics & Business Intelligence

Newbies and Beginners interested in Data Engineering and modern ETL tools

Data Analysts and Data Consultants

Data Integration Engineers

Data Engineers and Data Scientists

Solution Architects

Data Warehousing / Big Data Professionals

Talend Big Data Developers

Individuals wishing to learn Talend ETL

Strategic Architects

Talend DI Developers

Talend Support Engineers

Talend Developers – Azure/ETL

Data Integration Leads

Talend Architects

Technology Consultants (Talend ETL Developer)

A warm welcome to the Data Engineering and Data Integration Toolscourse by Uplatz.

Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) concepts are core of any datawarehousing initiative. Data ingestion, integration, and processing form a critical task for consolidating the data silos across the departments in an organisation and ultimately to build a robust and flexible datawarehouse for enterprise reporting & analytics.

One of such tools is Talend. Talend is an ETL tool/software for Data Integration. It delivers software resolutions for data groundwork, data quality, data integration, application integration, data management and big data.

There exist separate products of these different solutions in Talend. Big Data products and data integration are broadly used in Talend. Data integration and data management solutions are offered by Talend, as an open source platform. Big data integration is a specialty of Talend. Other features provided by Talend are related to cloud, big data, enterprise application integration, master data management and data quality. It also provides a unified repository to store and reuse the Metadata.

Talend is one of the finest tools for cloud computing and big data integration. The most common invention of Talend Studio is data integration and big data. Talend can smoothly arrange big data integration with graphical tools and wizards. This permits the group to generate a condition to easily work with Apache Hadoop, Spark, and NoSQL databases for cloud. Talend data integration software tool has an open, accessible architecture. It permits quicker response to business needs. The tool contracts to modify and arrange data integration jobs faster than hand coding. Talend integration cloud tool offers connectivity, built-in data quality, and native code generation. Talend is protected cloud integration platform which allows IT and business users to connect shared both could and on-premise. It solves the power of cloud design job as it can manage, monitor, and control in the cloud.

Uplatz provides this end-to-end course on this leading Data Integration and ETL tool called Talend. With many organizations using Talend as their leading data warehousing and data integration software, there are huge career prospects by learning and mastering Talend. If you wish to become an ETL Architect or a Data Integration Engineer, then Talend course can be a complete game changer.

Talend – Course Curriculum

1. Role of Open Source ETL Technologies in Big Data

Overview on: TOS (Talend Open Studio) for Data Integration

ETL concepts

Data warehousing concepts

2. Talend

Why Talend?

Features

Advantages

Talend Installation/System Requirements

GUI layout (designer)

Understanding it’s Basic Features

Comparison with other market leader tools in ETL domain

Important areas in Talend Architecture: Project

Workspace

Job

Metadata

Propagation

Linking components

3. Talend: Read & Write various Types of Source/Target System

Data Source Connection

File as Source

Create meta data

Database as source

Create metadata

Using MySQL database (create tables, Insert, Update Data from Talend)

Read and write into excel files, into multiple tabs

View data

How to capture log and navigate around basic errors

Role of tLogrow and how it makes developers life easy

4. Talend: How to Transform Your Business: Basic

Using Advanced components like: tMap, tJoin, tFilter, tSortRow, tAggregateRow, tReplicate, tSplit, Lookup, tRowGenerator

5. Talend: How to Transform Your Business: Advanced 1

Trigger (types) and Row Types

Context Variables (parameterization)

Functions (basic to advanced functions to transform business rules such as string, date, mathematical etc.)

Accessing job level / component level information within the job

6. Talend: How to Transform Your Business: Advanced 2

Type Casting (convert data types among source-target platforms)

Looping components (like tLoop, tFor)

tFileList

tRunJob

How to schedule and run talend DI jobs externally (not in GUI)

7. Working with Hierarchical File Structures

Read and Write an XML file, configure the schema and XPath expression to parse an XML file

Read and Write a JSON file, configure the schema and JSONPath expression to parse a JSON file

Read and write delimited, fixed width files.

8. Context Variables and Global Variables

Create context/global variables

Use context/global variables in the configuration of Talend components

Load context variables from a flow

9. Best practices

Working with databases and implementing data warehousing concepts

Working with files (excel, delimited, JSON, XML etc.)

10. Orchestration and Controlling Execution Flow

Files – Use components to list, archive, and delete files from a directory

Database – Controlling Commit and Rollback

COMMIT at end of job/ every x number of rows

Rollback on error

11.Shared DB connection across jobs and subjobs

Use triggers to connect components and subJobs

Orchestrate several jobs in master jobs.

Handling Errors

Kill a Job on a component error

Implement a specific Job execution path on a component error

Configure the log level in the console

Course Curriculum

Chapter 1: Talend Introduction

Lecture 1: Talend Introduction

Chapter 2: Architecture and Installation

Lecture 1: Part 1 – Architecture and Installation

Lecture 2: Part 2 – Architecture and Installation

Lecture 3: Part 3 – Architecture and Installation

Chapter 3: File, Java, Filter Components

Lecture 1: File, Java, Filter Components

Chapter 4: tAggregateRow, tReplicate, tRunJob Components

Lecture 1: tAggregateRow, tReplicate, tRunJob Components

Chapter 5: Join Components

Lecture 1: Join Components

Chapter 6: Sort & Looping Components

Lecture 1: Sort & Looping Components

Chapter 7: Context

Lecture 1: Context

Chapter 8: Slowly Changing Dimensions (SCDs)

Lecture 1: Slowly Changing Dimensions (SCDs)

Chapter 9: tMap and tMap Components

Lecture 1: Talend tMap Components – part 1

Lecture 2: Talend tMap Components – part 2

Lecture 3: Talend tMap Components – part 3

Chapter 10: Talend Error Handling

Lecture 1: Talend Error Handling

Chapter 11: Audit Control Jobs

Lecture 1: Audit Control Jobs

Chapter 12: How to use tJAVA components with scenario

Lecture 1: How to use tJAVA components with scenario

Chapter 13: Talend Big Data Hadoop Introduction and Installation

Lecture 1: Talend Big Data Hadoop Introduction and Installation

Chapter 14: Talend HIVE Components

Lecture 1: Talend HIVE Components – part 1

Lecture 2: Talend HIVE Components – part 2

Chapter 15: Talend HDFS Components

Lecture 1: Talend HDFS Components

Chapter 16: Talend TAC

Lecture 1: Talend TAC

Chapter 17: End of Course Quiz

Instructors

Uplatz Training
Fastest growing global Technology & Cloud Training Provider

Rating Distribution

1 stars: 4 votes

2 stars: 3 votes

3 stars: 7 votes

4 stars: 18 votes

5 stars: 20 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!