Talend Advanced for Big Data, Cloud and Database integration

Description

In this course, you will learn :

• Connect to Big Data and Cloud platforms such as Snowflake, Amazon S3, and MongoDB.
• Make use of advanced database features like stored procedures, bulk loading, ELT, and SCD.
• Make use of custom Java code, libraries, and third-party components.
• Utilize existing procedures and learn a variety of data conversions.

Syllabus :

1. Advanced Database Techniques

• Database Connection
• Schema Handling
• Data Type Mappings
• Bulk Load
• ELT vs. ETL
• Stored Procedures (SP)
• Slowly Changing Dimensions (SCD)
• Transactions
• Output Rejects
• Output Rejects for other databases than MySQL

2. Big Data And Cloud

• Apache Kafka
• Apache Cassandra
• MongoDB
• Google BigQuery
• Snowflake
• Amazon S3

3. More Integrations

• FTP
• Email

4. Convert Data Types

• General Conversions
• Convert Strings
• Avoid NullPointerExceptions

5. Use Talend And Custom Routines

• Character And String Routines
• Date And Time Routines
• Arithmetic Operations Routines
• Currency Handling
• Develop And Use Custom Routines

6. Custom Java Code

• tJava Component
• tJavaRow Component
• tJavaFlex Component
• Java Properties
• Use External Libraries
• Use External Components

7. Performance

• Performance Tuning Approach
• Performance Techniques
• Common Pitfalls
• Buffer Components
• Hash Components
• JVM Parameters
• Parallel Execution

8. Use Cases

• Nested Conditions with Ternary Operator and If Statements
• Read Large XML Files quickly
• Iterate Over Date And Time
• Currency Conversion With REST Service
• Access Previous Row in a data flow
• Cancel Jobs With tJavaRow
• Add File Header And Footer
• Data Tests

Show more