Talend Certification Training Course
![Intellipaat](https://static.mytechlogy.com/cache/120eb50138d5e4ddec9e3d84afbf6e36_w30_h30_cp_sc.gif)
Intellipaat
Course Summary
Talend training by Intellipaat will help you master data integration using Talend open studio. This online Talend ETL tool course will cover in depth concepts of data transformation, data extraction, connectivity with Hadoop and eco-system like MapReduce, Hive, Pig, and HDFS. You will work on real life projects and prepare yourself for Talend Data Integration Certified Developer Exam.
-
+
Course Description
About Talend Online Training Course
What you will learn in this Talend Certification Training?
- Learn what is Talend, Talend Open Studio and its uses
- Understand Data Integration, Data Modeling and concept of propagation
- Define how to aggregate data and T Map and its properties
- Use format data functions, XML file in Talend and import/create metadata
- Implement real-time Use Cases of Talend
- Define ETL methods and ETL tools to connect with Hadoop
- Work on project-Importing Mysql Data using Sqoop and Querying it using Hive
- Prepare for Talend Data Integration Certified Developer Exam
Who should take this Talend Training course?
- Data warehousing professionals, analyst, programmer
- Business analyst, BI developers
- Solution architect and data architect
- System administrators and integrators
- Thos wanting to be Data scientists
What are the prerequisites for learning Talend?
Anybody looking for better career opportunities can take up this course. A basic understanding of SQL can help.Why you should take Talend Training Course?
- 40% of all company data will be stored in public cloud by 2018 – Talend Survey
- 845 new companies are using Talend in the last 12 months – HG Data
- Average US Salary for a Talend Professional is $ 110,000 – indeed.com
-
+
Course Syllabus
Talend Course Content
Data Modeling ConceptsUnderstanding the basics of Data Modeling, its significance and how to deploy Data Modeling in Data Warehouse environment.Deep Dive into Data ModelingThe various types of Data Modeling, learning to perform Conceptual Data Modeling, Physical Data Modeling, Logical Data Modeling, understanding the scope and benefits of Data Modeling.Multidimensional Data ModelingThe basic Architecture of multidimensional modeling, deploying Cubes to perform multidimensional modeling, understanding the concepts of Facts and Dimensions and the differences between the two.Introduction to TalendThe Talend Open Source data integration tool, working with Big Data, understanding the Talend Open Studio.Talend InstallationUnderstanding the installation of Talend, system requirements, troubleshooting of common errors and issues related to installation.Talend Key FeaturesLearning about the Talend Architecture, important concepts and features, Talend components like Job, Workspace, Metadata, Project, etc.Talend Job CreationLearning to create a Talend Job, working with Delimited file, working with Meta Data, schema for data integration, understanding Propagation, deploying of tFilterRow and string filter for creating Jobs, creation of CSV file.Data Management TechniquesDeploying Talend Open Studio for Data Management, data quality, integration, understanding the ETL and Data Warehousing concepts.Schema & Data AggregationDetailed understanding of Talend Job design, it features, learning about tMap, data aggregation techniques, tReplicate for performing different operations on a Schema, tMap for mapping input and output data.DataSource ConnectionWorking with DataSource Connection, deploying in database component, creating a connection, database source and target, metadata and schema importing.Talend Routines/FunctionsIntroduction to Talend Functions, calling and deploying the Functions, understanding Routines, Talend Open Studio for XML data processing, date format function.Data TransformationTransforming Data, Running the Job, Combining Columns, Duplicating a JobWorking with MetadataCreating Metadata, Joining Data Sources.Data CorrectionsCapturing Rejects, Correcting the Lookup, Duplicating a JobData FilteringFiltering Output Data, Using Multiple Filters.Context VariablesUsing Context Variables from Talend Job, Repository as Metadata.Graphical Interface of TalendBuilding Jobs, Graphical Jobs, Graphical Interface Of Talend, Talend’s Components Naming ConventionTriggerRow – Main Connection, Row – Iterate Connection, Trigger – On sub Job ok Connection, Trigger – On Component OK ConnectionFile ManagementFile Management in TalendConnecting Talend with HadoopDeploying Talend to work with Hadoop, defining the ETL method, Hive implementation with Talend, importing data in Hive, Hive partitioning, Pig in Talend, data loading and parallel data execution.Talend ProjectProject – Creating Jobs using Metadata and using transformation stepsTopics – This project is involved with deploying metadata for creating a Talend job. Some of the steps involved are building various files like delimited, XML, and Excel, coming up with a database connection, deploying metadata, data integration schema, learning about propagation, working with tFilterRow for filtering rows on certain conditions on columns, creation of CSV files, and designing a Talend job.
This course is listed under
Open Source
, Development & Implementations
, Data & Information Management
and Networks & IT Infrastructure
Community
Related Posts: