- Role of Open Source ETL Technologies in Big Data
- Talend: A Revolution in Big Data
- Talend: Read & Write various Types of Source/Target System
- Talend: How to Transform Your Business: Basic
- Talend: How to Transform Your Business: Advanced 1
- Talend: How to Transform Your Business: Advanced 2
- Big Data Concepts: Required for Talend Big Data
- Introduction to Talend for Big Data
- Hive in Talend for Big Data
- Pig in Talend for Big Data and Project
1. Role of Open Source ETL Technologies in Big Data
- About Talend corporation and their journey
- Overviews on: TOS (Talend Open Studio) for Data Integration
- TOS for Data Quality
- TOS for Master Data Management
- TOS for Big Data
- ETL concepts
- Data warehousing concepts
2. Talend: A Revolution in Big Data
- 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 (paramaterization)
- 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 datatypes among source-target platforms)
- Looping components (like tLoop, tFor)
- tFileList
- tRunJob
- How to schedule and run talend DI jobs externally (not in GUI)
7. Big Data Concepts: Required for Talend Big Data
- How module 1 to 6 will help in understanding and performing hands on Talend for Big Data
- How Big Data will never be this easy to learn and use
8. Introduction to Talend for Big Data
- Big Data setup using Hortonworks Sandbox in your personal computer
- Explaining the TOS for Big Data Environment
9. Hive in Talend for Big Data
- How to create and access Hive tables in Talend
- Process and Transform data from hive
- Access data from Hive
- Transform and interact with MySQL tables