Remote Training: Introduction to ECL (Part 2)

Remote Training: Introduction to ECL (Part 2) - the Extract, Transform, and Load (ETL) Process

The class will be held remotely via Microsoft Teams. Your instructor will contact you before the class with login information.

NOTE: RELX and LexisNexis employees should register using the approved promo code provided by their manager or contact training@hpccsystems.com.

Note: This course is the second in a two-part introductory series. People who attend the Introduction to ECL (Part 1) - Concepts and Queries class, should continue with this class.

This intermediate level class is for developers who want to extend their knowledge of ECL to Extract, Transform, and Load (ETL) any data with the HPCC Systems environment. Anyone planning to write and work with ECL code should attend this course.

Course Length: 2 days

Class Prerequisites: Students must have attended the  Introduction to ECL (Part 1) - Concepts and Queries training class. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

• Principles of ETL in ECL
• The TABLE function (Memory Tables)
• TRANSFORM functions (PROJECT, etc.)
• Data Hygiene (Cleaning and Standardization)
• Lookup Tables
• OUTPUT to disk files
• Simple JOINs
• New! Data Patterns and Visualization

Class will begin at 9am and conclude at 5pm. Breaks will be provided throughout the day for lunch and lab assignments. Your instructor will provide more information before the class begins.