Talend Data Integration Course

Explore the Talend development environment, navigate windows and views, learn the basic components and building blocks, and create your first job with a hello world console output.

Explore Talend data integration studio: create projects and jobs, navigate the repository and design workspace, configure components, and run or debug data integration tasks with 800+ palette components.

Explore Talend components as pieces that perform operations, like a my SQL input component that extracts data from table, or an Excel reader, and drag from the palette to workspace.

Drag and drop the Java component, configure it, and write code to print hello world, then save and run the job to see the generated Java code.

Read a file, display its content, and map input data to the output using the html component, the core processing element of talent transformation, highlighting good practices in talent development.

Create a Talend job to read a csv file with tFileInputDelimited and log rows via tLogRow; configure path, separators, header, and schema, then run to display data.

Map input data to the desired output using the tmap component, creating a job from a csv, and building outputs with transformation rules and concatenations.

Name sub jobs, show sub job titles, describe what your job does, use the color picker to set colors, and position components left to right, top to bottom.

In the Talend data integration course, explore how variables act as placeholders for values in program execution and the differences between three types of variables.

Developers define context variables and user-defined variables, assigning values for environment-specific configurations. These variables adapt file names and paths for development and production when a job runs.

Use Talend context variables to read dev and prod files without changing paths or separators. Define dev and prod contexts and variables for file name, path, field separator, and environment.

Create and use global variables in Talend with global map, which has no predefined data types, set string, integer, boolean values at runtime, and retrieve them with global map get.

Learn how to create and use global variables in a Talend job, declare them with the global map, print values, and use the PT Set Global Var component.

Compare context and global variables in Talend: context variables are set before run and can be changed outside the job; global variables are set at runtime and require job changes.

Create a context group to centralize file parameters across multiple Talend jobs, assign dev and prod environments, and attach this group to any job to replace individual variables.

Explore the team component in Talend data integration, mastering map expressions, ternary logic, intermediate variables in TX map, conditional splitting, and joining data with best practices.

Map colors from a delimited input to the Mario Kart data output using tMap, tFileInputDelimited, and import/export schema in a hands-on mapping data exercise.

Learn to create tMap output columns using map expressions, assign values from input, global variables, and the current date with the expression editor, and propagate the changes to the mapping.

Learn to implement conditional logic with the ternary operator in Talend data integration, using the expression editor to create is fast output and a Mario boolean from speed and character.

Discover how to use tMap intermediate variables to extend mapping capabilities, create and reuse var sections, and drive outputs with expressions, while managing variable types and keeping mappings maintainable.

Split the input data into two outputs using conditions in the Talend t map, creating fast characters and slow characters, and configure filtering, naming, and output order.

Name sub jobs and links to describe their function, add descriptive component titles, and improve the readability of Talend data integration jobs.

Explore tMap functions for data transformation in Talend, learning to create intermediate variables, convert text to lowercase with down case, and apply expressions to outputs.

Explore how to join data from inputs in Talend using a key to create a consolidated output, covering left outer join and inner join with examples of players and colors.

Join two data sources in Talend data integration using tMap by linking a character file with a quotes file through the character key. Compare left outer and inner joins.

Discover how to use Java within Talend data integration jobs and leverage standard components to process data without code, with techniques for adding custom Java when needed.

Learn how to use the tJava component to insert custom Java code, declare global and local variables, and print the job name and current date.

Explore the tJavaRow component in Talend Data Integration, using its code editor to map input to output and generate schema-driven Java code, then add a new is fast column.

Explore advanced tJavaRow usage in Talend Data Integration by building a JSON object from input columns and speed-based logic. Compare its Java code flexibility with the tMap approach.

Discover the tJavaFlex component in Talend data integration, using start, main, and end code sections to implement pre, per-row, and post processing with a Java editor.

Handle an advanced tJavaFlex part 2 example by reading characters, adding them to an ArrayList of strings, and printing the final list.

Learn techniques to read and write data for CSV, Excel, XML, and G.S. files, and manage records by appending data, capturing file properties, and listing directory contents.

Learn to read a csv file with the pt file input delimited component, configure the schema, and explore limit, encoding, and trimming in data mapping.

Learn to read data from an excel file using the file input excel component, configure sheets, headers, and schema, and propagate data to subsequent sub jobs.

Learn to read json files in Talend data integration by configuring the pt file input design, extracting name, classification, and speed from the character array, and mapping to a schema.

Learn to read XML files in Talend Data Integration by configuring the XML input, extracting character data (name, classification, speed) with loop path queries, and validating with an example.

Learn to read data with tFileInputDelimited and write to a delimited csv using tFileOutputDelimited in a Talend data integration workflow. Configure output path, header inclusion, and separators.

Write data to an Excel file with Talend using tFileOutputExcel, map input columns, add a current date column, set utf-8 encoding, and configure sheet, path, and append options.

Explore writing data to a json file with the rt file output decent component, configure the path and Mario Data data block, then generate an array design.

Configure the t file output xml component to write data to an xml file, set file name and path, apply the schema, and structure output with root and characters tags.

learn to use the file properties component to retrieve and display key attributes, including absolute path, base name, size, read and write permissions, and last modified time, in a table.

List and iterate files in a directory with Talend RT file list and TFI list, using file masks and outline variables to extract properties and paths.

Explore file operations in the Talend data integration course, including copying, moving, renaming, and deleting files, and handle archiving, zipping, unzipping, and existence checks to ensure reliable workflows.

Learn to copy and rename files in Talend data integration using the HT file copy component, create archive folders, remove source files, and overwrite existing ones.

Learn to delete files with the rt file delete component by specifying the path and file name, and note that deleted files do not go to the recycle bin.

Learn to check if a file exists before operations to avoid errors. Use the PT File exists component and conditional run logic to delete only when the file exists.

Archive and unarchive XML files from input folder to the archive folder by creating a zip with a file mask and UTF eight encoding, including overwrite and optional password protection.

Learn to connect to a database, extract, write, and delete data from a table using the on my school database, with mechanisms also for Oracle and Microsoft Server.

install and configure a mysql database on mac, including downloading server, setting root password, installing workbench, and creating a new database (super mario) for this talend data integration course.

Install and configure a MySQL database on Windows, downloading the MySQL server and workbench, setting a root password, and starting the server. Create Super Mario database and practice with Talend.

Learn to create and configure a MySQL database connection in Talend, including host, port, database, user, and password, and reuse parameters via a context group.

Learn how to extract data from a MySQL database using the Talend MySQL input component, including creating a table, inserting data, and defining a schema.

Learn to read from a database, join with a CSV file, and write to a MySQL table using Talend, including create if not exists, insert or update, and commit options.

Learn to delete data from a MySQL table in Talend using the GDB output with a deletion key, apply filters for records, and execute deletions via a SQL row approach.

Navigate how data moves across components and systems and learn to modify it using Titan's process and components, mastering filtering, sorting, aggregation, min/max, counting, and find-and-replace operations.

Learn how to sort data in talend data integration by using the sort component to order by numeric speeds and alphabetical racers, including multi-criteria priority and ascending or descending options.

Learn to filter data in Talend data integration using the TW filter row to create conditions and manage filtered and rejected rows.

Apply data aggregation in talend data integration using fixed flow input and aggregate row to compute min, max, sum, average, count, and list outputs by racer.

Learn how to replace data in Talend using both the Java replace function and the tReplace component, including setting up the job, matching whole words, and case sensitivity.

Learn to filter columns in Talend data integration using the TW filter colors component, adjusting input and output schemas, reordering or removing colors, and propagating changes for the job.

Learn how to replicate incoming data into multiple identical outputs using the PT Replicate component, enabling simultaneous writes to a file and a database in Talend data integration.