What you'll learn:
Starting Talend Studio,
Reading data from MySQL database tables
Creating tables in MySQL databases
Applying best practices
Using database metadata
Using generic schemas
Updating metadata
Error Handing
SCD Type 1
SCD Type 2
Requirements
none
Description
Talend Studio for Data Integration dramatically improves the efficiency of data integration Job design through an easy-to-use graphical development environment. With integrated connectors to source and target systems, it enables rapid deployment and reduces maintenance costs. It supports all types of data integration, migration, and synchronization.
This course helps you use Talend Studio for Data Integration as quickly as possible. It focuses on the basic capabilities of Studio and how you can use it to build reliable, maintainable data integration tasks that solve practical problems, including extracting data from common database and file formats, transforming it, and integrating it into targets.
What you will Learn
Starting Talend Studio
Creating your first Job
Running a Job
Using the component help
Designing a Job using best practices
Creating and Reading Tables
SCD Type 1 and SCD Type 2
Error Handing
Working with delimited files
Working with hierarchical files
Creating tables in MySQL databases
Reading data from MySQL database tables
Applying best practices
Using database metadata
Using generic schemas
Updating metadata
Mapping data using tMap
Joining data using tMap
Capturing join rejects
Filtering data and capturing filtering rejects
Using other data processing components
Creating a built-in context variable
Connecting to databases using context variables
Creating a context group in the repository
Loading context variables from a flow
Building a stand-alone Job
Building a new version of the Job
Building a Docker image
Managing files
Processing files
Managing Job execution using a master Job
Detecting and handling basic errors
Raising a warning
Who this course is for
Students, professional, Website Developer, graduates, post graduates students, Data base expert
Homepage

https://www.udemy.com/course/workig-with-mysql-databases-using-talend-studio/