• views: 153
• date: 9 September 2023
• posted by: voska89

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
Requirements
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)
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 typesreading and writing from databasesprocess different file formats, like Excel, XML, JSON, delimited, positionalcreate and use metadatabuild schemasuse helpful keyboard shortcutsretrieve data from WebServices / RESTconnect to GoogleDrive and fetch datausing iteration and loopsconvert data flows into iterationsbuild and understand job hierarchiesAll major transformations: Map, join, normalize, pivot, and aggregate datacreate and extract XML and JSONuse regular expressionsOrchestrate components in processesCheck and improve data qualityUse fuzzy matching and interval matchingUse variables for different environmentsPerform schema validationHandle reject data separatelyFind and fix errors quicklyWrite meaningful logsInclude and react to warnings and abortsBuild job hierarchies and pass data between different levelsimplement and test your own assumptionsconfigure your project for logging, versioning and context loadinglearn best practices and establish your owndocument items and have documentation generatedWhat 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
Homepage

https://www.udemy.com/course/data-integration-etl-talend-open-studio-zero-to-hero/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.