Talend is a comprehensive data integration and management platform that empowers data scientists and other data professionals to work with diverse data sources, ensuring data quality and facilitating the integration of data for analytical purposes.
Talend is a comprehensive data integration and management platform that empowers data scientists and other data professionals to work with diverse data sources, ensuring data quality and facilitating the integration of data for analytical purposes.
Talend
Database
Datawarehouse
Capstone Project
Introduction to Talend
What is ETL?
What are the advantages of Talend etl tools?
A quick tour of prerequisite software - java, Talend, SQL etc
Repository, Designer, Palette, Outline, Configuring tab.
Java behind Talend
Exporting/importing Talend Job.
Extracting data from File Excel - tFileInputExcel
Extracting data from File delimited – tFileInputDelimited
.
Extracting data from File delimited/Excel using Metadata
.
Assignment.
Installation of PostgreSQL and Dbeaver
Basics of SQL – Create, drop, insert, truncate delete records into the table
Basics of SQL – Delete, Alter, Update, Commit, Rollback
Extracting data from DB table/using Metadata – tDBInput
.
Processing component – tFilterRow
Using SQL – Where clause
tFilterColumn
tSortRow and Using SQL – Order by clause
Load the data into File, Excel – tFileOutputDelimited, tFileOutputExcel
Load the data into Table – tDBOutput
Connection Links
tFileList
tFileCopy, tFileDelete
tFileArchive, tFileUnarchive
tFileCompare, tFileRowCount, tFileProperties
tChangeFileEncoding, tFileTouch
tMap basics
tMap advance
tMap Join
SQL – Joins
tJoin
tReplace,tConvertType
SQL- Replace, Typecasting
tAggregateRow, tAggregateRowSorted
SQL – Aggregate Functions
tNormalize, tDenormalize
tSampleRow
tDBOutputBulk, tDBBulkExec, tDBOutputBulkExec
tDBRow
tLoop
tForEach
tInfiniteLoop, tSleep, tFileExist
tUnite, tReplicate
tWaitForFile
tWaitForSQLData
tFlowToIterate,tIterateToFlow
tRunjob, tPrejob, tPostjob
tJava
tJavaRow
tJavaFlex
tSetGlobalVar
tSystem
Assignment.
Explanation with job – tContextLoad, Implicit tContextLoad, tContextDump.
Note, tRowGenerator, tFixedFlowInput
tMsgBox
tBufferInput, tBufferOutput
tHashInput, tHashOutput
tFlowMeter, tFlowMeterCatcher
tMemoriseRow
Assignment.
Creation of AWS account and Access Key, Secret Key
tS3Close, tS3Connection, tS3Copy, tS3Delete, tS3Get, tS3List, tS3Put
SQL String and Date functions
Window functions
DWH – Datawareshouse, Data mart
DWH – Schema, Keys
DWH – Dimension, Fact
SCD1
SCD2
Introduction to TMC, Deployment and Scheduling of jobs.
Hands On Implementation of 2 Real World Projects ( Datawarehouse + Data Lake + Data migration ) .
Resume preparation + Mock Interview Practice + Dedicated Mentor Placement Guidance .
Capstone Project
Mock Interview
Resume Building
Referrals
Training by Our dedicated trainers, with an experience of 12+years in the same field.
Every session followed by self practice assignment and recorded videos accessible using mobile app and web.
Scenario based interview question and answers.
Mock interviews after completion of training.
Practice and doubts clarifications sessions after the training.
Guaranteed placement for students that are successful in their assigned training project.
Course Certificate for successful students from Academy of Data by Rekindle Technologies.
